| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
FM.SQL.FieldType
Queries field type for given position in result.
| Component | Version | macOS | Windows | Linux | Server | 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 |
Result
Returns text or error.
Description
Queries field type for given position in result.Returns text, date, number, time, timestamp, boolean, container or invalid.
See also
Example Databases
Blog Entries
- MBS FileMaker Advent calendar - Door 7 - Precise entries and their types
- Execute SQL in FileMaker and get back native field types
This function checks for a license.
Created 18th April 2015, last changed 14th September 2015
