ODBC / FM9Srv

[Ice72]

Hi,

I'm trying to use a JDBC client to connect to FM9Srv.

I have a table "test" with a PK "id" (auto-increment).

I need, from the JDBC connection, BEFORE insert a record, to know the next usable ID value. If this isn't possibile, there is any way to know it after the INSERT without execute a select?

TIA