Re: SERIAL field and CLI - getting the index

"Koen Van der Elst" <Koen.VanderElst@ping.be> wrote: :> LET value_of_index_field = = sqlca.sqlerrd[2] :In Informix SQL you can use select DBINFO(sqlca.sqlerrd[2]) from table (use :a dummy table containing only 1 row). :This returns the serial value you just inserted. Is it supported in the CLI :standard ? If it isn't understood directly you can at least set the passthrough parameter so the sql is sent directly to the database without any translation by the CLI layer. There is a passthrough parameter whether you use CLI directly (i.e. from ESQL/C) or ODBC in some language (Visual Basic, Delphi ++). Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company