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
[EMAIL
Yes, I am bound to use FMP. All the volunteers at the campaign
headquarters use FMP to do data entry and construct walking lists,
etc.
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
--- Jim Hurley [EMAIL PROTECTED] wrote:
Message: 11
Date: Tue, 16 Dec 2003 13:14:18 +1000
From: Sarah Reichelt [EMAIL PROTECTED]
Subject: Re: Apple script problems
To: How to use Revolution
[EMAIL PROTECTED]
Message-ID:
[EMAIL PROTECTED]
Content-Type: text/plain; charset=US-ASCII
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.
--- Jim Hurley [EMAIL PROTECTED] wrote:
Jan,
I thought that Rev only communicated with certain
select databases.
From the doc under revOpenDatabasse it says:
The databaseType is one of
MySQL,Oracle (Revolution
Enterprise only), ODBC, PostgreSQL, or
Valentina.
I
You are a champ, proving the superiority of string theory!
:-)
It returns a tab/return delimited string.
Great
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
: Mon, 15 Dec 2003 10:56:31 +1000
From: Sarah Reichelt [EMAIL PROTECTED]
Subject: Re: Apple script problems
To: How to use Revolution [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=US-ASCII; format=flowed
Hi Jim,
HyperCard is totally AppleScriptable. If you open
{{4535, Gossett, Joshua, Boreham, 12975, , , },
{109769, Hochwald , Joshua , American Hill , 15822,
sAddress sLast, , Voter}}
(These are just two records in this voter database.)
Now I can get rid of the quotes and the curly brackets (by putting
the results into a variable and using
Message: 1
Date: Mon, 15 Dec 2003 10:16:49 -0600
From: Ken Ray [EMAIL PROTECTED]
Subject: RE: Apple script problems
To: 'How to use Revolution' [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain
Message: 9
Date: Mon, 15 Dec 2003 13:59:14 -0600
From: Ken Ray [EMAIL PROTECTED]
Subject: RE: Apple script problems
To: 'How to use Revolution' [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=US-ASCII
I suspect that Run Rev would
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
I can't seem to get RunRev to respond to a simple applescript.
In Run Rev I have in field theScript
tell application filemaker Pro5
get every record
set theResult to result
end tell
tell application Hypercard)
activate
set card field data to theResult
end tell
And in my button:
On mouseUP
do
Hi Jim,
HyperCard is totally AppleScriptable. If you open the Apple Script
Editor and then Open dictionary... you can see the list of commands
that HyperCard responds to. Revolution has no such dictionary and does
not respond directly to AppleScripts. You can probably do it yourself
by
13 matches
Mail list logo