[Firebird-odbc-devel] OdbcJdbc driver and FB 2.x SQL

[Laurent R. <lau...@ha...>]

Hi,

I'm using the OdbcJdbc driver ver 2.00.00.144 and I am having trouble with
some SQL statements when using FB 2.x syntax.
For instance, when I try to prepare the following statement "SELECT NEXT
VALUE FOR mygenerator FROM RDB$DATABASE", which is OK in ISql, I get the
following error in ODBC :

[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 13
VALUE

It seems that the driver doesn't like the VALUE keyword. I have the same
trouble on keyword LOCK in a "SELECT ... WITH LOCK" statement.

Is there a way to make the driver accept these statements ?

Thanks for any help