Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Emergency Data Repair Needed
Message
 
 
To
05/01/2011 13:24:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01494778
Message ID:
01494789
Views:
74
>>>We have a large table which has given the message "Table '< tablename >' has been corrupted. The table will need to be repaired before using again.
>>>
>>>There is no memo file associated with this table.
>>>
>>>My experience with repair tools is that they have not been very useful.
>>>Has that been your experience as well?
>>
>>We get this occasionally and sometimes the following works. I have no idea why but it may be worth a shot. In the command window we.......
>>CLOSE DATA ALL
>>SET TABLEVALIDATE TO 0
>>USE < tablename >
>>GO BOTT
>>BROWSE
>>
>>< append some blank records > &&anywhere from 3-5 records seems to work
>>< delete those records >
>>CLOSE DATA ALL
>>SET TABLEVALIDATE TO yourvalue
>>
>>This was a trick that was passed to me by the previous programmer. I have no clue why it works, but in most cases it does the job
>
>I've never used TableValidate for a table not belonging to a database. I know I didn't state that earlier but I was curious. Does that work for stand alone tables as well.

Yes, the above technique works for simple corruptions in free tables as well as in DB tables.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform