Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index corrupted
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01681084
Message ID:
01681118
Vues:
42
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform