Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Mystery
Message
From
06/08/2002 13:14:58
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Miscellaneous
Thread ID:
00685226
Message ID:
00686632
Views:
42
Sergey,
I didn't set up the connection, but I'm thinking it's ODBC. This is the ASP connection code:
Set conn = Server.CreateObject("ADODB.connection")
conn.Open session("session_dsn")
where, I believe, session_dsn is the ODBC dsn connection name.

>Bill,
>
>Are you using OLE DB provider for ODBC or VFP OLE DB provider?
>
>>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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform