Yes, it does.
Try this and watch for yourself:
CREATE TABLE t_memo (memo m)
APPEND BLANK
REPLACE memo WITH REPLICATE('0',1024*1024) additive
* look at the FPT, should have 1 MB (earlier: 0 MB, now: 1 MB)
REPLACE memo WITH REPLICATE('0',1024*1024) additive
* look at the FPT, should have 3 MB (earlier: 1 MB, now: 3 MB)
REPLACE memo WITH REPLICATE('0',1024*1024) additive
* look at the FPT, should have 3 MB (earlier: 3 MB, now: 6 MB)
REPLACE memo WITH REPLICATE('0',1024*1024) additive
* look at the FPT, should have 3 MB (earlier: 6 MB, now: 10 MB)
REPLACE memo WITH REPLICATE('0',1024*1024) additive
* look at the FPT, should have 3 MB (earlier: 10 MB, now: 15 MB)
You really have made 4 replaces ADDITIVE, 1 MB each one, but you have a 15
MB memo... Bloat!
2014-08-11 17:59 GMT+02:00 <[email protected]>:
> Hi Thierry,
>
> I thought the same thing at first until I read that ADDITIVE clause.
> Still applies to bloat concern??
>
> Thanks,
> --Michael
>
>
>
> On 2014-08-11 11:50, Thierry Nivelet wrote:
>
>> Hi Rafael:
>>
>> You may want to avoid memo bloat:
>>
>> replace curList.pv_mo with '';
>> + Replicate('*',100) + Chr(13);
>> + Ttoc(Datetime()) + Chr(13);
>> + Replicate('*',100) + Chr(13);
>> + '' additive
>>
>> each REPLACE increases the .fpt size
>>
>> Thierry Nivelet
>> FoxInCloud
>> Give your VFP app a second life in the cloud
>> http://foxincloud.com/
>>
>> Le 11/08/14 17:32, Rafael Copquin a écrit :
>>
>>> I'm having a Monday morning memory lapse.
>>>
>>> I have this memo field with text inside.
>>>
>>> I need to add a time stamp and additional text and I do it thus:
>>>
>>> With thisform.edit1
>>> .enabled = .t.
>>> replace curList.pv_mo with Replicate('*',100) + Chr(13) additive
>>> replace curList.pv_mo with Ttoc(Datetime()) + Chr(13) additive
>>> replace curList.pv_mo with Replicate('*',100) + Chr(13) additive
>>> replace curList.pv_mo with '' additive
>>> .setfocus
>>> EndWith
>>>
>>> However, the cursor is placed at the _top_ of the memo field and I want
>>> it to be placed at the _very bottom_, so the user can start adding text in
>>> the normal way
>>>
>>> How is this done please?
>>>
>>> Rafael Copquin
>>>
>>>
>>>
>>> --- StripMime Report -- processed MIME parts ---
>>> multipart/alternative
>>> text/plain (text body -- kept)
>>> text/html
>>> ---
>>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAGQ_JunKsWC=s5gsctghsuvggvbsqzbfwo+mftn9y085hz0...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
