COPY FILE

Purpose

Copy any type of file

Syntax

COPY FILE <filename1> | (<expC1>) | &<memvar> [TO] <filename2> | (<expC2>) | &<memvar>

See Also

COPY, COPY STRUCTURE, COPY STRUCTURE EXTENDED, DELETE FILE, DECRYPT, ENCRYPT, ERASE, RENAME, RUN

Description

The COPY FILE command copies a file of any type <filename1> to <filename2>. The file extensions for both files must be specified. The file names can be substituted with any character expression, enclosed in round brackets or memory variable preceded by an ampersand (&), which returns a valid filename. If <filename2> already exists, it will be overwritten.

The COPY FILE command copies only the specified file, it does not copy associated files. For example, if COPY FILE is used to copy a database table (.dbf), then only the .dbf file will be copied, not the associated multiple index file (.dbx), memo file (.dbt), dictionary file (.dbd), DES3 encryption key file (.dkf). When using COPY FILE to copy an encrypted database table, the .dkf file must also be copied or the target table will not be accessible.

The <filename1> and <filename2> specifications can contain wildcard characters such as * and ?. For example, to copy the southwind shippers table (shippers.dbf) and index file (shippers.dbx): copy file "C:\Lianja\data\southwind\shippers.*" "C:\Lianja\data\southwind\bakshippers.*".

Example

close tables
copy file patrons.dbf to backup.dbf