BE_FileMakerSQL

BE_FileMakerSQL(sqlStatement;{columnSeparator;rowSeparator;databaseName;asText})



Performs SQL commands on the tables inside FileMaker.

Parameters:

- sqlStatement : the command to perform.

- columnSeparator : the column separator for the output data - single characters only.

- rowSeparator : the row separator for the output data - single characters only.

- databaseName : allows you to specify an open database other than the current one.asText( optional, added in 4.2 ) : this is True by default as the SQL returns data from fields as text. Set this to false when retrieving a single container field.outputPath( optional, added in 4.2 ) : Allows you to write the result of the SQL query to disk.

- asText : outputPath

Keywords:

SQL


Version History:

- 1.2 :

- 1.3 : added optional database parameter to allow operations on databases other than the current one.

- 4.2 : return container/binary data in addition to text (new asText parameter) and outputPath parameter added.

- 4.2 ) : this is True by default as the SQL returns data from fields as text. Set this to false when retrieving a single container field.

Code Examples:

the new asText only allows you to return a single file. So although you can perform an SQL query that selects multiple container fields at once, writing them to a container field doesn't make sense, and writing to disk becomes complex when matched with a need to specific all the paths and filenames. So this function is, by design, limited to a single container field at a time. If you need multiple fields, use a loop script, or while function.


Still need help? Contact Us Contact Us