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

Created 18th August 2014, last changed 25th October 2018


SQL.ServerVersionString - SQL.SetClient

Feedback: Report problem or ask question.


Start Chat