Re: Serial columns and odbc

You might try: select dbinfo(....) from sometable where only_one_row_return Sorry I don't remember the dbinfo parameter off my head right now but it's in TFM. bpd@criinc.com (Perry Dillard) wrote: :I'd like to know what technique people are using for retrieving the :value dealt off from a serial field when using CLI to do the insert. :In 4GL or ESQL/C all I have to do is examine the sqlca record. So how :the heck do I do this using CLI? : :TIA, : : Perry 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