Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
12.1
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
Statistic
FMM
Blog
JavaScript.RegisterSQLQueryFunction
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
MBS(
"JavaScript.RegisterSQLQueryFunction"; /* Registers a SQLQuery function. */
$JavaScriptContext; /* The reference number of the javascript context.e.g. $Context */
$FunctionName) /* The name for the new function.e.g. "SQLQuery" */
Less
Parameters
Parameter |
Description |
Example |
JavaScriptContext |
The reference number of the javascript context. |
$Context |
FunctionName |
The name for the new function. |
"SQLQuery" |
Result
Returns OK or error.
Description
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')
or
FMQuery('select * from Hello where "Count"=?', 'JavaScript.fmp12', 9, 13, 2)
Examples
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