Re: Sequences and Serials

From: troegers13@my-deja.com > >I am working with Informix for the first time. I understand the >basics of the Serial datatype. The problem that I am encountering is >that I need to get the value of the Serial field after the record has >been inserted, to use as a foreign key for records in other tables. I >have experience programming with Oracle and have used sequences in the >past which work very well for solving this problem. So my question is: >Is there a way to get the value of the key (Serial field) for the >record that was inserted? In the SQLCA record, SQLCA.SQLERRD[1] or [2], depending on which language you're using. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com