Re: value of last SERIAL inserted?

Posted in 1994

Jim Burks — 31 Jan 1994 21:21:21 GMT — source: Informix-list mailing list archive (1991-1998)

In article <135180001@hpcss01.cup.hp.com> stefanis@hpcss01.cup.hp.com (Nick Stefanisko) writes: >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? > ___ >Integrated / / Nick Stefanisko [KD6PTD] >Systems HEWLETT/hp/PACKARD stefanis@hp-ptp.ptp.hp.com >Division /__/ Sunnyvale, California, USA > >Opinions expressed here are not those of my employer; only my fingers >are to blame. The ESQL/C 5.0 reference describes the sqlca structure on page 7-4. The variable sqlca.sqlerrd[1] is described as returning the serial value after insert. The sqlca structure is also referenceable from 4GL code. ----------------------------------------------------------------- Jim Burks jburks@promus.com The Promus Companies Memphis, Tennessee, USA