Hi Alan,
> If the changed data in bytes > blocksize then it will add a new block. If you
> keep the changes < blocksize then it will re-use the same space. The trouble
> is with a blocksize of 64, it's very likely that it will almost always be
> adding blocks.
That would be very thoughtful of VFP, indeed, but it's unfortunately not what
is happening:
Set Blocksize To 64
Create Table memotest (memofield M)
Use memotest shared
Insert into memotest values ("1234567890")
Use
Dir like memotest.fpt
?
Use memotest shared
Replace memofield with "54321"
Use
Dir like memotest.fpt
?
Use memotest shared
Replace memofield with "1234567890"
Use
Dir like memotest.fpt
The code replaces the same field with a shorter string, then with a longer
string. All strings are way below the blocksize. Yet, each time the FPT file
grows by 64 bytes.
--
Christof
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/[email protected]
** 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.
