Monkeybread Software - MBS FileMaker Plugin: FM.SQL.FieldType

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

FM.SQL.FieldType

Queries field type for given position in result.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
FM FMSQL	5.1	Yes	Yes	Yes	Yes	Yes

MBS( "FM.SQL.FieldType"; SQLref; Row; Column ) More

Parameters

Parameter Description Example

SQLref The reference number returned by FM.SQL.Execute function. $SQLRef

Row The row number from 0 to FM.SQL.RowCount-1. $row

Column The column number from 0 to FM.SQL.FieldCount-1. $col

Parameter	Description	Example
SQLref	The reference number returned by FM.SQL.Execute function.	$SQLRef
Row	The row number from 0 to FM.SQL.RowCount-1.	$row
Column	The column number from 0 to FM.SQL.FieldCount-1.	$col

Result

Returns text or error.

Description

Queries field type for given position in result.
Returns text, date, number, time, timestamp, boolean, container or invalid.

Example Databases

SQL in FileMaker/SQL Select Container

Blog Entries

Execute SQL in FileMaker and get back native field types

Created 18th April 2015, last changed 14th September 2015

FM.SQL.FieldCount - FM.SQL.InsertRecords