Re: SERIAL and ODBC ?

Posted in 1998

Mark D. Stock — Wed, 14 Oct 1998 12:30:35 +0200 — source: Informix-list mailing list archive (1991-1998)

Sergei Gringauze wrote: > > Hi, > > Is it possible to retrieve the newly created SERIAL number > after the insertion via ODBC driver (CLI API), in the way I can > do it via SQLCA.SQLERRD[2] in esql ? Try: SELECT DBINFO('sqlca.sqlerrd2') FROM systables WHERE tabid = 1 Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+