Re: SELECTing the last value inserted into a SERIAL column

Kostia Botev wrote: > > I have a somewhat similar question. Does anybody know a way of > accessing SQLCA using ODBC? > I am using Informix-CLI APIs. I couldn't find any ODBC functions that > give access to SQLCA. If there is no function, and you have a version 7 database engine, you can PREPARE and DECLARE a CURSOR to return the value of dbinfo() with the parameters "sqlca.sqlerrd1" or "sqlca.sqlerrd2". Yes, you CAN use CURSORs with CLI and ODBC, allegedly. :-) Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+