Sven K�hler wrote: > 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? This feature is planed for 7.3.0.29 which will be released in the next 2 weeks. >>>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? No >or is it saved per "connection" - like mysql's last_isert_id() i think. yes >in other words: >will it be save to query CURRVAL after a commit? yes Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
