Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
By default, any change you make to the database using ADO is committed as soon as it is executed. This includes explicit updates, as well as the UpdateBatch method on a Recordset. However, the previous section illustrated that you can use the BeginTrans and RollbackTrans or CommitTrans methods on the Connection object to use transactions.
The transaction isolation level is set as a property of the Connection object. The IsolationLevel property can take on one of the following values:
|ADO isolation level||Constant||SQL Anywhere level|
|Unspecified||adXactUnspecified||Not applicable. Set to 0|
|Chaos||adXactChaos||Unsupported. Set to 0|
|Readonly statement snapshot||8388608||6|
For more information on isolation levels, see Isolation levels and consistency.