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: 8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3    Statistic  


Queries field value as container.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 6.2 Yes Yes Yes Yes Yes
MBS( "SQL.GetFieldAsContainer"; Command; Field; FileName )   More


Parameter Description Example value
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.


Returns container value or error.


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.


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.

MBS Xojo Chart Plugins