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.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
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 |
---|---|---|
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 |
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 )
Created 18th April 2015, last changed 1st March 2019
FM.SQL.Execute - FM.SQL.FieldCount
Feedback: Report problem or ask question.