Purpose
All the values of the FieldStatus Enum:
The type of action to be performed when SetPermissions is called.
Prototype
FUNCTION AdoFieldStatusEnum ( ) AS ARRAY
Return
ARRAY Every row in this array has 2 values:
• The numeric value of the Enum value
• A text representation of this value
This array can be used to validate values, and to print a meaningful description of the values during debugging You can pass this array to the AdoEnum2Str() function to convert the value of an Enum to a string
Description
List of possible values
| 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. |
See Also
Enums, AdoEnum2Str(), AdoStr2Enum()
