No rows were affected by the update or delete operation. in CRecordset

[jax2]

So I receive this message :
No rows were affected by the update or delete operation.

very infrequently in my system when attempting to update a row. I've attempted to search for information on this error to see what might cause it, but haven't found much out there. Any ideas?

 

[MinnisotaFreezing]

Just a thought, it may be because you tried to update and no data was changed. If you call Edit() then Update(), but all the data is the same, you get an error. I don't know if its the one you describe, but its a thought.

CJB

 

[DavesTips]

By normal SQL, this means that the WHERE clause of Update or Delete found no match in the dataset. Hope that this helped! ;-)