🚀 go-pugleaf

Double ' inside string - i.e.

insert into some_table (some_col) values ('lil''devil')

You could do this with AnsiQuotedStr(strValue, "'"). Or, better way, use
parameters in query and pas string as parameter.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Daniele Borini" <borini@infinito.it> ???????/???????? ? ???????? ?????????:
news:415c78d9@newsgroups.borland.com...
> hi averybody,
> maybe it's the right place, but i've got this problem:
> when i need to build a query which inserts or updates a table with
> string fields i use ' to indicate string fields, but i've got errors
> when the string contains ' itself e.g. 'lil'devil' causes an error, i
> tried to replace ' with its ASCII value but it's the same.. how could i
do?
> I'm using ADO+BCB6+ACCESS DB.
> TIA Dan