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

On Wed, 27 Aug 1997 14:39:32 GMT, dalton@go5.com (Dalton Cranston) wrote: >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 > It has been pointed out to me (very nicely (NOT) by my workmates) that I did not answer the original question - sorry - I will be more careful next time. I don't think that this can be done easily in ODBC however someone has mentioned that perhaps there is a way using the OpenLink drivers. Sorry again. Dalton