Phil
Put a method in you Tdatabase decendant "QuoteString", that way it is
invisible (PHP do it this way with their new PDO)
Neven
Phil Middlemiss 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.
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
--
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062
New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland
Ph 620 1356
Fx 620 1336
begin:vcard
fn:Neven MacEwan
n:MacEwan;Neven
email;internet:[EMAIL PROTECTED]
tel;work:649 620 1356
tel;fax:649 620 1336
tel;cell:0274 749 062
version:2.1
end:vcard
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi