Re: SELECTing the last value inserted into a SERIAL column

"Kostia Botev" <kost@apk.net> 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. I think you can do select dbinfo(....) from sometable where only_one_row using a passthrough setting in ODBC to execute it. I haven't tried this, but seem to remember having read that it should work. You may simply try it out and report back how it worked out. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org