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:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
SQL.GetAutoCommit
Checks whether autocommit is enabled or disabled for the current connection.
| Component | Version | macOS | Windows | Linux | Server | FileMaker 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.
Links
MBS FileMaker blog
