SQL.SetParamOption
------------------

Sets a string value of a specific parameter option.

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

MBS( "SQL.SetParamOption"; Command; Param; Key; Value ) 

**MBS**( **"SQL.SetParamOption";** /\* Sets a string value of a specific parameter option. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Param**; /\* The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter.e.g. "1" \*/   
**$Key**; /\* A string key of the command option.e.g. "" \*/   
**$Value**) /\* The new option value.e.g. "" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |
| Param | The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter. | "1" |
| Key | A string key of the command option. | "" |
| Value | The new option value. | "" |

### Result

Returns OK or error.

### Description

Sets a string value of a specific parameter option.  
### See also

- [SQL.GetParamOption](SQLGetParamOption.md)
- [SQL.GetParamOptions](SQLGetParamOptions.md)
- [SQL.NewCommand](SQLNewCommand.md)
- [SQL.SetFieldOption](SQLSetFieldOption.md)
- [SQL.SetParamAsTime](SQLSetParamAsTime.md)
- [SQL.SetParamUnknown](SQLSetParamUnknown.md)

### Release notes

- **Version 8.4**
    - Added [SQL.GetParamOption](http://www.mbsplugins.eu/SQLGetParamOption.shtml) and [SQL.SetParamOption](http://www.mbsplugins.eu/SQLSetParamOption.shtml) for options related to a command.

### Blog Entries

- [MBS FileMaker Plugin, version 8.4pr10](https://www.mbsplugins.de/archive/2018-09-21/MBS_FileMaker_Plugin_version_8/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 20th September 2018 , last changed 20th September 2018

  
[SQL.SetParamNull](SQLSetParamNull.md) - [SQL.SetParamTypesValues](SQLSetParamTypesValues.md)

[HTML Version](SQLSetParamOption.shtml)