This is a dialect 1 database. I think it is as it is a restored IB 5.6
dialect 1 database.

Does that mean there is no other way then doing select * then?



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 27 September 2008 10:28
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] select field that is reserved word

> 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. <http://www.upscene.com> com
My blog:
http://blog. <http://blog.upscene.com/thomas/> upscene.com/thomas/





[Non-text portions of this message have been removed]