define a block of memory 2

[cruicu]

Hello all!

I must transfer a lot of dates from dbf file to txt file.
The dbf file is very large and using Memo fields for transfer take more time (because it access every time the txt file).
Somebody know a method to transfer dates from dab file to txt file (by appending) using blocks of memory?
How can I define a memory area and write in it and after this to transfer this memory area to txt file?

Thank you all!

 

[skoko]

Maybe u can try using arrays. Copy X records to array, dump to txt, copy next X records to array, dump to txt...

Or you can use SCATTER and GATHER.

 

[DSummZZZ]

How about scanning throught the file, gathering say 100 records and dumping it with STRTOFILE()?:

USE MyTable
STORE '' TO tmpstr
SCAN
   SCATTER MEMVAR 
   tmpstr = m.f1 + STR(m.f2) + DTOS(m.f3) + ALLTRIM(m.f4)....
   IF MOD(RECNO(), 100) = 0
      STRTOFILE(tmpstr, "MyFile.TXT", .T.)  &&... .T. = append to file
      tmpstr = ''
   ENDIF
ENDSCAN

Dave S.

 

[rgbean]

Actually, unless the data you're storing in the text file exceeds 16MB, Dave's solution doesn't even need to stop every hundred records - just keep appending! This string is as close to using a block of memory as you can probably get.

Rick