> For now ,I only use one memo field to store data (Use for Append From MEMO and Copy to MEMO) .
> It work fine ,too ,and faster then b4.
> But the problem is ,the tmpMemo.fpt is 10Mb ! Even I already clean up the memo context when exit program.
> Do you have any idea about that ?
If you don't need all the records at the same time, you could work with only one record at the time - have the text filenames in a table, and have the memo in a cursor, which you create and destroy each time, something like this:
select TableWithFilenames
scan
lcFilename=trim(TableWithFileNames.FileName)
create cursor temp (cText m)
append blank
append memo cText from (lcFilename)
{ do your heavy stuff here with cText memo}
use && this will close and destroy the cursor, releasing memory
endscan
HTH