#Filemaker plugin baseelements pro

So this function is, by design, limited to a single container field at a time. In FileMaker's Preferences BaseElements shows as being installed and active.

#Filemaker plugin baseelements pro

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. Installing BaseElements Plugin FileMaker Pro Advanced 17 This feels like a super easy thing that is proving to be anything but I have downloaded the latest version of the Mac plugin and installed into /Applications/FileMaker Pro 17 Advanced/Extensions. Set this to false when retrieving a single container field.Ĭode Examples: the new asText only allows you to return a single file. 4.2 ) : this is True by default as the SQL returns data from fields as text. 4.2 : return container/binary data in addition to text (new asText parameter) and outputPath parameter added. 1.3 : added optional database parameter to allow operations on databases other than the current one. 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. 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. rowSeparator : the row separator for the output data - single characters only. columnSeparator : the column separator for the output data - single characters only. Performs SQL commands on the tables inside FileMaker.

BE_FileMakerSQL BE_FileMakerSQL(sqlStatement )