Subject Re: [firebird-support] select field that is reserved word
Author Thomas Steinmaurer
> How in FB 1.5 can I do a select with a field that is a Firebird reserved
> word? In this case it is the reserved word ACTION.
> In Interbase you can enclose the field name in double quotes, but that
> doesn't work in Firebird as it will produce the literal string rather than
> the table data.

It needs to be a dialect 3 database. In a dialect 1 database, either
single or double quotes are used as string terminators. In any case,
single quotes are recommended to make the transition of an application
from dialect 1 to 3 easier.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/