RE: How can I get the value of newly inserted SERIAL column?

Posted in 1999

William Raper — Wed, 20 Oct 1999 11:46:24 -0400 — source: Informix-list mailing list archive (1991-1998)

1. Top of program: #include <sqlca.h> 2. Refer to your ESQL/C documentation on the SQLCA structure. -----Original Message----- From: @L0G<v [mailto:kslee@grtg.com] Sent: Wednesday, October 20, 1999 8:43 AM To: informix-list@iiug.org Subject: How can I get the value of newly inserted SERIAL column? Hi, informix users!!! I have a problem with informix SERIAL data types... I want to get the value of newly inserted SERIAL COLUMN... see belows.. Tabe Design of TEST id serial, --> primary key firstname char(30) Following coding is... EXEC SQL insert into TEST(firstname) values ('kslee'); successful insert is expected... then, I intend to insert to other table that refrences TEST(id).... What can I do? please answer me...