Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field
Message
From
08/05/2017 14:56:11
 
 
To
08/05/2017 14:39:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01650943
Message ID:
01650945
Views:
76
>Memo fields, are they reliable or not?
>
>I saw several threads discussing memo fields over time. The thing is that I don't remember if the main problem related to those was because of VFP before version 9.
>
>So should I or shouldn't I use them? And under which circumstances should I or shouldn't I use them?

I haven't had any problems with memo fields for as log as I can remember. The only warning I have is that you shouldn't use it if the data changes frequently. Every time you add data to a memo field so that the size grows over the "next block size barrier" (in lack of a better description), VFP allocates a completely new area for the memo data while keeping the old intact, resulting in what's called memo field bloat. You can read about it here:
http://fox.wikis.com/wc.dll?Wiki~MemoBloat
http://www.tomorrowssolutionsllc.com/Articles/Memo%20field%20bloat.PDF
Previous
Reply
Map
View

Click here to load this message in the networking platform