Subject Re: [firebird-support] Using reserve words in queries
Author Helen Borrie
At 03:54 PM 1/03/2005 +0000, you wrote:



>I'm new to Firebird and a little lost. I am using v1.5.2 embedded
>database. For the most part, I have been able to create my database
>with tables, columns, default values, auto increment generates,
>triggers, etc. One item I am stuck on is escaping reserved words.
>The database I need to create has a table named Procedure. I have
>tried all of the following statements:
>
>Double Quotes ==> Create Table "Procedure" (Col1 varchar(10));
>Single Quotes ==> Create Table 'Procedure' (Col1 varchar(10));
>Backwards Single Quotes ==> Create Table `Procedure` (Col1 varchar
>(10));
>
>I get a "Token Unknown" error on "Procedure".
>
>I must be missing something, but page 16 of the Language Reference
>PDF seems to indicate that double quotes should be used.
>
>Environment
>==================
>Windows XP SP2
>Firebird 1.5.2 embedded (I also have the server installed)
>The database appears to be using Dialect 1.
>ISQL and FlameRobin both report this error
>
>
>How can I escape key reserved works in my queries?

The Langref is correct. However, if your database is Dialect 1, you won't
be able to use reserved words as identifiers AT ALL.

What tool are you using to create the database?

./heLen