Using COPY TO with a destination

[breezett93]

Hello,

I am trying to create a program that will take an output file, convert it into a .dbf, and then send that file to a specific location to be grabbed for payroll.

I was reading about COPY TO, but I noticed none of the examples would include a destination to copy the file to.

Are either of these commands acceptable:

COPY TO a:\myDirectory\mySubDirectory or
COPY myTable TO a:\myDirectory\mySubDirectory


Thanks!

 

[Olaf Doschke]

VFP has COPY TO (copy the current workarea to a file) and COPY FILE (copy a file), in that way your second COPY is invalid.
But both copy commands take a fully qualified file name including full path with drive letter or UNC servername and network share name.

Bye, Olaf.

 

[brigmar]

SELECT myTable
COPY TO a:\myDirectory\mySubDirectory\myTable

or

SELECT myTable
COPY TO ("a:\myDirectory\mySubDirectory\"+ALIAS())

 

[breezett93]

Thanks for the info!

 

[JRB-Bldr]

Also remember that if needed, the COPY TO command can convert the DBF file to a different type.
Example:

SELECT MyTable
cDestination = <some pathed file>
COPY TO (cDestination) CSV  && to convert to CSV destination file type

Good Luck,
JRB-Bldr