Last inserted serial in ODBC

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL

Jerzy Kasenberg — Thu, 02 Dec 1999 15:06:26 GMT — source: Informix-list mailing list archive (1991-1998)

Hi I would like to get last inserted serial using ODBC (in ESQL/C sqlca.sqlerrd[1]) what is the simplest method ? thanks for any help Jerzy ------------------------------ change you know what to com.pl

↪ replying to Jerzy Kasenberg

Art S. Kagel — Thu, 02 Dec 1999 13:12:57 -0500 — source: Informix-list mailing list archive (1991-1998)

Jerzy Kasenberg wrote: > > Hi > > I would like to get last inserted serial using ODBC > (in ESQL/C sqlca.sqlerrd[1]) > > what is the simplest method ? Use the DBINFO function immediately after the INSERT, so: INSERT INTO atable (serial_col, ...) VALUES (0,...); SELECT DBINFO( 'sqlca.sqlerrd1' ) FROM systables WHERE tabid = 1; Obviously encode the statement into ODBC function calls and bind a long integer to receive the result of the SELECT DBINFO... call. Art S. Kagel

↪ replying to Art S. Kagel

Jerzy Kasenberg — Fri, 03 Dec 1999 11:54:35 GMT — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > > I would like to get last inserted serial using ODBC > > (in ESQL/C sqlca.sqlerrd[1]) > > SELECT DBINFO( 'sqlca.sqlerrd1' ) FROM systables WHERE tabid = 1; > above statement results 674: Procedure (dbinfo) not found. We have old informix I suppose any other clue Jerzy

Glossary

ESQL/C