AnsweredAssumed Answered

FM10 AdvSrv - JDBC questions

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

Title

FM10 AdvSrv - JDBC questions

Your post

Hi,

 

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

 

TIA

Outcomes