>> 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
Wow ,thanx a lot Dragan.
Not only the problem solved ,also the speed of importing text is improve a lot !
From 6 sec to import a 500kb text file to 2 sec.
Wonderful !
Thanx a lot ^__^"
I'm a beginner of Visual Foxpro 5.0 ,thanx for help ^^