>>>

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)

yes sir, thank you for the solution, that's why im using this to make it simple:

StrToFile(Transform(_tally,'@L 99')+Chr(13)+Chr(10)+FileToStr(lcFile),lcFile)