Re: FMP 5 via Program Linking
Re: FMP 5 via Program Linking
- Subject: Re: FMP 5 via Program Linking
- From: "Timothy K. Wilkinson" <email@hidden>
- Date: Wed, 30 Jan 2002 13:37:57 -0500
Peter,
I just recently had the same need (to remotely open a Filemaker database).
I found that Filemaker will generate the error message you described when it
is already open. I found a way to open and close the database remotely by
editing a script from the AppleScript Guidebook. Since I can't interact
with Filemaker directly once it is active I created a script within
Filemaker and used the "do script" command to close it. If you want to use
this for multiple databases make sure the close script has a different name
for each database. This script is aimed at one particular database. You
can re-write to close multiple ones if you want.
<begin script>
try
set the IP_address to "the machine's IP address"
set the remote_IP to ("eppc://" & the IP_address)
set remote_app to application "FileMaker Pro" of machine remote_IP
set remote_Finder to application "Finder" of machine remote_IP
set the_choice to the button returned of (display dialog "Do you want to
open or close the database?" buttons {"Open", "Close"}) as text
if the_choice is "Open" then
using terms from application "Finder"
tell remote_Finder
open file "Path to the database to be opened"
end tell
end using terms from
else if the_choice is "Close" then
using terms from application "FileMaker Pro"
tell remote_app
do script FileMaker script "ACHS_close"
end tell
end using terms from
end if
on error the error_message number error_number
if the error_number is not -128 then
beep
display dialog the error_message buttons {"OK"} default button 1
end if
end try
<end script>
Hope this helps.
Tim Wilkinson
ITC-ACHS
University of Virginia
email@hidden
email@hidden
>
From: "p k" <email@hidden>
>
Date: Thu, 24 Jan 2002 17:08:15 -0500
>
To: email@hidden
>
Subject: FMP 5 via Program Linking
>
>
I am trying to control FMP on a remote machine over AppleTalk. Everything
>
is set up correctly. I am able to interact with any database that is
>
currently running front-most on the remote machine. However, if no database
>
is open, I cannot open it. I get an error message generated by FMP which
>
states: "FileMaker Pro got an error: No user interaction allowed." So it
>
seems I need to be able (and should be able) to open databases remotely,
>
but...
>
>
Why do none of these scripts work (and generate the above error message):
>
>
tell application "FileMaker Pro" of machine "pilot" of zone "EtherTalk 8th
>
Floor"
>
activate
>
open "Database Name"
>
end tell
>
>
tell application "FileMaker Pro" of machine "pilot" of zone "EtherTalk 8th
>
Floor"
>
activate
>
open database "Database Name"
>
end tell
>
>
tell application "FileMaker Pro" of machine "pilot" of zone "EtherTalk 8th
>
Floor"
>
activate
>
open database "Macintosh HD:Folder Name:Database Name"
>
end tell
>
>
As always, any help would be greatly appreciated.
>
pk