Search and replace all the reserved words in your application with a non reserved alternative. Then change all the reserved filenames in yr DB Alan
Alan McDonald On 12/03/2012 7:11 PM, "talshapira" <[email protected]> wrote: > 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. > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed]
