|
DELETE
[<scope>]
[FOR <expL1>]
[WHILE <expL2>]
[NOOPTIMIZE]
In DELETE Command, Records marked for deletion are not physically removed from the table/.DBF until PACK is issued.
Records marked for deletion can be recalled (unmarked) using RECALL Command.
To DELETE the marked records permanently you need to use PACK Command
DELETE FILE [<file> | ?]
Any file deleted with this command cannot be retrieved.
Even if SET SAFETY is ON, you are not warned before the file is deleted.
The file you want to delete cannot be open when DELETE FILE is issued.
If you delete a table/.DBF that has an associated .FPT memo file, be sure to delete the memo file.
The file name must include a path if it is on a different drive or in a different directory than the default, and the file name extension must be included. The file name cannot contain MS-DOS wildcard characters.
|