Want to know about the commands

[Rahulbatra]

I want to know the difference between DELETE command and DELETE FILE command in FOXPRO. If someone could give a example it would be of great help to me.

[lokeshm]

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.

[Rahulbatra]

Lokesh thanks for your detailed explanation.It gave a very clear picture about the commands.