SQL.FieldExists
---------------

Checks whether a field exists.

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

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

**MBS**( **"SQL.FieldExists";** /\* Checks whether a field exists. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Field**) /\* The name of the field to check.e.g. "FirstName" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |
| Field | The name of the field to check. | "FirstName" |

### Result

Returns 1, 0 or error.

### Description

Checks whether a field exists.  
### See also

- [SQL.NewCommand](SQLNewCommand.md)

### Release notes

- **Version 11.4**
    - Added [SQL.FieldExists](https://www.mbsplugins.eu/SQLFieldExists.shtml) function.

### Blog Entries

- [New in MBS FileMaker Plugin 11.4](https://www.mbsplugins.de/archive/2021-09-15/New_in_MBS_FileMaker_Plugin_11/monkeybreadsoftware_blog_filemaker)
- [Neues MBS FileMaker Plugin 11.4](https://www.mbsplugins.de/archive/2021-09-07/Neues_MBS_FileMaker_Plugin_114/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin 11.4 - More than 6500 Functions In One Plugin](https://www.mbsplugins.de/archive/2021-09-07/MBS_FileMaker_Plugin_114_-_Mor/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.4pr5](https://www.mbsplugins.de/archive/2021-09-03/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 2nd September 2021 , last changed 2nd September 2021

  
[SQL.FieldCount](SQLFieldCount.md) - [SQL.FreeAllConnections](SQLFreeAllConnections.md)

[HTML Version](SQLFieldExists.shtml)