+---------------------------------+
|           DELETE FILE           |
+---------------------------------+
DELETE FILE [<file> | ?]

-----------------------------------
Removes a file from disk.
-----------------------------------

This form of the DELETE command erases a file.

WARNING -- Exercise caution when using this command -- any file deleted
with this command cannot be retrieved.  Even if SAFETY is SET ON you
will not be warned before the file is deleted.

If you are deleting a database file, the database cannot be in USE at
the time the DELETE FILE command is issued.  If you delete a database
that has an associated .FPT memo file, be sure to delete the memo file.

The file name must include a fully-qualified pathname if it's on a
different drive or in a different directory than the default, and the
file extension must also be specified.

Clauses
-------

<file> | ?
        Specifies <file> to be removed from disk or displays Open File dialog.

+---------------------------------+
|         Program Example         |
+---------------------------------+
In this example, database structure of ITEMS is copied to database named
TEMP.  Structure information is modified and new database BACKUP is
created from modified structure information.  All records from ITEMS are
then appended to BACKUP database.  Field ALLCOST is replaced with
product of QUANTITY and PRICE fields and temporary database TEMP is then
deleted.

CLOSE ALL
USE items
COPY STRUCTURE EXTENDED TO temp
USE temp
APPEND BLANK
REPLACE field_name WITH 'allcost'
REPLACE field_type WITH 'N'
REPLACE field_len WITH 10
REPLACE field_dec WITH 2
CREATE backup FROM temp
USE backup
APPEND FROM items
REPLACE ALL allcost WITH quantity * price
DELETE FILE temp.dbf

-----------------------------------

See Also:  ERASE, FILER, SET SAFETY

-----------------------------------