The Status property returns a FieldStatusEnum value that indicates the status of a Field object. Default value is adFieldOK.
Status属性的作用是：返回一个指示字段对象状态的值，该值为FieldStatusEnum之中的其中一个。默认值为adFieldOK。

If any updates fail then an error is returned and the Status property indicates the combined values of the operation and error status code. The Status property for each Field can be used to determine why the Field was not added, modified, or deleted.
如果更新失败，那么它将返回错误提示，此时，Status[状态]属性将给出操作和错误代码。每个字段的Status[状态]属性可以用来解释为什么字段不能被添加、修改或是删除。

Problems with adding, modifying, or deleting a Field are reported through this property. For example, if a user deletes a Field, it will be marked for deletion in the Fields collection. If the Update call returns an error because the user tried to delete a Field for which he does not have permission, the Status for this field will be adFieldPermissionDenied or adFieldPendingDelete.
在对一个字段进行添加、修改或删除的过程中，所有问题都是通过Status[状态]属性出具错误报告的。举个例子来说，如果用户删除一个字段，它将对字段集中需要删除的字段作出标记。如果用户对字段不具有删除权限而进行删除操作，导致更新请求出错，那么该字段的状态便是adFieldPermissionDenied或adFieldPendingDelete。

Syntax
语法

objfield.Status

Example
案例

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn

response.write(rs.Fields(0).Status)

rs.Close
conn.close
%>

评论 (0) All