Row cannot be located for updating some
This blog explains an issue you're likely to face while executing a remote UPDATE query against a My SQL server over a linked server connection using ODBC DSN based connectionstring Recently I was working in a project where I required data to be transferred from a remote server and do some manipulations with it.
From their point of view, when users delete a row in the grid, I would wager that 99 percent of them intend to delete just the product—not both the product and the supplier.
Fortunately, you can achieve this result using another dynamic property—in this case, the Unique Table dynamic property.
This statement provides a list of orders and the customers that placed those orders.
The BDE considers any SQL join to be read-only because inserting, updating, and deleting rows in a join is ambiguous.
In an ADO join, each field object knows which underlying table it belongs to.
This setting will allow the updating of values in My SQL to the fields which has a value already.
Yes, str Licence__c is a Text(20) Custom Field It used to work OLE DB provider "MSDASQL" for linked server "SFCxp" returned message "Row cannot be located for updating.
Msg 7343, Level 16, State 4, Line 125 The OLE DB provider "MSDASQL" for linked server "SFCxp" could not UPDATE table "[SFCxp]...[Account]".
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.