double quotes are normally allocated for field names. strings are single.
pass your data as a param and save yourself the concern of it being a pain.
eg
'where x = ''tod'' ';
to
'where x = :Filter'
parambyname('filter') := mydata
it will become more readable also.
I'm sure I am stating the obvious, but ....
On Tue, 13 Dec 2005 09:28:59 +1300, Phil Middlemiss <[EMAIL PROTECTED]>
wrote:
Sometimes I can use double quotes when adding a string to an SQL query
using Firebird with the Interbase Components. Other times I get an SQL
error and have to resort to using single quotes (which is a pain if the
string contains an apostrophe).
Can someone set me straight on the conditions under which single or
double quotes can be used in a query?
Cheers,
Phil.
--
Kyley Harris
+64-21-671821
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
