Monkeybread Software - MBS FileMaker Plugin: SQL.GetFieldValue

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.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

SQL.GetFieldValue

Returns field's value.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
SQL	5.1	Yes	Yes	Yes	Yes	Yes

MBS( "SQL.GetFieldValue"; Command; Field ) More

Parameters

Parameter Description Example

Command The command reference number gained with SQL.NewCommand. $Command

Field The name or one based index of the field. $Field

Parameter	Description	Example
Command	The command reference number gained with SQL.NewCommand.	$Command
Field	The name or one based index of the field.	$Field

Result

Returns value or error.

Description

Returns field's value.
The value is converted to a FileMaker value with matching type.
BLOBs are returned as hex strings and not as container values (could be changed).
NULL values are returned as empty container values.

Blog Entries

MBS FileMaker Plugin, version 5.1pr6

Release notes

Version 8.5
- Fixed bug in SQL.GetFieldValueList with empty texts being ignored in first field.

Created 18th April 2015, last changed 20th April 2015

SQL.GetFieldOptions - SQL.GetFieldValueList