Help

FILEMAKER PRO HELP 1165
• 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.
Example 1
Updates records in the Employees table of an external ODBC data source.
Execute SQL [SQL Text: 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]
Example 2
Calculates and performs an SQL statement to update records in the Customers table of an external
ODBC data source.
Execute SQL [Calculated SQL Text: "INSERT INTO Customers (Company,
LastName) VALUES (" & Customers::Company & "," & "N'" & Customers::Last &
"')"]
Related topics
Script steps reference (alphabetical list)
Script steps reference (category list)
Send Event (OS X)
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