> With the next SAPDB version you can get the last serial value via the > currval function specifying the table name, i.e. > > SELECT TEST.CURRVAL INTO ? FROM SYSDBA.DUAL; > > or easier in a db-procedure > > VAR currVal integer; > currVal = TEST.CURRVAL;
next release? even if it is version 7.3.xx? any release scheduled? >>Is it solved in v7.4? >>when will it be released? > > 7.4 will have the same behavior. OK, but how can i make sure, the last value i get is the right one? does CURRVAL only work within a trabsaction? or is it saved per "connection" - like mysql's last_isert_id() i think. in other words: will it be save to query CURRVAL after a commit? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
