Re: Returning Informix serial id to VB after insert

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