Hi,

> 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 ?

No.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

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