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 when it is executed. This includes explicit updates, and 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|
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|