Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

SQL.GetAutoCommit

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

Component Version macOS Windows Linux Server iOS SDK
SQL 2.6 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.GetAutoCommit"; Connection )   More

Parameters

Parameter Description Example
Connection The connection reference number gained with SQL.NewConnection. $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. Returns "Unknown" if no autocommit mode was set. In that case see DBMS specific documentation for default autocommit option used.

See also

FileMaker Magazin

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


SQL.FreeConnection - SQL.GetCommandOption

Feedback: Report problem or ask question.