SQL.GetIsolationLevel
---------------------

Gets the transaction isolation level.

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

MBS( "SQL.GetIsolationLevel"; Connection ) 

**MBS**( **"SQL.GetIsolationLevel";** /\* Gets the transaction isolation level. \*/  
**$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 level name or error message.

### Description

Gets the transaction isolation level.  
  
Function returns isolation level that was previously set by [SQL.SetIsolationLevel](SQLSetIsolationLevel.md). Returns "Unknown" if no isolation level was set. In that case see DBMS specific documentation for default isolation level used.  
  
Returns one of the following strings: ReadUncommitted, ReadCommitted, RepeatableRead, Serializable or Unknown.  
### See also

- [SQL.NewConnection](SQLNewConnection.md)
- [SQL.SetIsolationLevel](SQLSetIsolationLevel.md)

This function is free to use.

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

  
[SQL.GetFieldsAsJSON](SQLGetFieldsAsJSON.md) - [SQL.GetParamAsBoolean](SQLGetParamAsBoolean.md)

[HTML Version](SQLGetIsolationLevel.shtml)