SQL.GetFieldOption
------------------

Gets a string value of a specific field option.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.GetFieldOption"; Command; Field; Key ) 

**MBS**( **"SQL.GetFieldOption";** /\* Gets a string value of a specific field option. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Field**; /\* The name or one based index of the field. \*/   
**$Key**) /\* A string key of the command option.e.g. "" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |
| Field | The name or one based index of the field. | $Field |
| Key | A string key of the command option. | "" |

### Result

Returns "OK" or error message.

### Description

Gets a string value of a specific field option.  
  
Call this method to get value(s) of server specific field options. See Server specific notes.  
  
see also:  
[https://www.sqlapi.com/ApiDoc/class\_s\_a\_field.html](https://www.sqlapi.com/ApiDoc/class_s_a_field.html)  
### See also

- [SQL.GetFieldAsTime](SQLGetFieldAsTime.md)
- [SQL.GetFieldOptions](SQLGetFieldOptions.md)
- [SQL.GetParamOption](SQLGetParamOption.md)
- [SQL.NewCommand](SQLNewCommand.md)
- [SQL.SetFieldOption](SQLSetFieldOption.md)

### Release notes

- **Version 8.4**
    - Added [SQL.GetCommandOptions](http://www.mbsplugins.eu/SQLGetCommandOptions.shtml), [SQL.GetConnectionOptions](http://www.mbsplugins.eu/SQLGetConnectionOptions.shtml), [SQL.GetFieldOptions](http://www.mbsplugins.eu/SQLGetFieldOptions.shtml) and [SQL.GetParamOptions](http://www.mbsplugins.eu/SQLGetParamOptions.shtml) functions to query options list.

This function is free to use.

Created 18th August 2014 , last changed 10th January 2020

  
[SQL.GetFieldNameList](SQLGetFieldNameList.md) - [SQL.GetFieldOptions](SQLGetFieldOptions.md)

[HTML Version](SQLGetFieldOption.shtml)