The LockType property sets or returns a LockTypeEnum value that specifies the type of locking when editing a record in a Recordset. Default is adLockReadOnly. This property is read/write on a closed Recordset and read-only on an open Recordset.
LockType属性的作用是：设置或返回一个LockTypeEnum值，它用于编辑记录集中的记录时，指定锁的类型。默认值为：adLockReadOnly。这个属性对于一个关闭的记录集来说是可读/可写的；但对于一个已打开的记录集来说，是只读的。

Note: Set this property before opening the Recordset.
注意：必须在记录集打开之前设置该属性。

Note: Not all providers support all lock types. If the requested LockType setting is not supported, the provider will choose another type of locking. You can use the Supports method to determine the actual locking functionality available in a Recordset object.
注意：并不是所有的技术提供对象[providers]都支持所有的lock[锁]属性。如果被请求的LockType[所类型]不被支持，那么技术提供对象[providers]将选择另外一个锁类型。你可以使用Supports方法来确定在一个记录集中可使用的锁的功能。

Note: adLockPessimistic is not supported if CursorLocation is set to adUseClient.
注意：如果CursorLocation未被设置成asUseClient，那么将不支持adLockPessimistic。

Syntax
语法

objRecordset.LockType

Example
案例

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM Customers"

rs.CursorLocation=adUseClient
rs.CursorType=adOpenStatic
rs.LockType=adLockBatchOptimistic

rs.Open sql,conn

rs.Close
conn.Close
%>

评论 (0) All