Functions Reference

Logical functions
F
ILEMAKER FUNCTIONS REFERENCE 232
ExecuteSQL
Purpose
Executes an SQL query statement for the specified table occurrence in a FileMaker Pro file.
Format
ExecuteSQL(sqlQuery; fieldSeparator; rowSeparator {;arguments...})
Parameters
sqlQuery - an SQL SELECT statement. The statement can include a Union clause that combines
the results of two queries. The statement can contain programmatically generated SQL (dynamic
parameters) that indicate where optional arguments are to be used in the query. Use the
question
mark character (?) to specify a dynamic parameter.
fieldSeparator - the character string used as a separator between fields in the result. If an
empty string is specified, the separator is a comma. The field separator is not displayed after the last
field in the result.
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 ?.