serial field on IDS and MS Access

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? Thanks in advance Drazen

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. Art S. Kagel