General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update conflict, is THIS how to handle it????
When I open both an SQL 2000 View and a VFP DBF file and step down through numerous records, I get an UPDATE CONFLICT from SQL.
The VFP is just too fast for SQL to handle the changes.
So in my data process loop, I put a Tableupdate() then WAIT WIND "Record" timeout .1 for every record changed in SQL.
That solves the problem. Apparently that gives SQL the time to process.
Is that the right way to handle this????
Naturally this also means you can only process 10 records per second. If I cut the timeout too low, I get the update conflict.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only