Hi All,
We get the following error for a second (or third) update using rs.update in ASP script connected to VFP database thru ADO.

Error:
"Row cannot be located for updating. Some values may have been changed since it was last read."

Hitting the browser refresh will send it through correctly, but that's a poor work-around :^)

It's a problem with ADO's Query By Update method of creating an "Action query", which gets confused on the second rs.update to the same record. But how can the action query be controlled, or otherwise fixed?

The SQL UPDATE mytable SET ... works great since it doesn't create an action query, but we have to use the QBU method to use AppendChunks, don't we?

I hope somebody has solved this one - Thanks!