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:
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
11.3
11.4
Statistic
FMM
Blog
Defines a SQL Evaluate function for JavaScript.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
JavaScript | 10.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example |
---|---|---|
JSRef | The JavaScript reference number. | $js |
Name | The name of the function. | "test" |
Returns OK or error.
Run SQL from JavaScript:
Set Variable [ $js ; Value: MBS( "JS.New" ) ]
Set Variable [ $r ; Value: MBS( "JS.AddFileMakerSQLFunction"; $js; "FMSQL") ]
Show Custom Dialog [ "Result" ; MBS( "JS.Evaluate"; $JS; " \"got SQL result: \" + FMSQL(\"JavaScript.fmp12\", \"SELECT COUNT(*) FROM JavaScript\")" ) ]
Set Variable [ $r ; Value: MBS( "JS.Release"; $JS ) ]
Create JavaScript environment with SQL function to query FileMaker tables:
Set Variable [ $$JS ; Value: MBS("JS.New") ]
Set Variable [ $r ; Value: MBS( "JS.AddFileMakerSQLFunction"; $$js; "FMSQL") ]
Created 7th December 2019, last changed 13th June 2021
JS.AddFileMakerRunScriptFunction - JS.AddFunction
Feedback: Report problem or ask question.