AnsweredAssumed Answered

FM10 AdvSrv - JDBC questions

Question asked by Ice72 on May 11, 2009
Latest reply on Jun 15, 2009 by Ice72


FM10 AdvSrv - JDBC questions

Your post



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)?