Help

FILEMAKER PRO HELP 1163
Tips on usage
• FileMaker Pro can use the Perform AppleScript script step to send Apple events to itself
or to FileMaker Pro software running on other machines.
• Use Perform AppleScript to pass image data between FileMaker Pro and other
applications. With AppleScript, you can pass images stored in container fields to other
applications or pass images into FileMaker Pro container fields.
• Use Perform AppleScript to communicate with applets and other scriptable applications.
For example, if you have created an AppleScript applet with sub-routines, you can call
the handlers using the Perform AppleScript command, like this:
Perform AppleScript ["tell application "My Applet" to
doMyRoutine()"]
Example 1
Opens the Documents folder of the current OS X User.
Perform AppleScript ["tell application "Finder" (*enter line break*)
activate (*enter line break*) set x to path to documents folder (*enter
line break*) open x (*enter line break*) end tell"]
Example 2
Sets the bounds of the Documents window to the specified size. The Documents folder must be
open before this script runs.
Perform AppleScript ["tell application "Finder" to set bounds of window
"Documents" to {170, 70, 1000, 600}"]
Example 3
Calculates and performs the AppleScript to install a network printer. "\" tells FileMaker Pro to
recognize the symbol that follows as a character and not as a calculation operator.
Perform AppleScript ["do shell script \"lpadmin -p " & Printers::Name & "
-E -v lpd://" & Printers::IP Address & " -P /Library/Printers/PPDs/
Contents/Resources/" & Substitute ( Printers::Driver Name ; " " ; "\\\ " )
& ".gz -D \\\"" & Printers::Description & "\\\"\""]
Related topics
Script steps reference (alphabetical list)
Script steps reference (category list)
Execute SQL
Purpose
Executes any SQL statement on an ODBC data source.
Format
Execute SQL [No Dialog; ODBC: <datasource name>; <native SQL
or calculated SQL>]