SQL.GetFieldDataType
--------------------

Returns field data type.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.GetFieldDataType"; Command; Field ) 

**MBS**( **"SQL.GetFieldDataType";** /\* Returns field data type. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Field**) /\* The name or one based index of the field. \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |
| Field | The name or one based index of the field. | $Field |

### Result

The field type or error message.

### Description

Returns field data type.  
  
The field data type can be: Bool, Short, UShort, Long, ULong, Double, Numeric, DateTime, Interval, String, Bytes, LongBinary, LongChar, BLob, CLob, Cursor, SpecificToDBMS or unknown  
### See also

- [SQL.GetFieldAsDateTime](SQLGetFieldAsDateTime.md)
- [SQL.GetParamDataType](SQLGetParamDataType.md)
- [SQL.NewCommand](SQLNewCommand.md)

This function is free to use.

Created 18th August 2014 , last changed 13th January 2015

  
[SQL.GetFieldAsTime](SQLGetFieldAsTime.md) - [SQL.GetFieldIsNull](SQLGetFieldIsNull.md)

[HTML Version](SQLGetFieldDataType.shtml)