Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table corruption. VFP8 flavour
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Table corruption. VFP8 flavour
Miscellaneous
Thread ID:
00817446
Message ID:
00817446
Views:
68
Probably many of you already know or have discovered that VFP8 is more sensitive to "table corruption" than all previous FOxPro versions.

What I have discovered that one type of corruption seems harmless and is ignored in all previous versions, but in VFP8 it initiates the message "Table ... has became corrupted. The table will need to be repaired before using again." No other details or guidance are given and table cannot be used.
Actually in the situation like this when you can open table in VFP6 or VFP7, you need to append blank and delete it to "fix" the table and be able to use in VFP8.

I have checked some of the available TAble Fixing tools and discovered that they do not see that the table is corrupted.

Actually what happens is for some reason the table has a piece of garbage appended to the table end, but this piece has a length less than a full record. So the size of the dbf file (excluded the header) does not indicate additional full record comparing to what is in the header, and Table Fix Tools ignore it (again, I checked only some of them).

Here is how to reproduce the behavior:
create table tmptab (fld1 c(10))
for ia=1 to 10
insert into tmptab values (padl(ia,10,"0"))
endfor
use
?strtofile(filetostr("tmptab.dbf")+"HELLO", "tmptab.dbf")

Now the table cannot be used in VFP8, but in VFP6/7.
Next
Reply
Map
View

Click here to load this message in the networking platform