3/24/2023 0 Comments Baseelements filemaker![]() ![]() If you need multiple fields, use a loop script, or while function. So this function is, by design, limited to a single container field at a time. 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. Set this to false when retrieving a single container field.Ĭode Examples: the new asText only allows you to return a single file. ![]() That will open a folder that you can copy the BaseElements plugin file into. You'll see a dialog much like this one : Click on the Reveal Plug-in Folder button at the bottom of that window. ![]() 4.2 ) : this is True by default as the SQL returns data from fields as text. Manual Installation in FileMaker Pro Client Open the FileMaker application preferences, and go to the plugins tab. Originally conceived to replace two separate plugins for our developer tool BaseElements, we’ve since extended and adapted it further and it now has may functions beyond it’s original plan. 4.2 : return container/binary data in addition to text (new asText parameter) and outputPath parameter added. The BaseElements plugin is a free and open source plugin, available to everyone to extend the built in functions of FileMaker Pro. 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 ) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |