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

Posted in 1999

Mark D. Stock — Thu, 21 Oct 1999 01:32:50 +0100 — source: Informix-list mailing list archive (1991-1998)

Robert Taylor wrote: > > 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. That sounds a bit fishy to me. :-O > Obviously the STATUS is tested 1st. > LET p_payhdr.pyh_id_ref = SQLCA.SQLERRD[2] Unless the example was ESQL/C. In which case it would be SQLERRD[1]. Or you could use DBINFO('sqlca.sqlerrd1'). > Read up on SQLCA.SQLERRD in your manual, best to do that before posting in > future. Also look at the DBINFO function. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+