Specifies the status of a Field object.
The adFieldPending* values indicate the operation that caused the status to be set, and may be combined with other status values.
| Constant | Value | Description |
| adFieldAlreadyExists | 26 | Indicates that the specified field already exists. |
| adFieldBadStatus | 12 | Indicates that an invalid status value was sent from ADO to the OLE DB provider. Possible causes include an OLE DB 1.0 or 1.1 provider, or an improper combination of Value and Status. |
| adFieldCannotComplete | 20 | Indicates that the server of the URL specified by Source could not complete the operation. |
| adFieldCannotDeleteSource | 23 | Indicates that during a move operation, a tree or subtree was moved to a new location, but the source could not be deleted. |
| adFieldCantConvertValue | 2 | Indicates that the field cannot be retrieved or stored without loss of data. |
| adFieldCantCreate | 7 | Indicates that the field could not be added because the provider exceeded a limitation (such as the number of fields allowed). |
| adFieldDataOverflow | 6 | Indicates that the data returned from the provider overflowed the data type of the field. |
| adFieldDefault | 13 | Indicates that the default value for the field was used when setting data. |
| adFieldDoesNotExist | 16 | Indicates that the field specified does not exist. |
| adFieldIgnore | 15 | Indicates that this field was skipped when setting data values in the source. No value was set by the provider. |
| adFieldIntegrityViolation | 10 | Indicates that the field cannot be modified because it is a calculated or derived entity. |
| adFieldInvalidURL | 17 | Indicates that the data source URL contains invalid characters. |
| adFieldIsNull | 3 | Indicates that the provider returned a null value. |
| adFieldOK | 0 | Default. Indicates that the field was successfully added or deleted. |
| adFieldOutOfSpace | 22 | Indicates that the provider is unable to obtain enough storage space to complete a move or copy operation. |
| adFieldPendingChange | 0x40000 | Indicates either that the field has been deleted and then re-added, perhaps with a different data type, or that the value of the field which previously had a status of adFieldOK has changed. The final form of the field will modify the Fields collection after the Update method is called. |
| adFieldPendingDelete | 0x20000 | Indicates that 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. |
| adFieldPendingInsert | 0x10000 | Indicates that 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. |
| adFieldPendingUnknown | 0x80000 | Indicates that the provider cannot determine what operation caused field status to be set. |
| adFieldPendingUnknownDelete | 0x100000 | Indicates that 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. |
| adFieldPermissionDenied | 9 | Indicates that the field cannot be modified because it is defined as read-only. |
| adFieldReadOnly | 24 | Indicates that the field in the data source is defined as read-only. |
| adFieldResourceExists | 19 | Indicates that the provider was unable to perform the operation because an object already exists at the destination URL and it is not able to overwrite the object. |
| adFieldResourceLocked | 18 | Indicates that the provider was unable to perform the operation because the data source is locked by one or more other application or process. |
| adFieldResourceOutOfScope | 25 | Indicates that a source or destination URL is outside the scope of the current record. |
| adFieldSchemaViolation | 11 | Indicates that the value violated the data source schema constraint for the field. |
| adFieldSignMismatch | 5 | Indicates that data value returned by the provider was signed but the data type of the ADO field value was unsigned. |
| adFieldTruncated | 4 | Indicates that variable-length data was truncated when reading from the data source. |
| adFieldUnavailable | 8 | Indicates that the provider could not determine the value when reading from the data source. For example, the row was just created, the default value for the column was not available, and a new value had not yet been specified. |
| adFieldVolumeNotFound | 21 | Indicates that the provider is unable to locate the storage volume indicated by the URL. |
ADO/WFC Equivalent
These constants do not have ADO/WFC equivalents.