0 Replies Latest reply on May 18, 2009 12:33 AM by Ice72

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

    Ice72

      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