Subject Re: [firebird-support] Re: Using EXECUTE STATEMENT in Stored Procedures
Author Martijn Tonies
>> String values should be enclosed in single quotes, in Delphi, you
>> can easily escape single quotes with two single quotes by using
>> the QuotedStr function.
>> O'Reilly then becomes:
>> 'O''Reilly'
> Thanks for your reply with this question. I just re-read my post and
> realized that I wasn't being as clear with this as I could have been.
> When I wrote 'double quotations' I meant two single quotations side by
> side, and not a single double quotation (").

Two single quotes to surround a string value doesn't make sense:
you're starting a string, ending it immediately, having the value and
then starting and ending a string again ;-)

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: