Sjoerd Mullender wrote:
In ODBC functions can generally return SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, or SQL_ERROR. In the latter two cases one or more messages can be retrieved with SQLGetDiagRec. I don't know off-hand what *should* happen in the case you describe, but what certainly *could* happen (but this is not based on intimate knowledge of the description of SQLExecute) is that the SQLExecute call returns SQL_SUCCESS_WITH_INFO.
Hmm, PostgreSQL does like I suggested, the update is not committed, because the select throws an exception. My guess is that SQL_SUCCESS_WITH_INFO is the equivalent of warnings produced during the setup/execution (like changed cursors, etc). Does ODBC know about warnings for Statements, ResultSets and Connections? Need sync with Niels on the standard I think.