>ok but I did not understand anything, sorry but it's true here is the image
In this update command it looks like all the columns were in the WHERE criteria. Do you have primary key in that table? Did you specify it properly? Can you also show your VFP code?
I don't have much experience with ADO recordset, I use sqlexec mostly.
If it's not broken, fix it until it is.
My Blog