Re: SERIAL field and CLI - getting the index

Posted in 1996

Koen Van der Elst — 29 Jul 1996 17:31:12 GMT — source: Informix-list mailing list archive (1991-1998)

> 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 ? Koen