Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PACK on Memo issue
Message
From
09/02/1999 21:08:48
 
 
To
09/02/1999 20:24:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00185770
Message ID:
00185787
Views:
18
>Alvin,
>
>Memo files can get corrupted...
>
>As for the reason why? I do not have an anser to that.
>
>There are a few utilities you can use to repair damaged memo files.
>
>The one that comes first to mind is FoxFix.
>
>Good Luck
>
>:)
>
>Pascal

The reason is simple..it's called memo bloat and exists in other xBase-type files. When you add a memo, a block of dispace is reserved for that memo (SET MEMOBLOCK). When that area is filled, the entire memo is copied to the end of the FPT and another block is allocated to it. The original location is marked as no longer being used. The memo pointer in the DBF is then updated to indicate the new position of the text in the FPT. I may have the order of these steps mixed up, but this is basically what happens. With all that moving around of the data and updating of the pointer, things can...and do go wrong.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform