Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.0   7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3    Statistic  

SQL.GetIsolationLevel

Gets the transaction isolation level.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 2.6 Yes Yes Yes Yes Yes

MBS( "SQL.GetIsolationLevel"; Connection )

Parameters

Parameter Description Example value
Connection The connection reference number gained with SQL.NewConnection. $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. 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.GetFieldValueList   -   SQL.GetParamAsBoolean

Feedback: Report problem or ask question.




Links
MBS Xojo tutorial videos