DBConcurrencyException - Update problem

[Matt]

Hello,

Has anyone received this this error?:
Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

I get this error while using a grid with an adapter and command builder. First I add a new record and save the changes [adapter.Update(Changes)], with the form still open. Then I change any record in the same grid, and save again. This is when the error occurs.

Datatypes do not seem to matter. I used a simple table with only signed integers and varchars. Originally the signed ints were unsigned.

Any ideas?

MySql 5
Connector/Net 5.0
VB.Net 2005

Thanks,

Matt

Edit: The same error occurs when using the TableEditor example that comes with Connector/Net 5.0. I added a new row, clicked the update button, changed a value in the same grid, clicked update again, error.



Edited 4 time(s). Last edit at 09/07/2006 01:08PM by Matt .