Information générale
Catégorie:
Applications Internet
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!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement