Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Force 4.0 Reference - pack remove deleted records and reindex http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 pack                Remove deleted records and reindex
------------------------------------------------------------------------------
 Syntax
   [!sAlias] pack

 Arguments
   sAlias is the database to operate on.

 Description
   The pack command removes deleted records from a database and reindexes
   it if necessary. Any index alias associated with the database alias
   will be reindexed. Associated memo (.dbt) files are also packed.
   pack requires enough free disk space to duplicate the database.

 Example
   #define EXAMPLE_DATABASE
   #include example.hdr

   proc Test_pack
   open sTest                             // open database
   ? reccount()                           // show original record count
   !sTest delete all for .not. sTest->sex // delete several records
   ? reccount()                           // record count is not yet changed
   !sTest pack  // physically remove records including from memo file
   ? reccount()                           // show decreased record count
   endproc

   proc main
   Test_pack()
   endproc

See Also: on pack do

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson