>>I am trying to copy all of the zone files to a text file. It only does it for the first store. I believe that the copy command is advancing the cursor to the end of the file. What is another way I can get the dbf information to a txt file without using a copy to command?
>>
>>
>>
>>------------
>>
>> USE zonelist
>> SCAN
>> tmpzone = zone
>> tmpfile = "zone" + alltrim(tmpzone) + ".dbf"
>> wait window "DBF = " + tmpfile
>> tmpfile2 = "zone" + alltrim(tmpzone) + ".txt"
>> wait window "TXT = " + tmpfile2
>> IF FILE("&tmpfile2")
>> wait window "txt file exist for " + tmpzone
>> DELETE FILE "&tmpfile2"
>> ENDIF
>> wait window "generate txt file for " + tmpzone
>> USE "&tmpfile"
>> COPY TO "&tmpfile2" type delimited
>> ENDSCAN
>
>Check out StrToFile

Actually, this won't work for type delimited. Do you want one file per record?