Subject | Re: [IBO] IB_Query: problem with no Quotations in Insert Statements |
---|---|
Author | Andreas Hesse |
Post date | 2005-06-24T07:30:02Z |
Lester Caine wrote:
I would like to have a switch to tell ibo to use quotations for field
names in the insert/edit/delete statement.
That would do the trick.
> Andreas Hesse wrote:IBO create this insert statement automically.
>
>
>>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.
>
I would like to have a switch to tell ibo to use quotations for field
names in the insert/edit/delete statement.
That would do the trick.