Script Steps Reference

Table Of Contents

FILEMAKER SCRIPT STEPS REFERENCE 160

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.