Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Lem
I think this is in the FAQ. The last inserted serial id is contained
in the sqlca structure. In 4gl you would look for sqlca.sqlerrd[2] and
in ESQL/C you would look for sqlca.sqlerrd[1]. If you have IDS version
7.2x or better you can get this directly from SQL using
DBINFO('sqlca.sqlerrd2')
HTH
Sujit Pal
______________________________ Reply Separator _________________________________
Subject: Returning Informix serial id to VB after insert
Author: Lem_Oandasan@providian.com at Internet
Date: 3/13/98 3:24 PM
Apologies if this is a FAQ.
Is there a simple method to retrieve the serial id of a newly
inserted row from an Informix table using VB?
The code will be something like:
database_object.execute "insert into table values ....."
Do I need stored procedures or triggers to make this work?
tia,
Lem Oandasan
Lem_Oandasan@providian.com
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.