Row cannot be located for updating some

在数据库编程中经常会出现这种问题。出现这种问题的原因是:ADO组件在update的时候是用主键与所有修改的字段的原值作为where条件的(可以通过事件跟踪看到)。解决办法:在程序中提供所有字段的值,而不是利用SQLServer的缺省值。或者ADODataset|Properties['Update Criteria'].

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.

Leave a Reply