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" <talshapira@...> 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]