Script Steps Reference

Miscellaneous script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 142
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, N'Joe', N'Smith', N'Software
Engineer', '987-7000', 100000)
UPDATE Employees SET Title = N'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 & "," & "N'" &
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,N'Smith')
Note Because Microsoft SQL Server supports both Unicode and non-Unicode field types, you must
prefix all Unicode strings with an uppercase “N” (which stands for “National” in the SQL-92
standard). Otherwise, when a Unicode string containing non-English characters is passed to
Microsoft SQL Server, you may lose any data that doesn’t exist in the Microsoft SQL Server code
page.
Some Database Management Systems (DBMS), such as the MySQL 3.51 driver, don’t support the
“N” prefix. For more information, see the manual for your DBMS.
Send Event (Mac OS)
Purpose
Sends an Apple event to another application, called the target application.
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.
• do script tells FileMaker Pro to perform a script in the language of the target
application. Click Specify Application to select an application, and use Document to
select the document to use with the target application. Or, select Script text and enter
script text or type in the name of the script (make sure it is one that will be recognized
by the target program).