ADO 상태 속성
❮ 전체 필드 개체 참조
Status 속성은 Field 개체의 상태를 나타내는 FieldStatusEnum 값을 반환합니다. 기본값은 adFieldOK입니다.
업데이트가 실패하면 오류가 반환되고 Status 속성은 작업과 오류 상태 코드의 결합된 값을 나타냅니다. 각 필드의 상태 속성을 사용하여 필드가 추가, 수정 또는 삭제되지 않은 이유를 확인할 수 있습니다.
필드 추가, 수정 또는 삭제와 관련된 문제는 이 속성을 통해 보고됩니다. 예를 들어 사용자가 필드를 삭제하면 필드 컬렉션에서 삭제로 표시됩니다. 사용자가 권한이 없는 필드를 삭제하려고 하여 업데이트 호출이 오류를 반환하는 경우 이 필드의 상태는 adFieldPermissionDenied 또는 adFieldPendingDelete가 됩니다.
통사론
objfield.Status
예시
<%
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
%>
FieldStatusEnum 값
Constant | Value | Description |
---|---|---|
adFieldOK | 0 | Default. The field was successfully added or deleted |
adFieldCantConvertValue | 2 | The field cannot be retrieved or stored without loss of data |
adFieldIsNull | 3 | The provider returned a null value |
adFieldTruncated | 4 | Variable-length data was truncated when reading from the data source |
adFieldSignMismatch | 5 | The data value returned by the provider was signed, but the data type of the ADO field value was unsigned |
adFieldDataOverflow | 6 | The data returned from the provider overflowed the data type of the field |
adFieldCantCreate | 7 | The field could not be added because the provider exceeded a limitation |
adFieldUnavailable | 8 | The provider could not determine the value when reading from the data source |
adFieldPermissionDenied | 9 | The field cannot be modified because it is read-only |
adFieldIntegrityViolation | 10 | The field cannot be modified because it is a calculated or derived entity |
adFieldSchemaViolation | 11 | The value violated the data source schema constraint for the field |
adFieldBadStatus | 12 | An invalid status value was sent from ADO to the OLE DB provider |
adFieldDefault | 13 | The default value for the field was used when setting data |
adFieldIgnore | 15 | This field was skipped when setting data values in the source |
adFieldDoesNotExist | 16 | The field does not exist |
adFieldInvalidURL | 17 | The data source URL contains invalid characters |
adFieldResourceLocked | 18 | The provider cannot perform the operation because the data source is locked |
adFieldResourceExists | 19 | The provider cannot perform the operation because an object already exists at the destination URL and it is not able to overwrite the object |
adFieldCannotComplete | 20 | The server of the URL specified by Source could not complete the operation |
adFieldVolumeNotFound | 21 | The provider is unable to locate the storage volume indicated by the URL |
adFieldOutOfSpace | 22 | The provider is unable to obtain enough storage space to complete a move or copy operation |
adFieldCannotDeleteSource | 23 | During a move operation, a tree or subtree was moved to a new location, but the source could not be deleted |
adFieldReadOnly | 24 | The field in the data source is read-only |
adFieldResourceOutOfScope | 25 | A source or destination URL is outside the scope of the current record |
adFieldAlreadyExists | 26 | The specified field already exists |
adFieldPendingInsert | 0x10000 | The Append operation caused the status to be set. The field has been marked to be added to the Fields collection after the Update method is called |
adFieldPendingDelete | 0x20000 | The Delete operation caused the status to be set. The field has been marked for deletion from the Fields collection after the Update method is called |
adFieldPendingChange | 0x40000 | The field has been deleted and then re-added or the value of the field which previously had a status of adFieldOK has changed |
adFieldPendingUnknown | 0x80000 | The provider cannot determine what operation caused field status to be set |
adFieldPendingUnknownDelete | 0x100000 | The provider cannot determine what operation caused field status to be set, and that the field will be deleted from the Fields collection after the Update method is called. |
❮ 전체 필드 개체 참조