Re: serial field on IDS and MS Access

"Art S. Kagel" wrote: > > 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? > > Mark Stock's response is valid. In addition, to answer your specific > question, the sqlca record is available in 4GL just as it is in ESQL/C. > There are just a couple of minor differences in how one handles this > record. Mainly the sqlca.sqlerrd array, like all 4GL arrays, is one > based not zero based like "C" so the serial number is found in > sqlca.sqlerrd[2] in 4GL and in sqlca.sqlerrd[1] in ESQL/C. The other > difference is the sqlca.sqlwarn is handled differently. This is all > documented in the 4GL manuals available online. Check out TFM for > further details. Mmmmm, well I guess the question could be read both ways. I did not see 4GL on the list of products, so assumed Drazen was looking for something similar to SQLCA using ODBC. Where's my coffee? <slurp> <slurp> Argh! That's better. :-) Cheers, -- 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"!|/ ////////| +----------------------+-----------------------------------+-----------+