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.4
10.5
11.0
11.1
11.2
11.3
11.4
11.5
12.0
12.1
Statistic
FMM
Blog
FM.ExecuteFileSQLValue
Execute the SQL Statement against a FileMaker database.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| FM | 12.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| FileName | The target database name. Can be empty to not limit query to one database. | "" | |
| 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 |
Result
Returns value or error.
Description
Execute the SQL Statement against a FileMaker database.Just like FM.ExecuteFileSQL, but only returns first value of first row in result. This preserves the value type without conversion to text.
This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Params parameter as often as you need.
Examples
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)
See also
Release notes
- Version 12.0
- Added FM.ExecuteFileSQLValue function.
Blog Entries
Created 30th December 2021, last changed 20th January 2022
FM.ExecuteFileSQLOnIdle - FM.ExecuteSQL
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
