Script Steps Reference

136 FileMaker Script Steps Reference
Description
Executes any SQL statement. 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 FileMaker Pro Help 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.
Examples
The following example of a manual SQL statement entry executes once each time you run
the Execute SQL script step.
INSERT INTO Employees (EmployeeID, FirstName, LastName, Title,
WorkPhone, Salary) VALUES (100, 'Joe', 'Smith', 'Software
Engineer', '987-7000', 100000)
UPDATE Employees SET Title = 'Manager' WHERE EmployeeID = 103
DELETE FROM Employees WHERE EmployeeID = 103
The following example of a field-based SQL statement shows a calculation field that
concatenates text with a field that can be used to insert or update a number of records in
the found set.
"INSERT INTO Employees (EmpID, LastName) Values (" & EmpID & ","
& "'" & Last Name & )"
With EmpID of 103 and Lastname of "Smith" the calculation of the field above is translated
to:
INSERT INTO Employees (EmpID, LastName) Values (103,'Smith')
Send Event (Mac OS)
Format
Send Event ["<Target Application>"; "<Event Class>"; "<Event ID>",
"<Document or Calculation or Script Text>"]
Options
Click Specify to display the “Send Event” Options dialog box, where you can set the
following options.
• Send the <value> event with lets you choose between the following:
• open application tells FileMaker Pro to open an application. Click Specify
Application to select the application.
• open document tells FileMaker Pro to open a document in the target application.
You can also specify a calculated value or script.