>This code stops at the copy line as the syntax must not be right. Can anyone see what I'm doing wrong, I've tried every variation I could think of with no luck.
>
>***COMBINE.PRG
>SET EXACT OFF
>CLEAR
>CLOSE DATA
>SELECT A
>USE VV ORDER DAM1
>SELECT B
>USE AHORSE ORDER NAME
>SELECT A
>LOCATE
>SCAN
>STORE DAM1 TO MDAM1
>SELECT B
>SEEK MDAM1
>DO WHILE NAME = MDAM1
>STORE NAME TO cname
>***code bombs on copy
>COPY FILE &cname TO C:\JUNK\pedigrees\&cname
>SKIP
>ENDDO
>SELECT A
>ENDSCAN
>CLOSE DATA
>RETURN
>
>
>
Hi James,

Everyone else has given you some good advice, however, there may be a point or two that they've missed. First of all, the file referenced in the cname variable has to exist on the FoxPro path in order for the copy to work. Second, when the code above executes, if the value in mdam1 exists multiple times, you end up copying the same file multiple times.