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
