> The thing you're searching for is the CURRVAL attribute/function. You > can now use > SELECT test_table.currval from SYSDBA.DUAL > to get the last value used in the SERIAL column.
That is great, but is it possible to obtain last inserted value with query that doesn't depend on table name? My problem is that I have class with method something like GetId() without table parameter and have large project implemented with this class. If I want to use SAPdb I must port this class to use SAPdb (ODBC) and implement various functions - the only problematic method is GetId() - because it's not "defined" in SQL92 (how to get last inserted auto increment value through SQL)... Regards, Vladislav Bjelic P.S. Something like: "SELECT $currval FROM SYSDBA.DUAL" ;-) P.P.S. Happy New Year! :-) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
