Script Steps Reference
Table Of Contents
- Contents
- About script steps
- Script steps reference (alphabetical list)
- 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 Index
- Insert From Last Visited
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert QuickTime
- Insert Object (Windows)
- Insert File
- Update Link (Windows)
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Records script steps
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
Miscellaneous script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 141
Execute SQL
Purpose
Executes any SQL statement.
Format
Execute SQL [No Dialog; ODBC: <datasource name>; <native SQL
or calculated SQL>]
Options
• Perform without dialog prevents the Specify SQL dialog box, the Select ODBC Data
Source dialog box, and the Password dialog box from displaying when the script step
executes.
• Click Specify to display the Specify SQL dialog box, where you can set the following
options.
• Specify 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 selected Perform without dialog, or
users may be unable to access your data source.
• Calculated SQL text lets you create a calculation to use as the SQL query.
• SQL text lets you manually enter a SQL query statement.
Compatibility
This script step is:
• not supported in web publishing
• not supported in a FileMaker Server scheduled script
• not supported in runtime solutions
Description
You can use this script step to manage data in a foreign 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(LastODBCError) function returns the latest error state returned by ODBC.
• Get(LastError) function returns the last FileMaker Pro error.
Notes
• If you use the Execute SQL script step to send ODBC data that contains Unicode
strings, your ODBC driver must support Unicode. Otherwise, the results may be
inconsistent.
• ODBC import, the Execute SQL script step, and external SQL data sources are not
supported in runtime solutions created with FileMaker Pro Advanced.