Re: value of last SERIAL inserted?

Posted in 1994

Jonathan Leffler — 31 Jan 1994 11:28:22 -0500 — source: Informix-list mailing list archive (1991-1998)

>From: stefanis@hpcss01.cup.hp.com (Nick Stefanisko) >Subject: value of last SERIAL inserted? >Date: Thu, 27 Jan 1994 23:48:42 GMT > >I know there is an ESQL command to return the value of the last >SERIAL inserted into a table but I can't remember what it is or >where to find it. Pointers anyone? In ESQL/C, sqlca.sqlerrd[1] contains the serial value up to the time the next SQL statement is executed. Guide to SQL (Dec 91): p 5-8. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>