Help

FILEMAKER PRO HELP 844
rowSeparator - the character string used as a separator between records in the result. If an
empty string is specified, the separator is a carriage return. The row separator is not displayed after
the last row in the result.
arguments- one or more expressions that are evaluated and used as values for the dynamic
parameters in the query statement.
Data type returned
text
Originated in
FileMaker Pro 12.0
Description
ExecuteSQL enables you to execute SQL SELECT statements containing dynamic parameters to
safely query FileMaker
Pro databases in order to avoid security vulnerabilities through injection
attacks.
ExecuteSQL does not recognize relationships created in FileMaker Pro, which gives you flexibility to
define relationships in SQL statements and retrieve data from any table, independent of the layout
context.
ExecuteSQL cannot be used with SQL statements that modify data or the database schema (such
as the Insert Into or Delete Table commands).
If an error occurs during query parsing or execution, FileMaker Pro returns ?.
Notes
• To apply the correct formatting to dates in an SQL query, use the DATE statement. If you do
not use the DATE statement, ExecuteSQL treats dates as literal strings.
• FileMaker Pro returns date, time, and number data in Unicode/SQL format, not in the locale
of the operating system or the file.
• ExecuteSQL accepts only the SQL-92 syntax ISO date and time formats with no braces.
ExecuteSQL does not accept the ODBC/JDBC format date, time, and timestamp constants
in braces.
• For more details about SELECT statement syntax, supported SQL statements, expressions,
and Catalog functions, see the F
ILEMAKER ODBC AND JDBC GUIDE and the FILEMAKER SQL
R
EFERENCE.
Examples
Suppose a database contains two tables, Employees and Salaries, which are related through the
EmpID field.