RE: Serial fields

I'm guessing you're using an insert cursor? Ordinarily you get the new serial value from sqlca.sqlerrd[2], but with an insert cursor I could not find a way to get the serial number. Doubt that it's possible: how is the engine going to reserve numbers for records in the insert buffer when someone else inserts in the same table? > -----Original Message----- > From: Sergio L'pez [SMTP:sergiol@iteso.mx] > Sent: Thursday, October 21, 1999 12:27 PM > To: informix-list@iiug.org > Subject: Serial fields > > > Hi all! > > When you insert a new record in an Informix table, and if the table > contains a serial field, the next serial number is not calculated until > you post the record to the table. Is this true? > > Is there any way to know what the next serial number will be after > inserting a new record, but before saving the record to the table? > > I will appreciate any comment or hint. > >