Re: Retrieving correct SERIAL number of new row

Posted in 1997

Bill Ennis — 7 Feb 1997 10:23:30 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, Well - if you are using ESQL/C you can reference sqlda.sqlerrd[1] and it will contain the serial value after the insert. -Bill > > After I insert a row containing a "SERIAL" column, how do I retrieve the > "serial number" of that row (I need to record that number elsewhere). > > I especially have a problem since multiple people may be inserting rows > very close to simultaneously; the row I insert may not be the last row > (highest SERIAL number) by the time I read it out. > > Please send suggestions to olpe@ep.com Thanks much in advance! > > -Pete- > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com