Get key of row just inserted?
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL
One of our developers used DBINFO('sqlca=2Esqlerrd1') in a stored=20 procedure to get the last serial number=2E Everything was fine until=20= he=20 switched from ODBC to Informix Native drivers=2E Now the value that i= s=20 returned by DBINFO is always zero=2E=20 =20 Any advice on how to get the correct value of the last inserted key=20 would be greatly appreciated=2E =20 Thanks, Gerry Schuil gschuil@ccm=2Elivestock=2Eorg=2Enz THE FOLLOWING WARNINGS ATTACH TO THIS COMMUNICATION This material is intended for the named recipient only and has=20 been created for the purposes and functions of Livestock Improvement=20 Corporation Limited and may contain information that is subject to=20 the Privacy Act / Confidentiality / Privilege / Copyright=2E Any person other than the named recipient is prohibited from=20 retaining / disclosing / copying / distributing / using all=20 or part of this material=2E