standard.db.sql.ODBCAutoCommit

ODBCAutoCommit is available since version 1.0.

Prototype:

number ODBCAutoCommit(boolean auto_commit_flag[, number connectionID])

Parameters

auto_commit_flag
if true, the connection will automatically commit the data. If false, a call to ODBCCommit will be required. Set to false, if you want to use ODBCCommit and ODBCRollback.
connectionID
the ID identifying the connection as returned by ODBCDriverConnect or ODBCConnect. If this parameter is missing, this will affect the first connection created.

Description:

Changes the default commit mode. By default, the auto commit option is set to true. If set to false, you need to manually commit the data by calling ODBCCommit (or ODBCRollback to cancel).

Return value:

Returns -1 if failed (call ODBCError to retrieve the error) or 0 if succeeded.