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!
