SQL.GetFieldAsPDF
-----------------

Returns field's value as PDF value.

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

MBS( "SQL.GetFieldAsPDF"; Command; Field { ; DontRenderPreview } ) 

**MBS**( **"SQL.GetFieldAsPDF";** /\* Returns field's value as PDF value. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Field**; /\* The name or one based index of the field. \*/   
**$DontRenderPreview**) /\* Optional; Pass 1 to not create a JPEG with preview of first page as part of the container.e.g. 0 \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |  |
| Field | The name or one based index of the field. | $Field |  |
| DontRenderPreview | Pass 1 to not create a JPEG with preview of first page as part of the container. | 0 | Optional |

### Result

Returns container value or error message.

### Description

Returns field's value as PDF value.  
Field must be a BLOB field. The plugin does not verify if the BLOB contains a valid PDF document.  
See also [SQL.GetFieldAsJPEG](SQLGetFieldAsJPEG.md) and [SQL.GetFieldAsPNG](SQLGetFieldAsPNG.md).  
  
For PDF content: If you have a DynaPDF Pro license and [DynaPDF](component_DynaPDF.md) functions initialized, this function can add previews for the PDF file on Windows and Linux. For MacOS, we make them with PDFKit.  
### Examples

Read field value of field "PDFData" into variable:

 $firstname = MBS ("SQL.GetFieldAsPDF"; $command ; "PDFData")  
### See also

- [SQL.GetFieldAsDate](SQLGetFieldAsDate.md)
- [SQL.GetFieldAsFloat](SQLGetFieldAsFloat.md)
- [SQL.GetFieldAsJPEG](SQLGetFieldAsJPEG.md)
- [SQL.GetFieldAsPNG](SQLGetFieldAsPNG.md)
- [SQL.GetFieldAsText](SQLGetFieldAsText.md)
- [SQL.GetFieldAsTime](SQLGetFieldAsTime.md)
- [SQL.GetFieldsAsJSON](SQLGetFieldsAsJSON.md)
- [SQL.GetFieldValue](SQLGetFieldValue.md)
- [SQL.GetParamAsPDF](SQLGetParamAsPDF.md)
- [SQL.NewCommand](SQLNewCommand.md)

### Blog Entries

- [MBS FileMaker Plugin, version 5.1pr1](https://www.mbsplugins.de/archive/2015-03-16/MBS_FileMaker_Plugin_version_5/monkeybreadsoftware_blog_filemaker)
- [MBS Filemaker Plugin, version 4.3pr1](https://www.mbsplugins.de/archive/2014-07-02/MBS_Filemaker_Plugin_version_4/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 18th August 2014 , last changed 17th August 2018

  
[SQL.GetFieldAsNumber](SQLGetFieldAsNumber.md) - [SQL.GetFieldAsPNG](SQLGetFieldAsPNG.md)

[HTML Version](SQLGetFieldAsPDF.shtml)