Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why my memo field become 21M long?
Message
From
03/02/1997 12:24:46
 
 
To
03/02/1997 09:04:19
F Joseph
Xinjiang Electric Power Company
Urumqi, China
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00019120
Message ID:
00019143
Views:
33
>I write a app that recieve serial port data into a table
>by MSCOMM32.OCX.
> I use a memo field to save data what recieved , and per record is 100K long about,but when i have recieved 5 records , i find it's become 21M long!!! (the FPT file of this table) I don't know what is happend. or memo field has some fix block for saving data, they are fix long,and whatever they are used ?
> how can i try ?
> (If someone is interest it , i can post my code to him via E-Mail..)
> thanks everyone.


Memo fields use a specific block size. When the block is filled, the ENTIRE memo for that field is copied to the end of the FPT file and another block is reserved. The original space is NOT reclaimed. Use PACK MEMO to reclaim the space.

Craig
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform