SQL.GetAutoCommit
-----------------

Checks whether autocommit is enabled or disabled for the current connection.

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

MBS( "SQL.GetAutoCommit"; Connection ) 

**MBS**( **"SQL.GetAutoCommit";** /\* Checks whether autocommit is enabled or disabled for the current connection. \*/  
**$Connection**) /\* The connection reference number gained with [SQL.NewConnection](SQLNewConnection.md). \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Connection | The connection reference number gained with [SQL.NewConnection](SQLNewConnection.md). | $Connection |

### Result

Returns text "Unknown", "On", "Off" or error message.

### Description

Checks whether autocommit is enabled or disabled for the current connection.   
  
Function returns autocommit option state that was previously set by [SQL.SetAutoCommit](SQLSetAutoCommit.md). Returns "Unknown" if no autocommit mode was set. In that case see DBMS specific documentation for default autocommit option used.   
### See also

- [SQL.NewConnection](SQLNewConnection.md)
- [SQL.SetAutoCommit](SQLSetAutoCommit.md)

### FileMaker Magazin

- [Ausgabe 1/2016, Seite 30](https://filemaker-magazin.de/neuigkeit/3870-Appetithappen-FMM_201601)

This function is free to use.

Created 18th August 2014 , last changed 18th August 2014

  
[SQL.FreeConnection](SQLFreeConnection.md) - [SQL.GetCommandOption](SQLGetCommandOption.md)

[HTML Version](SQLGetAutoCommit.shtml)