If you need multiple fields, use a loop script, or while function.Mindfiresolutions mindfire solutions javascript mindfire asp.net java testing php html web mobile web-development css ios html5 mvc. 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 specify all the paths and filenames. The new asText set to false option ( as in asBinary ) only allows you to return a single file. Set this to false when retrieving a single container field. 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.outputPath : if included, the output is written to disk at the path specified.Use false when trying to retrieve single container fields. 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 ( sqlStatement ) Description :
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |