FM10 AdvSrv - JDBC questions
I have a FM10-file which have an auto-inc PK field ("id").
With JDBC I could insert a record without specifying the "id" field (so FMSrv
must generate it).
How can I detect the generated ID, via SQL? I don't want use MAX() function
due to concurrencies problem ...
Another question: is there any way to lock a table (like "LOCK <tbl>" SQL statement)?