Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4    Statistic  


Returns parameters's value as PDF value.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 4.3 Yes Yes Yes Yes Yes

MBS( "SQL.GetParamAsPDF"; Command; Param { ; DontRenderPreview } )


Parameter Description Example value
Command The command reference number gained with SQL.NewCommand. $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"
DontRenderPreview Optional
Pass 1 to not create a JPEG with preview of first page as part of the container.


Returns container value or error message.


Returns parameters's value as PDF value.
Field must be a BLOB parameter. The plugin does not verify if the BLOB contains a valid PDF document.
See also SQL.GetParamAsJPEG and SQL.GetParamAsPNG.


Read field value of field "PDFData" into variable:

$firstname = MBS("SQL.GetParamAsPDF"; $command; "PDFData")

Query value of first parameter:

MBS( "SQL.GetParamAsPDF"; $Command; "#0" )

See also

Created 18th August 2014, last changed 9th March 2015

SQL.GetParamAsNumber   -   SQL.GetParamAsPNG

Feedback: Report problem or ask question.

MBS Xojo Plugins