Subject | IB_Query: problem with no Quotations in Insert Statements |
---|---|
Author | Andreas Hesse |
Post date | 2005-06-23T20:24Z |
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
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