Hi,

> 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));

The above should work just fine on a Dialect 3 database.

> 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

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com