Re: dBase-III+ memo fields.

Article View: comp.os.msdos.apps

Article #2746

Back to comp.os.msdos.apps Previous Next

#2746

From: Basil Hashem
Date: Thu, 23 May 1991 22:53

21 lines
1362 bytes

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

Technical Details

Message-ID: <1991May23.225344.18772@thyme.jpl.nasa.gov>

Path:

arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!thyme!basil

References: <1991May23.172337.28628@thyme.jpl.nasa.gov>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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

Reply to Parent Message