Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!olivea!samsung!transfer!lectroid!vineland.pubs.stratus.com
From: jmann@vineland.pubs.stratus.com (Jim Mann)
Newsgroups: comp.os.msdos.apps
Subject: Re: dBase-III+ memo fields.
Message-ID: <5773@lectroid.sw.stratus.com>
Date: 23 May 91 18:13:23 GMT
References: <1991May23.172337.28628@thyme.jpl.nasa.gov>
Sender: usenet@lectroid.sw.stratus.com
Reply-To: jmann@vineland.pubs.stratus.com
Lines: 27

In article <1991May23.172337.28628@thyme.jpl.nasa.gov> basil@thyme.jpl.nasa.gov  
(Basil Hashem) writes:
> 
> 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.  

Unfortunately, you may be stuck. There seems to be no way to access dBase
memo fields other than manually. You can't even get at them in a program.
It's a major pain, and why most people try to avoid them unless they
have no way around it. (Unfortunately, there is often no way around it.)

Jim Mann                                      jmann@vineland.pubs.stratus.com 
Stratus Computer

   Not since Cromwell's troops, their puritan sensibilities offended by beauty, 
   went around smashing decorative art in churches has there been an act 
   of folly  comparable  to the abandonment and destruction of Forbes Field, 
   the Pirates' home for generations.   
                            --  George F. Will, from Men at Work: The Craft of  
Baseball