>>>>>

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)

>>
>>I posted my message before I see yours :-) and yes, I like your transform() more.
>>But you have a typo - missed FIELDS clause in COPY TO :-)
>
>Nobody is perfect... :-)


lol
Especialy me :-)