AnsweredAssumed Answered

FM10AdvSrv on Win2003 - JDBC - Missing API to retreive primary key

Question asked by Ice72 on May 18, 2009

Summary

FM10AdvSrv on Win2003 - JDBC - Missing API to retreive primary key

Description of the issue

Hi, I execute a JDBC "INSERT" on a test table "A" (which have a primary key thatis an auto-inc integer) . The insert works correctly, but I need to obtain thePK value  generated from FM10. I haven't see any dedtated-SQL-statement which allow me to retreive thevalue. I don't want to use "SELECT max(id) FROM a" due to concurrency problemand slowness (1 seconds to execute the SELECT, with a powerful-machine,on a 4MByte single table FP7 file). Could you provide this function? Thanks in advance

Outcomes