Andreas Hesse wrote:

> I have a table with a reserved keyword as field name (year).
> The table was created with quotations in the create table statement
> (work).
> The Select statement work: select * from crosstest
> But the generated Insert statement throws an exception:
>
> ISC Fehlermeldung:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 4, char 3
> YEAR
>
>
> I look for a property to use quotation, but didn't find any.
>
> The automatic insert statement look like this:
> INSERT INTO CROSSTEST (...,YEAR,...) VALUES (...,:YEAR,...)
> -> exception
>
> should look like:
> INSERT INTO CROSSTEST (...,"YEAR",...) VALUES (...,:YEAR,...)
> -> will work
>
> If it is not a feature of IB, then this is a feature request.

Nothing to do with IBO!
In order to use YEAR as a field it has to be defined as "YEAR" in
Firebird. Every tool then has to use the "YEAR" format to access it.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services