Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!samsung!mips!spool.mu.edu!uunet!elroy.jpl.nasa.gov!thyme!basil
From: basil@thyme.jpl.nasa.gov (Basil Hashem)
Newsgroups: comp.os.msdos.apps
Subject: dBase-III+ memo fields.
Message-ID: <1991May23.172337.28628@thyme.jpl.nasa.gov>
Date: 23 May 91 17:23:37 GMT
Reply-To: basil@thyme.jpl.nasa.gov (Basil Hashem)
Organization: Jet Propulsion Lab, La Canada, CA
Lines: 19


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.  

I know better not to use memo fields, but since I've inherited this database 
I'm stuck with these fields.  I'd be more than happy to replace the memo
fields with a character type field, if only I knew how.

Thanks for any help you can provide,

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