Subject | Using reserve words in queries |
---|---|
Author | Christopher Walls |
Post date | 2005-03-01T15:54:35Z |
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?
Thanks
Chris
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?
Thanks
Chris