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.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
13.5
Statistic
FMM
Blog
Execute the SQL Statement against a FileMaker database.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
FM | 12.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
FileName | The target database name. Can be empty to not limit query to one database. Using a table in another database file may require you adding the other file as an external data source and adding the external table to your relationship graph to grant access. |
"" | |
SQL Statement | SQL Statement as a Text string | ||
Params... | Optional, pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement. | 123 | Optional |
Returns value or error.
Query one field:
MBS( "FM.ExecuteFileSQLValue"; ""; "SELECT \"First\" FROM \"Contacts\" WHERE ID=1")
Query container and check the data type:
MBS("FM.DataType"; MBS( "FM.ExecuteFileSQLValue"; ""; "SELECT \"PDFFile\" FROM \"Contacts\" WHERE ID=1"))
Example result: "container"
Query date:
MBS( "FM.ExecuteFileSQLValue"; ""; "SELECT DATE() FROM Contacts")
Example result: Returned "30.12.2021" in Germany on that day.
Query RowID for UUID field:
MBS( "FM.ExecuteFileSQLValue"; ""; "SELECT RowID FROM \"Contacts\" WHERE UUIdentiifer=?; $UUID)
This function checks for a license.
Created 30th December 2021, last changed 20th March 2023