>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