繁體中文当前位置: 首页 > 网络学院 > 服务端脚本教程 > ADO > ADO IsolationLevel 属性
ADO IsolationLevel 属性
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-03-04 浏览: 400 :: 
收藏到网摘: n/a
The IsolationLevel property sets or returns the isolation level of a Connection object. The value is an IsolationLevelEnum value. Default is adXactChaos.
IsolationLevel属性的作用：设置或返回Connection对象的隔离程度。这个值可以是IsolationLevelEnum值中的一个值。默认值为adXactChaos。
Note: The IsolationLevel settings will not work until next time BeginTrans is called.
注意：IsolationLevel仅在下次请求BeginTrans时才会工作。
Syntax
语法
objconn.IsolationLevel |
Example
案例
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.IsolationLevel=adXactIsolated
conn.Open(Server.Mappath("northwind.mdb")) response.write(conn.IsolationLevel) conn.Close %> |
IsolationLevelEnum
| Constant常量 | Value值 | Description描述 |
| adXactUnspecified | -1 | Cannot use the specified isolation level, because the provider is using a different isolation level, and that level cannot be determined. 指示技术提供对象[provider]正在使用非指定的 IsolationLevel,但其级别无法确定 |
| adXactChaos | 16 | Cannot overwrite higher level transactions. 不允许覆盖高等级的事务 |
| adXactBrowse | 256 | Can view uncommitted changes in other transactions. 允许查看在其它事务中未授权的改变 |
| adXactReadUncommitted | 256 | Same as adXactBrowse. 等同于adXactBrowse |
| adXactCursorStability | 4096 | Can view committed changes in other transactions. 允许查看在其它事务中已授权的改变 |
| adXactReadCommitted | 4096 | Same as adXactCursorStability. 等同于adXactCursorStability |
| adXactRepeatableRead | 65536 | Cannot see changes in other transactions, but you can requery 指示无法从某事务中查看其他事务中所作的更改,但通过查询可以得到新记录集 |
| adXactIsolated | 1048576 | Your transactions are isolated from all other transactions. 所有事务相互独立 |
| adXactSerializable | 1048576 | Same as adXactIsolated. 等同于adXactIsolated |
评论 (0) All
