Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!think.com!zaphod.mps.ohio-state.edu!swrinde!cs.utexas.edu!asuvax!ukma!hsdndev!rice!uupsi!sunic!fuug!funic!msdos1
From: msdos1@funet.fi (Petri Hartoma - Tut)
Newsgroups: comp.os.msdos.apps
Subject: Re: dBase-III+ memo fields.
Message-ID: <MSDOS1.91May27160009@nic.funet.fi>
Date: 27 May 91 14:00:09 GMT
References: <1991May23.172337.28628@thyme.jpl.nasa.gov>
	<1991May23.225344.18772@thyme.jpl.nasa.gov>
Sender: msdos1@nic.funet.fi (Petri Hartoma - Tut)
Organization: Finnish Academic and Research Network NIC
Lines: 18
In-Reply-To: basil@thyme.jpl.nasa.gov's message of 23 May 91 22:53:44 GMT

In article <1991May23.225344.18772@thyme.jpl.nasa.gov> basil@thyme.jpl.nasa.gov (Basil Hashem) writes:
> Not only that, it appears that when using memo fields, the associated file
> (.DBT) tends to grow uncontrollably.  My file has now reach 600,000 bytes!
> yikes!  Anyone know how to compact that space?  Or better yet get the fields
> into a character format.

There are some PD/SW programs to do that, but the easiest way of
reducing the memo file is to copy the database to another name:

copy database to temp
eras database.dbf
eras database.dbt
ren temp.dbf database.dbf
ren temp.dbt database.dbt

This works at least with Clipper's DBU utility. ;-)

&& Petri