Script Steps Reference
Table Of Contents
- Script steps reference (alphabetical list)
- About script steps
- Control script steps
- Navigation script steps
- Editing script steps
- Fields script steps
- Set Field
- Set Field By Name
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Device
- Insert From Index
- Insert From Last Visited
- Insert From URL
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert Audio/Video
- Insert PDF
- Insert File
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Records script steps
- New Record/Request
- Duplicate Record/Request
- Delete Record/Request
- Delete Portal Row
- Delete All Records
- Open Record/Request
- Revert Record/Request
- Commit Records/Requests
- Copy Record/Request
- Copy All Records/Requests
- Import Records
- Export Records
- Save Records As Excel
- Save Records As PDF
- Save Records As Snapshot Link
- Truncate Table
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Show Custom Dialog
- Allow Formatting Bar
- Refresh Object
- Beep
- Speak (OS X)
- Dial Phone
- Install Plug-In File
- Install Menu Set
- Set Web Viewer
- Open URL
- Send Mail
- AVPlayer Play
- AVPlayer Set Playback State
- AVPlayer Set Options
- Refresh Portal
- Send DDE Execute (Windows)
- Perform AppleScript (OS X)
- Execute SQL
- Send Event
- Comment
- Flush Cache to Disk
- Exit Application
- Get Directory
- Enable Touch Keyboard
- Glossary
Miscellaneous script steps
F
ILEMAKER PRO SCRIPT STEPS REFERENCE 270
Execute SQL
Purpose
Executes any SQL statement on an ODBC data source.
Format
Execute SQL [With dialog: On/Off; ODBC: <datasource name>; <native SQL
or calculated SQL>]
Options
• With dialog specifies whether to display the Specify SQL dialog box, the Select ODBC Data
Source dialog box, and the dialog box for entering a password when the script step is
performed.
• ODBC Data Source displays the Select ODBC Data Source dialog box. Select a data
source from the list, click OK, and enter a valid user name and password.
Note Select Save user name and password if you set With dialog to Off, or users may be
unable to access your data source.
• Calculated SQL text specifies a calculation to use as the SQL query.
• SQL text lets you manually enter a SQL query statement.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
You can use this script step to manage data in an ODBC data source through an ODBC SQL
interface. This provides more control over the FileMaker Pro interaction with ODBC data sources.
You can add multiple Execute SQL steps to a script.
Important See Get functions for information about error handling.
• Get(LastExternalErrorDetail) function returns the latest error state returned by ODBC.
• Get(LastError) function returns the last FileMaker Pro error.
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server Partial
FileMaker Go No
Custom Web Publishing Partial
FileMaker WebDirect Partial
Runtime solution No