Subject | Re: [firebird-support] select field that is reserved word |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-09-27T09:27:37Z |
> How in FB 1.5 can I do a select with a field that is a Firebird reservedIt needs to be a dialect 3 database. In a dialect 1 database, either
> 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.
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/