[comp.databases] Needed: pack for .DBT files

alan@oetl.UUCP (Alan Strassberg) (07/11/89)

	.DBT files (with memo fields) seem to grow without limit,
	I understand there are utilities to reduce the size of these
	file. Any suggestions in netlandia ?

	Thanks. P.S. - this is for Clipper (Summer '87).

					alan
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Alan Strassberg             UUCP: alan@oetl   ..!uunet!lstc!oetl!alan
Lockheed, Santa Cruz, Ca.   alan@oetl.scf.lockheed.com - work (408) 425-6139
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

awd@dbase.UUCP (Alastair Dallas) (07/13/89)

In article <459@oetl1.oetl.UUCP>, alan@oetl.UUCP (Alan Strassberg) writes:
> 
> 	.DBT files (with memo fields) seem to grow without limit,
> 	I understand there are utilities to reduce the size of these
> 	file. Any suggestions in netlandia ?
> 
> 	Thanks. P.S. - this is for Clipper (Summer '87).

The simplest approach is to COPY the file periodically.  The COPY operation
only copies valid memo records, thus PACKing the DBT file.  Of course, you
could switch to dBASE IV, which automatically recovers space in DBT files.:-)

/alastair/