BE_FileMakerSQL

BE_FileMakerSQL ( sqlStatement { ; columnSeparator ; rowSeparator ; database } )

Performs SQL commands on the tables inside FileMaker.

Version : 1.2

Parameters :
sqlStatement : the command to perform.
columnSeparator ( optional ) : the column separator for the output data - single characters only.
rowSeparator ( optional ) : the row separator for the output data - single characters only.
database ( optional, introduced in 1.3 ) : allows you to specify an open database other than the current one.

Result : Empty String or ? for direct errors. All SQL/DDL errors can be obtained via the BE_GetLastDDLError function.