ExecuteSQL accepts only the SQL-92 syntax ISO date and time formats with no braces.FileMaker Pro returns date, time, and number data in Unicode/SQL format, not in the locale of the operating system or the file.If you do not use the DATE statement, ExecuteSQL treats dates as literal strings. To apply the correct formatting to dates in an SQL query, use the DATE statement.If an error occurs during query parsing or execution, FileMaker Pro returns ?. When you use multiple dynamic parameters in sqlQuery, the first question mark character is replaced by the first arguments parameter, the second by the second, and so on. Data type returnedĮxecuteSQL 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.ĮxecuteSQL 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.ĮxecuteSQL cannot be used with SQL statements that modify data or the database schema (such as the Insert Into or Delete Table commands). The row separator is not displayed after the last row in the result.Īrguments - one or more expressions separated by semicolons ( ) that are evaluated and used as values for the dynamic parameters in the query statement. If an empty string is specified, the separator is a carriage return. RowSeparator - the character string used as a separator between records in the result. The field separator is not displayed after the last field in the result.

If an empty string is specified, the separator is a comma. Use the question mark character (?) to specify a dynamic parameter.įieldSeparator - the character string used as a separator between fields in the result. The statement can contain programmatically generated SQL (dynamic parameters) that indicate where optional arguments are to be used in the query.

The statement can include a Union clause that combines the results of two queries. Format ExecuteSQL ( sqlQuery fieldSeparator rowSeparator ) Parameters Executes an SQL query statement for the specified table occurrence in a FileMaker Pro file.

Filemaker pro 16 sql query