pack database

[astech]

Is pack database including pack tables inside ?.

How to pack tables in database programaticaly ?.

thanks.

 

[ramani]

Hi astech

If you mean PACK DATABASE as a command, I dont think it exists.

You can only pack one table at a time with the command {color blue]PACK myTable.

To pack all tables in a specific directory, which can be your data directory, follow this link..

Utility to Pack Data Files
faq182-1389

Though that is FPD FAQ, it very well applies here.




____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[cowenby]

This is how you pack tables programmatically:

USE abc EXCLUSIVE && Open the table exclusively
PACK && Removes all records marked for deletion
USE IN abc && Closes the table

NOTE: There is no way to retrieve deleted records after using PACK.

 

[astech]

thanks mr. Ramani and mr. cowenby

 

[BPeisch]

There is a PACK DATABASE command, but it only does a clean up on the DBC.



-BP

http://www.peisch.com