It's know bug in MySQL ODBC driver 2.5/3.5
MartinJ
>Tableupdate() marks a record for deletion (in the local cursor) when you replace a field with the same value it had before.
>
>Below is code to reproduce the bug. You will need mysql installed and you will need to change the connection info (username, password, server, port, etc). Do this in the connect_to_db function. Cut and paste this code into a prg and name it test.prg
>
>Can anyone help me determine if this is something I am doing or is this a bug in vfp?
>I am able to reproduce this in vfp 6 and vfp 8 sp1.
>