Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPD25, Corrupted tables - detection to avoid further wor
Message
From
22/07/2003 04:09:41
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810149
Message ID:
00812245
Views:
17
Hi Bhavbhuti

I used to have this problem from time to time some years ago, and it drove me nuts. In my case, the problems disappeared completely after I replaced the hard disk on my server.


>>Basicly, you'll have to scan whole table and look for unusual characters in the fields.
>
>Heavy stuff.
>
>When in your experience does the shifting of bytes corruption happen?
>
>During usage or after a dbf is closed but is not properly written by the machines/net cards?
>
>>
>>>Thanks Sergey for responding.
>>>
>>>>There's no reliable way in FoxPro to detect table or index corruption.
>>>
>>>Any unreliable way you can suggest.
>>>
>>>I was thinking maybe I can get a snapshot of some bytes in a structured manner when I close a table (assuming that the dbf is in okay condition). Then when the dbf is reused I can compare the snapshots, if they match the dbf is okay, if not there is corruption.
>>>
>>>But, but does this corruption happen after a close?
>>>
>>>Clients can manage corruption, I can't duplicate it.
>>>
>>>Especially the shifting of data type, does this happen in use or after as the net card could not write the dbf?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform