Re: Get key of row just inserted?

Posted in 1998

Tony Tyrwhitt-Drake — Tue, 24 Feb 1998 22:57:49 -0000 — source: Informix-list mailing list archive (1991-1998)

flint weiss wrote in message <34F30F38.9FB2E375@nospam.com>... >hello all, > >i have a table using SERIAL keys. >i want to insert a new row and then get the 'new' key of that row. >is there a way to find the key of the row just inserted? The sql communications area (sqlca) is the place to look. You can access this easily if you are using the 4GL or ESQL/C. With other tools it can be less easy :-> The sqlca.sqlerrd[2] contains the new serial value after a new row insert.