Re: SELECTing the last value inserted into a SERIAL column

This can be obtained from the second element of the sqlerrd array in the SQL communications area. i.e. in ESQL/C long last_insert_val; last_insert_val = sqlca.sqlerrd[1]; -Bill > > I have a table(a) where I want to use a unique number as the primary > key. I had intended on using the data type SERIAL to do this, and > letting the system merely increment it for each INSERT into table(a). > However, I want to be able to capture the SERIAL value that was just > inserted into table(a) so I can insert the value into another table(b). > This would happen in the same transaction as the INSERT into table(a). > Is there a way to retrieve the SERIAL value that was just INSERTed into > table(a)? Or would I be better off using a nextkey table to hold the > next value of the key to be inserted, and basically doing the job of the > SERIAL data type manually? > Thanks. > > -Clay Amerault -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net