Commits the active transaction associated with the current connection.
The Commit function block can throw the CwDBConnectionException exception if a database error occurs.
The Commit function block ends the active transaction by committing any changes made to the database associated with the current connection. Together, the Begin Transaction, Commit, and Roll Back function blocks provide management of transaction boundaries for an explicit transaction. This transaction contains SQL queries, which include the SQL statements INSERT, DELETE, or UPDATE, and a stored procedure that includes one of these SQL statements.
Before beginning an explicit transaction, you must create a CwDBConnection object with the Get Database Connection function block. Make sure that this connection uses explicit transaction bracketing.
This function block is based on the CwDBConnection.commit() method. For more information, see commit().