I would do it this way in VFP9.
SELECT myhdr
COPY TO myFile.TXT SDF
SELECT mydtl
COPY TO Temp.TXT SDF
STRTOFILE(FILETOSTR("Temp.TXT"), "myFile.TXT",1)
ERASE Temp.txt
In VFP6 I would use LLFF to do the same
Working with Text Files Message #
553922.
>I have some code that looks like this:
>
>SELECT myhdr
>COPY TO MyHdr.TXT SDF
>
>SELECT mydtl
>COPY TO QuestDtl.TXT SDF
>
>
>RUN COPY /A MyHdr.TXT + MyDtl.TXT myFile.TXT
>
>...my problem is that I'm being told that the myFile.txt file appears all on one line - so I guess there are no carriage returns or maybe line feeds? Anyone have any ideas on how to fix this?
>
>Thanks!
--sb--