I am trying to build an update query in run-time, I get to build this query:
"UPDATE Supplier SET SupplierName='Walter's co MM', SupplierCode=3333, Remark='try MM' WHERE SupplierPK=4"
If I write this query "UPDATE Supplier SET SupplierName='Walter's co MM' WHERE SupplierPK=4" it works perfectly.
There is a error message about "missing operator", but this is the typical error that you are looking hours and hours to the screen and you don't find anything wrong. I am working with this since 2 hours ago.
Thanks. Finally I succeded. It wasn't the thing you told me, since SupplierCode is a number. But I was doing some changes to the code, trying and trying, finally it works, and I don't know why, maybe some space in blank. Bo! I don't know.