Hi all,

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 ?


Thanks,
Tal.