Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
17/07/2006 02:11:45
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
16/07/2006 14:27:37
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01136859
Views:
11
Hi,
The answer is to make all writes to the memo the same size as the largest memo field, you then don't get bloat, just pad all data less than the longest string to the same length.

>Hmmmm. I see what you are saying. This does bring up one possibility, but my observations are kind of contrary to what you just stated.
>
>I can 100% say this: the size of the replacement string NEVER exceeds the size of the string in the memo in the first place. With that being said, it kind of defies your suggestion, as I am sure the string will never be replaced with something larger.
>
>By the way, I don't even have to scan, this cursor ALWAYS has one record. Over the years it has evolved that this cursor only represents the current record being "processed", and thus, is 1.
>
>I'm going to try something in the "parent" process. The first time the routine is called I am going to replace the field with the field plus 20% then back to the original. I will then see if there is any bloat...
>
>Testing...
>
>Done. Memo bloat still happening. Argh.
>
>To summarize:
>
>Before any processing of a record occurs, I replaced the contents of the memo field with the memo field plus space equal to 20% of the memo field. I then replaced it back with the original field. Processing then began and the replacement string was never bigger than the original value. Memo bloat occurred.
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform