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

Reply via email to