Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
SQL.GetFieldAsContainer
Queries field value as container.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| SQL | 6.2 | Yes | Yes | Yes | Yes | Yes |
MBS( "SQL.GetFieldAsContainer"; Command; Field; FileName ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with SQL.NewCommand. | $Command |
| Field | The name or one based index of the field. | $Field |
| 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 field 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 field value:
MBS( "SQL.GetFieldAsContainer"; $Command; "MyBlob"; $FileName )
See also
Blog Entries
Created 17th May 2016, last changed 17th May 2016
SQL.GetFieldAsBoolean - SQL.GetFieldAsDate
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
