FIX: "No rows were affected by the update or delete operation"

ID: Q121217


The information in this article applies to:


SYMPTOMS

When using snapshots with the Microsoft Foundation Class Library database classes, the following error message occurs:

Warning: ODBC Success With Info, Warning: 0 rows affected by
update operation (expected 1).

No rows were affected by the update or delete operation.


CAUSE

This message may occur because of a bug in the ODBC cursor library (ODBCCURS.DLL). In the following scenarios, the cursor library incorrectly handles modifying of fields that have a pre-defined length (such as numeric fields and everything that is not a text field and not a variable length field):

The cursor library incorrectly updates the snapshot values in these cases. The bug won't occur if the snapshot is refreshed between updates by doing a requery.


RESOLUTION

Use one of the following techniques to work around the problem:


STATUS

Microsoft has confirmed this to be a bug in the ODBC cursor library included in Microsoft Visual C++ version 1.5. The ODBC cursor library included in Microsoft Visual C++ version 1.51 fixes the problem.


REFERENCES

For more information about the cursor library, see the online books in Microsoft Visual C++ version 1.5 or see Appendix G of the ODBC 2.0 Programmer's Reference (ISBN: 1-55615-658-8).

Additional query words: 1.50 2.50


Keywords          : kb16bitonly kbDatabase kbMFC kbODBC kbVC 
Version           : 1.50
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: July 20, 1999