当前位置: 首页 > 网络学院 > 服务端脚本教程 > ADO > ADO IsolationLevel 属性

ADO
ADO DataTypes
ADO 摘要
ADO 实例

ADO IsolationLevel 属性


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-03-04   浏览: 423 ::
收藏到网摘: 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

登陆 | 还没注册?