Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement