Hello folks,

adapting my large application to Firebird using ODBC, I encountered the
following problem:

Server version: Firebird 1.5.3.4870 (Classic server)
ODBC driver: IBPhoenix driver 2.00.00.142
OS: Windows XP Professional SP 2

After successfully updating a single row, a call to SQLRowCount
sometimes gives the value 1, sometimes the value 0. With other tables,
SQLRowCount always gives the correct result. I could not find the
circumstances for SQLRowCount to function properly.

Note: When I post the same SQL command in IB_SQL, it shows "Rows
affected: 1", so I suspect that the error lies in the ODBC driver.

Thank you in advance for any ideas.
Eberhard Rinn