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.
