Re: Getting serial value of just inserted record

Posted in 1997

Dragi Raos — Thu, 13 Nov 1997 21:35:56 +0100 — source: Informix-list mailing list archive (1991-1998)

AndreasSeibt wrote: > > I have to write a stored procedure which inserts a record into a table. > This record has a field of Type SERIAL as primary key. I need the value of > the primary key directly after inserting the record for subsequent > processing. Is there any way to get this value? > > I use INFORMIX-Online 7.23. > > Many thnks for your help > > Andreas sqlca.sqlerrd[1] (C syntax), SQLCA.SQLERRD[2] (NewEra and, presumably, 4GL). Some development tools have their own syntax (e.g. JAM & Prolifics @dmserial). HTH Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+