Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Registers a SQLQuery function.

Component Version macOS Windows Linux Server iOS SDK
JavaScriptWebKit 5.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JavaScript.RegisterSQLQueryFunction"; JavaScriptContext; FunctionName )   More


Parameter Description Example
JavaScriptContext The reference number of the javascript context. $Context
FunctionName The name for the new function. "SQLQuery"


Returns OK or error.


Registers a SQLQuery function.
The javascript function has as parameter first the SQL expression. Second optional parameter is the file name to limit query to only this FileMaker database file. Third and forth parameter are separators for column or row which can be text or number. Default is column = tab and row = return. Fifth and following parameters are passed as parameters to SQL.

Call like this:
FMQuery('select * from Hello')
FMQuery('select * from Hello where "Count"=?', 'JavaScript.fmp12', 9, 13, 2)


Register query function:

MBS( "JavaScript.RegisterSQLQueryFunction"; $$Context; "FMQuery" )

See also

Example Databases

Blog Entries

This function checks for a license.

Created 7th November 2015, last changed 9th February 2023

JavaScript.RegisterRunScriptFunction - JavaScript.Release