Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's the best way to detect Data/Index Corruption?
Message
De
25/08/1999 12:42:52
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
24/08/1999 22:05:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00256419
Message ID:
00257513
Vues:
24
>>Actually, counting with no index involved would scan through the whole table and bump with an error when a damaged portion of a table is encountered.
>
>There are at least two separate cases here: damage to a record in a table and damage to an index file. The method I described was designed to uncover damage to an index file. In that case counting with no index would not see any problem at all.

Yes, and this is what you get: en error if the table is damaged, and discrepancy in count (or a different error code) if the index is damaged. Actually "killing two flies with one hit" (I guess the corresponding English phrase mentions "two birds with one stone").

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform