This one I know: SELECT MY_TABLE.CURRVAL FROM SYSDBA.DUAL
returns the last self-generated SERIAL. Notice that if you specify a value for the serial field in your insert statement, no serial is generated but the specified value is inserted. In this case, the above statement returns an error (-2029:CURRVAL is not yet defined in this session) ----- Original Message ----- From: Alejandro Michelin Salomon To: Sapdb General List Sent: Wednesday, March 19, 2003 8:52 PM Subject: Serial column Hi : I have a column default serial. How to now de last serial number generated ? I insert a record, and after this i need de serial number inserted. Thanks Alejandro Michelin Salomon PROBrax e-Tech, Brasil _______________________________________________ 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
