RV: Newera 3.0 CCL/ODBC vs CCL/Informix

Posted in 1997

Gabriel Leglise — 26 Aug 1997 23:03:10 -0400 — source: Informix-list mailing list archive (1991-1998)

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]. Has anybody found a method to achieve similar functionality with the CCL/ODBC classes ? -- Richard Lewis richard.lewis@gerling.com.au Richard: Try with function SQLError() ? VARIABLE connobj ixSQLConnect, stmtobj ixSQLStmt, sqlstate CHAR(*), natcode SMALLINT, natmsg CHAR(*), error INTEGER, sqlstmt CHAR(*) LET connobj = ixSQLConnect::getImplicitConnection() CALL connobj.connect("stock_binaries", "artist6", "pixel") LET error = connobj.getODBCErrorCode( ) IF error <> connobj.SQL_Success THEN CALL connobj.SQLError(NULL) RETURNING sqlstate, natcode, natmsg ELSE -........... END IF