SubstitutedSQL not wrapping strings in quotes

[phelton]

I am using Delphi 5, Oracle 8.1.6 with an 7.3 client, and DOA 3.4.6.

When I use SubstitutedSQL for an OracleDataSet, my parameter which has a string value passed in does not get wrapped in quotes. The parameter is declared as otSubst, and the value being fed in is a parameter being pulled from a TQuery.Params.AsString.

How can I ensure that my strings get wrapped in quotes?

------------------
Phyllis Helton
Information Services Manager
The JESUS Film Project
www.jesusfilm.org

 

[Marco Kalter]

The substitution variable in the SQL text is replaced with its value as is. No interpretation/modification is performed. If you want quotes, you will have to add them yourself.

------------------
Marco Kalter
Allround Automations