Unable to copy file programaticly.

[sfr10000]

I need to copy a file programaticly. Seems simple,
"Copy file A to B". This works fine from the command prompt. However I cant find a way to say A and B are field
names containing the desired file names. I tried useing
"&B" for the destination file, I get a new file named "&B".

 

[SGLong]

Since you're taking the file names from a table try this:

lcFile1 = ALLTRIM(table1.field1)
lcFile2 = ALLTRIM(table2.field2)
COPY FILE (lcFile1) TO (lcFile2)

Steve

 

[sfr10000]

That works great, thanks for helping with such a basic question.

 

[tsh73]

Other way out is to create a macro holding all command then execute it with &.
But SGLong, I like your way better )

 

[dbMark]

In most cases it is best to have the habit of using name expressions (the parentheses) or the EVALUATE() function rather than macro substitution wherever possible, if only because macrosubstitution is several times slower than the other methods. In the example above, it wouldn't be an issue, but if it were in a loop or nested loops doing thousands or millions of iterations then you might notice the code running slower.