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
Queries field value for given position in result.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
FM FMSQL | 5.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
SQLref | The reference number returned by FM.SQL.Execute function. | $SQLRef | |
Row | The row number from 0 to FM.SQL.RowCount-1. | $row | |
Column | The column number from 0 to FM.SQL.FieldCount-1. | $col | |
Flags | Available in MBS FileMaker Plugin 12.1 or newer. Various flags. Pass 0 to return value as it is. (default) Pass 1 to return file name of a container field. Pass 2 to return container data base64 encoded. |
0 | Optional |
Returns value or error.
Query field values:
Set Variable [$sql; Value:MBS( "FM.SQL.Execute"; ""; "select * from Clients")]
# query first field of first row:
Set Variable [$value; MBS( "FM.SQL.Field"; $sql; 0; 0 )
# query other field
Set Variable [$value; MBS( "FM.SQL.Field"; $sql; $row; $col )
Set Variable [$r; MBS( "FM.SQL.Release"; $sql )
This function checks for a license.
Created 18th April 2015, last changed 21st April 2023