SQL.GetParamAsPNG
-----------------

Returns parameters's value as PNG value.

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

MBS( "SQL.GetParamAsPNG"; Command; Param ) 

**MBS**( **"SQL.GetParamAsPNG";** /\* Returns parameters's value as PNG value. \*/  
**$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" \*/ 

### 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" |

### Result

Returns container value or error message.

### Description

Returns parameters's value as PNG value.  
Field must be a BLOB parameter. The plugin does not verify if the BLOB contains a valid PNG image.  
See also [SQL.GetParamAsJPEG](SQLGetParamAsJPEG.md) and [SQL.GetParamAsPDF](SQLGetParamAsPDF.md).  
### Examples

Read field value of field "PNGData" into variable:

 $firstname = MBS ("SQL.GetParamAsPNG"; $command ; "PNGData")  
Query value of first parameter:

 MBS ( "SQL.GetParamAsPNG"; $Command ; "#0" )  
### See also

- [SQL.GetParamAsJPEG](SQLGetParamAsJPEG.md)
- [SQL.GetParamAsPDF](SQLGetParamAsPDF.md)
- [SQL.GetParamAsText](SQLGetParamAsText.md)
- [SQL.GetParamAsTime](SQLGetParamAsTime.md)
- [SQL.GetParamIsNull](SQLGetParamIsNull.md)
- [SQL.GetParamsAsJSON](SQLGetParamsAsJSON.md)
- [SQL.GetParamValue](SQLGetParamValue.md)
- [SQL.NewCommand](SQLNewCommand.md)
- [SQL.SetParamAsDate](SQLSetParamAsDate.md)
- [SQL.SetParamAsText](SQLSetParamAsText.md)

### Blog Entries

- [MBS Filemaker Plugin, version 3.0pr3](https://www.mbsplugins.de/archive/2012-10-19/MBS_Filemaker_Plugin_version_3/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 18th August 2014 , last changed 13th January 2015

  
[SQL.GetParamAsPDF](SQLGetParamAsPDF.md) - [SQL.GetParamAsText](SQLGetParamAsText.md)

[HTML Version](SQLGetParamAsPNG.shtml)