Re: Retrieving a serial number

Use SQLCA.SQLERRD[1] Look at sqlca.h ---------------------8<---------------------- long sqlerrd[6]; /* 0 - estimated number of rows returned */ /* 1 - serial value after insert or ISAM error code */ /* 2 - number of rows processed */ /* 3 - estimated cost */ /* 4 - offset of the error into the SQL statement */ /* 5 - rowid after insert */ ---------------------8<---------------------- Kai ---------- Von: Jamie[SMTP:jamie@cim.co.uk] Gesendet: Dienstag, 21. April 1998 11:41 An: informix-list@iiug.org Betreff: Retrieving a serial number > > > -- > NOTE: This Electronic Mail Message has been > checked by Anti-Virus Software. If you > have any queries please contact the MIS > Department (Extn. 7050). > -- > > > hi there, > > how does one get the value of a serial column after inserting a row? i > haven't been able to find anything on this... > > thanks > ///daly > > > > LET l_serial = SQLCA.SQLERRD[2] (do this after the insert) Jamie