Re: RV: Newera 3.0 CCL/ODBC vs CCL/Informix

On 26 Aug 1997 23:03:10 -0400, legmor@interserver.com.ar (Gabriel Leglise) wrote: >Richard wrote: > >A nice feature of the CCL/Informix connection classes is the ability to >access the ixSQLCA class object to get update information such as the >serial number of the record just inserted to the database by refering to >SQLERRD[2]. > [SNIP] With CCL/ODBC you can use the getSQLCA() method which is part of the ixSQLConnect class (If you are using version 2.? or higher). For example to get the serial number of the inserted row do the following: VARIABLE serialNum INTEGER .... LET serialNum = sqlStmt.getConnection().getSQLCA().SQLERRD[2] The return value from getSQLCA() exactly mimics the old SQLCA record. -- Dalton