Subject | Re: [firebird-support] Using reserve words in queries |
---|---|
Author | Helen Borrie |
Post date | 2005-03-01T23:05:12Z |
At 03:54 PM 1/03/2005 +0000, you wrote:
be able to use reserved words as identifiers AT ALL.
What tool are you using to create the database?
./heLen
>I'm new to Firebird and a little lost. I am using v1.5.2 embeddedThe Langref is correct. However, if your database is Dialect 1, you won't
>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?
be able to use reserved words as identifiers AT ALL.
What tool are you using to create the database?
./heLen