Re: Accessing Informix through ODBC

} } I am inserting rows into an Informix table which has a serial } } column from a client program which is accessing the Informix DB } } thru a ODBC driver (Q+E). After the insert operation, how do I } } get the serial number that was generated without giving an SQL } } to get the max of the serial column. } How do I get access to the entire SQLCA if connecting to the DB } } thru a ODBC Driver? } Any suggestions? Thanks } THIS ONLY WORKS FOR INTERSOLV DRIVER. To get the Serial Value after an insert call SQLGetStmtOption/1049. To get the rowid after an insert call SQLGetStmtOption/1048. Ray Kaminski Senior Software Engineer Bi-Tech Software This message brought to you by the letter K and the number 9. .