Copy field1,field2 to newfile sdf>>
Copy so.compcde,so.ornum,so.custcde to sample1 sdf>>
>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)