Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5   8.0   8.1    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 )


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

SQL.GetFieldAsBoolean   -   SQL.GetFieldAsDate

Feedback: Report problem or ask question.

MBS FileMaker tutorial videos