AppleScript issue with returns in database (FMP) fields

[FlexibleLearning at aol.com]

On 8/11/05 7:53 AM, "Daniel Wenger" <DanielWenger at worldnet.att.net>  wrote:

> I have an AppleScript script in a Revolution stack. The  script, when
> tested via the (AppleScript) Script Editor, gets records  from a File
> Maker Pro (ver. 5) database without problem. Some fields in  the FMP
> database have returns separating lines of text. The Script  Editor
> brings the returns into the result with no problem.
>  
> When the script is executed in Revolution via a "do as  AppleScript"
> command the result returns the information from the FMP  fields with
> the return chars missing. All lines from within the FMP  field are
> joined together.
> 
> Any ideas as to how to fix  this?

If memory serves, FMP (like MSWord cells) uses numtochar(11) or a  vertical 
tab for CR and numtochar(9) or a horizontal tab for TAB. When you  import the 
data, use "replace numtochar(11) with CR in tData" and "replace  numtochar(9) 
with TAB in tData" to re-instate the formatting.

/H
The  Flexible Learning Company
Home of The Scripter's Scrapbook
www.FlexibleLearning.com/ssbk.htm