Re: serial field on IDS and MS Access

Posted in 1999

Mark D. Stock — Mon, 15 Mar 1999 12:03:36 +0200 — source: Informix-list mailing list archive (1991-1998)

Drazen Kozic wrote: > > Server > OS: SCO OpenServer 5.0.4 > DBMS:IDS 7.1 > > Client > MS Windows 95 > MS Access 97 > Informix Cli 2.x > > How can I find out the value of serial field of just inserted row. Is there > something like SQLCA record in I4GL? Try something like: SELECT DBINFO('sqlca.sqlerrd1') FROM systables WHERE tabid = 1 Or any valid SELECT to return the result of DBINFO. 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 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+