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.5
11.0
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
Statistic
FMM
Blog
SQL.SetAutoCommit
Enables or disables autocommit for the current connection, that is, automatic commit of every SQL command.
Component | Version | macOS | Windows | Linux | Server | iOS SDK | License |
SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | Free |
MBS( "SQL.SetAutoCommit"; Connection; AutoCommit ) More
Parameters
Parameter | Description | Example |
---|---|---|
Connection | The connection reference number gained with SQL.NewConnection. | $Connection |
AutoCommit | Whether to turn auto commit on or off. Can be "On" or "Off". | "On" |
Result
Returns "OK" or error message.
Description
Enables or disables autocommit for the current connection, that is, automatic commit of every SQL command.If autocommit is on, the database is committed automatically after each SQL command. Otherwise, transaction is committed only after Commit calling.
Examples
Turn auto commit off:
MBS( "SQL.SetAutoCommit"; $Connection; "off" )
See also
Example Databases
Blog Entries
FileMaker Magazin
Created 18th August 2014, last changed 25th October 2018
SQL.ServerVersionString - SQL.SetClient
Feedback: Report problem or ask question.
