| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
SQL.GetFieldValue
Returns field's value.
| Component | Version | macOS | Windows | Linux | Server | 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 |
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.
See also
- SQL.GetFieldAsDate
- SQL.GetFieldAsPDF
- SQL.GetFieldAsPNG
- SQL.GetFieldAsTime
- SQL.GetFieldIsNull
- SQL.GetFieldName
- SQL.GetFieldNameList
- SQL.GetFieldValueList
- SQL.GetParamValue
- SQL.NewCommand
Release notes
- Version 8.5
- Fixed bug in SQL.GetFieldValueList with empty texts being ignored in first field.
Blog Entries
This function is free to use.
Created 18th April 2015, last changed 20th April 2015
MarkDown version: SQLGetFieldValue.md