| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
SQL.GetParamAsContainer
Queries parameter value as container.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| SQL | 6.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.GetParamAsContainer"; Command; Param; FileName ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| 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" |
| FileName | The filename for the container. This will determinate the type of data to FileMaker. |
"test.jpg" |
Result
Returns container value or error.
Description
Queries parameter value as container.If you can provide a file name, we can use it to auto detect the type of data and import it in the right format, e.g. add a preview for PDF or the image size for JPEG.
Examples
Query image param value:
MBS( "SQL.GetParamAsContainer"; $Command; "MyBlob"; $FileName )
See also
Blog Entries
This function is free to use.
Created 17th May 2016, last changed 17th May 2016
