[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
+---------------------------------+
| PACK |
+---------------------------------+
PACK [MEMO] [DBF]
-----------------------------------
Physically removes records marked for deletion in database and reduces
size of memo file.
-----------------------------------
The PACK command permanently removes all records marked for deletion in
the currently selected database. It may also be used to reduce the size
of a memo file associated with a database.
The PACK command removes records marked for deletion from the currently
selected database. Records may be marked for deletion with the DELETE
command, with the Delete ... option on the Record menu popup and from
within a Browse window. When issued without the MEMO and DBF keywords
the database and the memo file are both PACKed.
There is no way to retrieve DELETEd records after the PACK is finished.
The DELETEd records are gone forever.
When FoxPro PACKs a database, all records not marked for deletion are
copied to a temporary database file. When the PACK is completed the
original database is deleted from disk and the temporary database is
renamed with the original database name. A PACK may be interrupted by
pressing the Esc key. Pressing Esc stops the PACK, the temporary
database is deleted and the original database file remains unchanged.
If you run out of disk space during a PACK, FoxPro automatically
recovers the original database.
If the currently selected database has one or more indexes enabled, PACK
will also rebuild the index files.
Clauses
-------
MEMO
If a database has a memo field or fields it will also have an
associated memo file. Information in memo fields is stored in the memo
file. A memo file has the same name as the database, but has a .FPT
extension.
Include the MEMO keyword to PACK the memo file without packing the
database file. The PACK MEMO command removes unused space from the memo
file. PACK MEMO packs the memo file for the currently selected database
file. Note that issuing the PACK MEMO command just removes unused
space in the memo file - it does not remove records marked for deletion
from the database.
DBF
If you include just the DBF keyword, the database file is PACKed
without PACKing the memo file.
-----------------------------------
See Also: BROWSE, DELETE, DELETED(), RECALL, ZAP
-----------------------------------
See Also:
BROWSE
DELETE
DELETED()
RECALL
ZAP
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson