Row cannot be located for updating some
No error occurs, because the update has been applied successfully.
ADO, compared to the BDE, has taken a more practical approach to the problem.
This statement provides a list of orders and the customers that placed those orders.
The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
The solution required tweaking a small setting in the ODBC DSN property as shown below Once we set the Return matched rows instead of affected rows option the UPDATE query executed successfully.
This setting will allow the updating of values in My SQL to the fields which has a value already.
The status column in the remote server table have to be updated later.
The remote server in this case was My SQL server and we were using ODBC DSNs based connectionstring.