If you're using older versions of the plugin prior to 4.0.4 In previous versions of the plugin, an instance of the plugin had a single store of temporary storage that it's using during and in between operations ( things like storing the SMTP settings, before. If you need multiple fields, use a loop script, or while function. The BaseElements plugin is currently thread safe as of version 4.0.4 for all functions. 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. 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. The docs indicate that we need to perform a PROFIND request: to do the we need to set a cURL option before calling our GET request. 1.3 : added optional database parameter to allow operations on databases other than the current one. The BaseElements plugin function to do this isECurlSetOption ( 'CURLOPTCUSTOMREQUEST' 'PROPFIND' ) The option to set is called CURLOPTCUSTOMREQUEST and we have to set it to the value PROPFIND. 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. Ok, new build of the plugin, which resolves an issue with BEExecuteSystemCommand where it could, on windows, sometimes return a result before the plugin had time to setup its wait for the result ( only happened on some machines, one of our test ones was slow and so never saw it. MauriceG (Customer), since you already use the BaseElements plugin, try its BEConvertContainer() function. rowSeparator : the row separator for the output data - single characters only. Dialog options in the Insert File script step allows you to choose between the 'file:' and 'image:' prefix, as well as select the Storage and Compression options.
You can then adjust this path to suit whatever location you need, or to get an example of the difference between selecting a. This will return an example of the sort of path used by the function.
columnSeparator : the column separator for the output data - single characters only. To get an example of the sorts of paths that the plugin uses, use the BESelectFile function in the Data Viewer, and choose a file with a known path. Performs SQL commands on the tables inside FileMaker. BE_FileMakerSQL BE_FileMakerSQL(sqlStatement )
0 kommentar(er)
