>>

Copy field1,field2 to newfile sdf

>>
>>what is wrong i got this message: unrecognized phrase/keywords?
>>

Copy so.compcde,so.ornum,so.custcde to sample1 sdf

>>
>>
>>TIA
>>Ryan
>
>

>COPY TO newFile sdf FIELDS field1,field2
>lnRec = _TALLY
>STRTOFILE(PADL(TRANSFORM(lnRec),2,[0])+CHR(13)+CHR(10)+FILETOSTR([newfile.txt]),[newfile.txt])
>

I would argue that my solution is a little bit simpler, although I used reccount() in stead of _tally. I do agree that _tally is a better solution, especially if there is some filtering involved.

lcFile='newfile.txt'
Copy field1,field2 to (lcFile) sdf
StrToFile(Transform(_tally,'@L 99')+Chr(13)+Chr(10)+FileToStr(lcFile),lcFile)