| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
SQL.GetFieldValueList
Queries list of field values.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| SQL | 5.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.GetFieldValueList"; Command ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with SQL.NewCommand. | $Command |
Result
Returns list or error.
Description
Queries list of field values.If value contains a new line or return character, we replace it with \n or \r.
Examples
Create a command, fill parameters and query names and values list:
#Create select
Set Variable [$Command; Value:MBS("SQL.NewCommand"; $Connection; "SELECT * FROM Test")]
#Run it
Set Variable [$result; Value:MBS("SQL.Execute"; $Command)]
#get first row of result
Set Variable [$result; Value:MBS("SQL.FetchNext"; $Command)]
# Now query field names
Set Variable [$FieldNames; Value:MBS("SQL.GetFieldNameList"; $Command)]
# and field values of first row
Set Variable [$FieldValues; Value:MBS("SQL.GetFieldValueList"; $Command)]
See also
- SQL.Execute
- SQL.FetchNext
- SQL.GetFieldName
- SQL.GetFieldNameList
- SQL.GetFieldValue
- SQL.GetParamValueList
- SQL.NewCommand
Release notes
- Version 8.5
- Fixed bug in SQL.GetFieldValueList with empty texts being ignored in first field.
Example Databases
Blog Entries
FileMaker Magazin
This function is free to use.
Created 8th April 2015, last changed 8th April 2015
