Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Quickest Way to Check for Invalid Reccount in Table Head
Message
De
09/02/2002 00:19:43
 
 
À
08/02/2002 09:05:54
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00616383
Message ID:
00617842
Vues:
33
Hi Calvin

Like Doug said elsewhere today, you need to use repair, not reindex.

I have tested the failure scenario extensively, and found that once the header is off, no further records are added. Checked this with hexedit. Nor does the last record change ( the record which reflects a correct header count ). It is recovered when the header is corrected.

However, though I did the testing by setting the header off by one, and restoring it, I have seen instances where the problem arises from a short record at the end. In at least one case, the header count seemed to be 'correct' but the checking calculation doesn't handle it. SDT repair fixed the file, but probably dropped that last record.

Geoff

>While testing this I found a problem with SDT - if you run reindex with the pack flag set to .t. and there is a problem with the reccount in the file header any excess records will be permanently lost.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform