Hi We are using Java 1.3 and need to find out the Primary Key (SERIAL) of the latest insert done. Currently we are using a query like
select count(*) from "Party" to obtain the latest Primary Key. This is not really reliable because at the same time another user at another machine (program code resides on each machine) could have inserted a new record just before we execute the count query. On Sybase we could use select @@identity how would it be done on SAP? Any experience, any ideas? Many thanks for your help in advance. Best regards Daniel _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
