Apple script problems

Jan Schenkel janschenkel at
Tue Dec 16 10:06:04 EST 2003

--- Jim Hurley <jhurley at> wrote:
> >
> >Message: 11
> >Date: Tue, 16 Dec 2003 13:14:18 +1000
> >From: Sarah Reichelt <sarahr at>
> >Subject: Re: Apple script problems
> >To: How to use Revolution
> <use-revolution at>
> >Message-ID:
<EFC1B732-2F75-11D8-A288-0003937A97B8 at>
> >Content-Type: text/plain; charset=US-ASCII;
> format=flowed
> >
> >>  I am still surprised that AppleScript doesn't do
> the normal thing and
> >>  just return a comma/return (or tab/return)
> delimited text file instead
> >>  of the  curly brackets. Thank God there are not
> curly brackets in the
> >>  database.
> >>
> >Jim,
> >
> >I don't have FileMaker so I can't test this, but
> what do you get if you
> >say:
> >	get every record as string
> >in the AppleScript?
> >
> >AppleScript has decided to give you a list and that
> may end up easiest
> >to process, but try coercing it to a string and see
> what happens.
> >
> >Cheers,
> >Sarah
> >sarahr at
> >
> >
> Sarah,
> You are a champ, proving the superiority of string
> theory! It returns 
> a tab/return delimited string.
> Unfortunately, for a big file, I get an "execution
> error." But I got 
> that without the "as string." I don't think this is
> a Run Rev 
> capacity problem. I am able to import the file into
> a varaibe (or a 
> field). I  suspect that AppleScript has limits on
> string lengths.
> Back to the tried-and-true--importing a text file.

Hi Jim,

Sorry to come to the discussion so late, but couldn't
you avoid a lot of problems by hooking Revolutions
straight into the FMPro database via the Query Manager
and ODBC ?
This way you can use SELECT, INSERT and UPDATE
sql-sueries to fetch and manipulate data inside your
FMPro database.
There are a few people on this list who have used such
solutions to circumvent limitations in FMPro. If you
need more information, don't hesitate to poke the

Jan Schenkel.

"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

More information about the Use-livecode mailing list