Subject Re: [firebird-support] Reserved words as column names
Author Martijn Tonies

> I'm new to firebird.
> I have a legacy application that is working with MS SQL Server, and i
> would like to migrate it to Firebird.
> I was able to install and connect to the DB, but i encountered a probleme
> i couldn't resolve :
> In many of the tables i have the column names YEAR and MONTH. I was able
> to create the tables with these columns but when I select the table I get
> the following error :
> select year from T_TABLE;
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 8
> year
> If i change the query and add quotes around the column name it works:
> select "year" from T_TABLE;
> Is there a way to make the query work without running on the entier
> application and adding quotes ?


With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!