Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table corruption. VFP8 flavour
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00817446
Message ID:
00817472
Views:
29
>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.

Interesting. I bumped into this once already accidentally, I'm quite sure, but didn't understand the cause at all. Thanks for the explanation.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform