Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!gem.mps.ohio-state.edu!usc!hacgate!ashtate!dbase!awd
From: awd@dbase.UUCP (Alastair Dallas)
Newsgroups: comp.databases
Subject: Re: dBASE memo fields
Summary: Add CHR(10)
Keywords: dBASE
Message-ID: <284@dbase.UUCP>
Date: 25 Oct 89 04:18:47 GMT
References: <278@cerc.wvu.wvnet.edu.edu>
Organization: Ashton Tate Devlopment Center Glendale, Calif.
Lines: 21

In article <278@cerc.wvu.wvnet.edu.edu>, coop@cerc.wvu.wvnet.edu (Boris Pelakh) writes:
> I have encountered an interesting problem while working with memo fields :
> 
> 	When I use REPLACE WITH ... ADDITIVE on a memo field, and specify
> a string that starts with a CHR(13), dBASE adds the string but does not
> start a new line. If, however, I go to edit the record and go into to the
> memo field using Ctrl-Home, the field adjusts itself appropriately - line
> separation and all - without having to press a single key. I just have
> to exit, and everything is fine. 
> 
> 	Now, is there any way to get dBASE to perform this adjustment 
> without having to edit the field ? 
> 

Simply start the string with CHR(13)+CHR(10)--i.e., CR/LF.  The memo field
editor recognizes lines ending in either or both; when it writes lines,
it outputs CR/LF.

Hope it helps.

/alastair/