Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the best way to detect Data/Index Corruption?
Message
From
25/08/1999 12:42:52
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
24/08/1999 22:05:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00256419
Message ID:
00257513
Views:
23
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform