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. With the fmplugin privilege in the target file unchecked, executing the plugin call will prompt you for authorization. The first option is to grant file-level authorization.
Notes : the new asText only allows you to return a single file. FileMaker will evaluate different settings in a preset order to determine whether the plugin call is allowed.
All SQL/DDL errors can be obtained via the BE_GetLastDDLError function. Result : Empty String or ? for direct errors. OutputPath ( optional, added in 4.2 ) : Allows you to write the result of the SQL query to disk. Set this to false when retrieving a single container field.
RowSeparator ( optional ) : the row separator for the output data - single characters only.ĭatabase ( optional, introduced in 1.3 ) : allows you to specify an open database other than the current one.ĪsText ( optional, added in 4.2 ) : this is True by default as the SQL returns data from fields as text. Performs SQL commands on the tables inside FileMaker.ġ.3 : added optional database parameter to allow operations on databases other than the current one.Ĥ.2 : return container/binary data in addition to text (new asText parameter) and outputPath parameter added.ĬolumnSeparator ( optional ) : the column separator for the output data - single characters only. BE_FileMakerSQL BE_FileMakerSQL ( sqlStatement )
0 kommentar(er)
