Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index corrupted
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01681084
Message ID:
01681118
Views:
41
>It doesn't matter whether you use the cursoradapter or not. You can access VFP tables directly.
>
>I need to dig into my old code to see which SYS settings it is that fixes this. It's either Sys(3051) or Sys(3052) or something else (I think it's something else).
>
>The sys function I'm thinking about requires that VFP locks all three files (dbf, fpt, and cdx) before it makes changes.
>
>I'll be back!

Ok, it is Sys 3051 and sys 3052 as well as Set Reprocess and On Error. Hopefully, you already have some kind of error handling in place.

So, read about these sys settings and reprocess.
Here's the code I always used when working with DBFs.

* Below is prevent corrupt data; get record locks on .dbf, .cdx, .fpt for updates
sys(3052,1,.t.)
sys(3052,2,.t.)

sys(3051,500) &&333 is default - avoids a network storm

set reprocess to 20
set reprocess to 20 system
Previous
Reply
Map
View

Click here to load this message in the networking platform