Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fixing corrupted table
Message
 
 
To
26/12/2004 20:06:56
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP3
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972234
Message ID:
00972239
Views:
15
I will try your suggestion. Thank you.

>Try appending a blank record to the end of the file, then delete the blank record then pack the file.
>You may have rubbish on the end of the file.
>
>>I tried to scan the table using Foxfix (3rd party tool) and it reports that "inordinate number of errors found .." then it says that most likely the problem is with the table header. The FF_SCAN() is suppose to fix the header problem but instead it completely trashes the table.
>>
>>Another possible reason could be that the table was originally created in Clipper and maybe header is not completely VFP compatible. And I don't know how to make it into 100% VFP type table.
>>
>>Do you have any suggestions, please.?
>>
>>
>>
>>>Why do you think that table is corrupted? Why do you think that header is corrupted?
>>>
>>>>I need to fix a corrupted VFP database table. I suspect that the table header is corrupted. I have a questions:
>>>>
>>>>I created a new table of the same structure using the following:
>>>>
>>>>
>>>>select DBF_EXIST
>>>>afields( aDbfStruct )
>>>>create table DBF_NEW free from array aDbfStruct
>>>>
>>>>
>>>>Then I scan the corrupted table and copy all fields to the new table. Then drop the existing table, and rename the new one.
>>>>But at the end the corruption is not fixed.
>>>>
>>>>I thought that by creating a new table, VFP would create a new header and the problem would be fixed. Yet, it does not work that way.
>>>>
>>>>What am I missing?
>>>>
>>>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform