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: 11.0   11.1   11.2   11.3   11.4   11.5   12.0   12.1   12.2   12.3    Statistic    FMM    Blog  

FM.SQL.Field

Queries field value for given position in result.

Component Version macOS Windows Linux Server iOS SDK License
FM FMSQL 5.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes Paid
MBS( "FM.SQL.Field"; SQLref; Row; Column { ; Flags } )   More

Parameters

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

Result

Returns value or error.

Description

Queries field value for given position in result.
Native data type is preserved so this function can returns styled text, number, time, date, timestamp and container.

Examples

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 )

See also

Release notes

  • Version 12.1
    • Added flags to FM.SQL.Field function to return containers as base64 or just their file name.

Example Databases

Blog Entries

Created 18th April 2015, last changed 12nd March 2022


FM.SQL.Execute - FM.SQL.FieldCount

Feedback: Report problem or ask question.


Start Chat