>>>>

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)

You're welcome!