CopyTableFiles()
Summary
Copies all files associated with a table.
Syntax
CopyTableFiles(string view_name, string class, string primary, string secondary, string new_primary, string new_secondary)
| Argument | Contents |
|---|---|
| view_name | Name of the view that contains the table |
| class | Class of input table - FFA, FFB, CSV or dBASE |
| primary | Primary filename for input table |
| secondary | Secondary filename for input table |
| new_primary | New primary filename; must be a valid file name |
| new_secondary | New secondary filename; can be null |
Notes
-
The file types include FFA for fixed-format text (ASCII), FFB for fixed-format binary, and CSV for comma-separated text (values).
-
CopyTableFiles() copies a file containing tabular data and all associated files, including index files, dictionary files, and the like. The number and type of files that are copied depend upon the table type and whether or not permanent indexes have been created. CopyTableFiles() can copy the table associated with a view or a table that is on disk but not yet opened as a view.
-
To copy the table associated with a view, the first argument should be filled in and the second through fourth arguments should be null.
-
To copy a table that has not been opened as a view, the first argument should be null, and the second through fourth arguments should be filled in.
-
If all of the first four arguments are null, CopyTableFiles() copies the table associated with the current view.
-
If the input table is a geographic file, use CopyDatabase() instead.
-
A secondary file name can be used for index files that have a different file name from the table file.
-
The original table file and supporting index and dictionary files are not changed in any way.
Example
CopyTableFiles("Sales Data", null, null, null, "c:\\backup.dbf", null)
CopyTableFiles(null, "DBASE", "sales.dbf", "sales.mdx", "backup.dbf", "bindex.mdx")Error Codes
| Error Type | Meaning |
|---|---|
| Error | The input view is not a table (e.g., it is a joined view or a geographic file); the input table is an ODBC table; the input class is not valid; the new_primary argument is null; or a file I/O error occurred (e.g., out of disk space, overwriting a file in use) |
| NotFound | The input table does not exist or was incorrectly specified |
See Also
| Function | Summary |
|---|---|
| ListTableFiles() | Lists all the files associated with a table or view |
| DeleteTableFiles() | Deletes all files associated with a table |
| RenameTableFiles() | Renames all files associated with a table or view |
| CopyDatabase() | Copies either a standard- or compact-format geographic file |
| OpenTable() | Opens a table from a file on disk and creates a view |