Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!thyme!basil
From: basil@thyme.jpl.nasa.gov (Basil Hashem)
Newsgroups: comp.os.msdos.apps
Subject: Re: dBase-III+ memo fields.
Message-ID: <1991May23.225344.18772@thyme.jpl.nasa.gov>
Date: 23 May 91 22:53:44 GMT
References: <1991May23.172337.28628@thyme.jpl.nasa.gov>
Reply-To: basil@thyme.jpl.nasa.gov (Basil Hashem)
Organization: Jet Propulsion Lab, La Canada, CA
Lines: 21


In article <1991May23.172337.28628@thyme.jpl.nasa.gov> I wrote:
= 
= I have a database with a field of type memo and I'm trying to replace some
= values in certain records.  What I want to do is something like the following:
= 
= REPLACE ALL MY_MEMO with "New text" FOR <condition>
= 
= Unfortunately, dBase barks back with a "Data type mismatch." error, can anyone
= suggest a way around this problem.  
= 
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.

I need help.
-- 
                                 Basil Hashem
                             basil@thyme.jpl.nasa.gov
            Jet Propulsion Laboratory     La Canada Flintridge, CA