![]() ![]() ![]() 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. 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. Before it, came SOAP and XMLRPC, but the two buzzwords you’ll hear over and over these days are REST and JSON. rowSeparator : the row separator for the output data - single characters only. FileMaker REST (Representational state transfer) has quickly become the de facto standard for communication between services and apps. 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 |