| 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
This function checks for a license.
Created 18th April 2015, last changed 14th September 2015
