Functions Reference

FILEMAKER FUNCTIONS REFERENCE 168
Related topics
Contents
Functions reference (alphabetical list)
ExecuteSQL
Purpose
Executes an SQL query statement for the specified table occurrence within a FileMaker Pro
database.
Format
ExecuteSQL(sqlQuery; fieldSeparator; rowSeparator {;arguments...})
Parameters
sqlQuery - an SQL query 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 statements containing dynamic parameters to safely
query FileMaker
Pro databases in order to avoid security vulnerabilities through injection attacks.
ExecuteSQL cannot be used with SQL statements that modify data or the database schema (such
as the Insert Into or Delete Table commands).
FileMaker Pro returns date and time data in Unicode/SQL format, not in the locale of the operating
system or the file.
If an error occurs during query parsing or execution, FileMaker Pro returns ?.
ExecuteSQL does not recognize relationships created in FileMaker Pro, which gives you flexibility to
define relationships in SQL statements.