AppleScript issue with returns in database (FMP) fields
Daniel Wenger
DanielWenger at worldnet.att.net
Thu Aug 11 20:47:06 EDT 2005
Thank you Ken Ray and Flexible.
Found the problem. FMP uses numtochar(13) to separate lines in a
field. AppleScript Script Editor for some reason converts these to
returns, just to confuse people like me. They do not show up in the
Revolution field even as a funny character, just missing. Conversion
to returns solves the problem.
Daniel Wenger
On Aug 11, 2005, at 11:08 AM, FlexibleLearning at aol.com wrote:
> 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
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>
>
More information about the use-livecode
mailing list