Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Emergency Data Repair Needed
Message
From
05/01/2011 13:24:34
 
 
To
05/01/2011 13:14:44
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:
01494786
Views:
76
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform