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:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
JS.AddFileMakerSQLFunction
Defines a SQL Evaluate function for JavaScript.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| JavaScript | 10.0 | Yes | Yes | Yes | Yes | Yes |
Parameters
| Parameter | Description | Example |
|---|---|---|
| JSRef | The JavaScript reference number. | $js |
| Name | The name of the function. | "test" |
Result
Returns OK or error.
Description
Defines a SQL Evaluate function for JavaScript.The function will take string parameter with file name and SQL and evaluate the result in FileMaker. Result is returned as text to JavaScript. You can pass additional parameters for filling parameters in SQL.
For increased security we prefer all FileMaker developers define their own function name, so if you get some foreign JavaScript, it can't know the function name and mess with FileMaker. Be aware that users may run commands like DELETE to delete all records of a table!
Examples
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 ) ]
See also
Example Databases
Blog Entries
Created 7th December 2019, last changed 29th October 2020
JS.AddFileMakerRunScriptFunction - JS.AddFunction
Feedback: Report problem or ask question.
Links
MBS FileMaker tutorial videos
