Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Header corruption - detection, prevention??
Message
De
08/10/1999 12:58:15
 
 
À
08/10/1999 10:32:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00274212
Message ID:
00274329
Vues:
21
>I've been getting header corruption on some client sites lately. Most of them seem to be "Incorrect Record Count" mismatch type of stuff. I know that there is a window of opportunity for this to happen because fox writes to the header block first and then updates the records so if there is an interruption they can get mismatched.
>
>My biggest problem is that there isn't an error message generated the next time I try to update the table. I try to write a new record and it is there until I close the transaction and then it magically disappears. Actually it resides in the reccount()+1 record and eof() is .t.
>
>1. Is there a way to generate an error message when this happens.
>2. What might be happening to cause the corruption in the first place?
>3. Is there any relation to table size? Longer window between header and table write?
>4. I can use foxfix to check for it every time I write to the tables, but this seems REALLY kludgy. Any suggestions on a better work around?
>
>Thanks to all.

Take a look at the KB article on my web site for ideas of what is causing it and preventing them in the future.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform