Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
19/07/2006 05:10:17
 
 
To
18/07/2006 14:26:24
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01137523
Views:
26
>>Hi David. pmfji - I have a file which does not get updated often, has only a few hundred records, but does contain a memo field which can hold a large amount of text, +/-5Mb. Just to be clear, are you saying that it might be beneficial to pad my text with chr(0) out to some maximum possible size and then to ensure that each replace always pads out to the same size? i.e. ensure that each memo field is always, for example, 6Mb in my case?
>
>Basically, the idea is to never let it shrink; let it bloat only when its size exceeds the current max size for that one memo for that record.
>
>It's pretty much like
>
>replace mymemo with padr(newvalue, max(len(mymemo), len(newvalue)), chr(0))
>
>(or chr(32) if that fits your needs better)
>

Thanks Dragan. Using your simple
replace mymemo with padr(newvalue, max(len(mymemo), len(newvalue)), chr(0))
is very straight forward and makes for a neat solution. Thanks. I prefer the wild, moutain man picture <g>
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform