I'm aware of that but it has a bit of an overhead as my generic function to execute the SQL statement somehow needs to detect if the insert statement contains a serial and if it does then issue the SELECT [<owner>.]<table name>.CURRVAL statement to retrieve it. Either that or always try to issue the SELECT statement to retrieve the value and ignore errors if the table does not contain a serial. Either way its messy and an overhead :-( Having the last value stored somewhere in SQLCA would be much nicer!
David -----Original Message----- From: Dittmar, Daniel [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 15:43 To: 'David N. Heydon'; '[EMAIL PROTECTED]' Subject: RE: PTS 1118457 of 7.4.03.17 > Thats a shame :-( Please could you add this to the feature > request list for > the precompiler for me? Presumably now the kernel has been modified to While you're waiting for this feature to be implemented, you can use [<owner>.]<table name>.CURRVAL in SQL statements (PTS: 1118327). Daniel Dittmar -- Daniel Dittmar 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
