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

Posted in 1999

Robert Taylor — Wed, 20 Oct 1999 14:03:41 +0100 — source: Informix-list mailing list archive (1991-1998)

Ok , should really be an RTFM but as I'm feeling happy today heres goes......... This is a bet of cod that is executed after an INSERT. Obviously the STATUS is tested 1st. LET p_payhdr.pyh_id_ref = SQLCA.SQLERRD[2] Read up on SQLCA.SQLERRD in your manual, best to do that before posting in future.