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.