>>Jacky-
>>
>>
> But the problem is ,the tmpMemo.fpt is 10Mb ! Even I already clean up the memo context when exit program.>>
>>PACK [MEMO] [DBF] [Tablename ]
>>
>>Use the table and then PACK MEMO (be sure to use the MEMO clause).
>
>Hi Nancy ,
> The problem isn't solved.
> Well ,when I check the memo field in VFP ,it is a blank memo ,but when I open the memo.fpt with notepad,it contain the context that store in memo b4.
> As time when by ,the FPT file become hung .
>
> Is there any method to add field to table and delete field in table during runtime ?
>
VFP does not re-use blocks of the .FPT file once they've been allocated to hold data, even if the original record that were a part of had different data or no value stored to it. The only way to recover the disk space is to issue a PACK MEMO command.