Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

JavaScript.RegisterSQLQueryFunction

Registers a SQLQuery function.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
JavaScript 5.4 Yes No Yes, macOS only No Yes

MBS( "JavaScript.RegisterSQLQueryFunction"; JavaScriptContext; FunctionName )

Parameters

Parameter Description Example value
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


JavaScript.RegisterRunScriptFunction   -   JavaScript.Release

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins