Subject IB_Query: problem with no Quotations in Insert Statements
Author Andreas Hesse
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.

Regards,
Andreas