To assist in debugging, the ADO enumerations list a value for each constant. However, this value is purely advisory, and may change from one release of ADO to another. Your code should only depend on the name, not the actual value, of each enumerated constant.
ADO Enumerated Constant Summary
| Enumeration | Description |
| ADCPROP_ASYNCTHREADPRIORITY_ENUM | For an RDS Recordset object, specifies the execution priority of the asynchronous thread that retrieves data. |
| ADCPROP_AUTORECALC_ENUM | Specifies when the MSDataShape provider re-calculates aggregate and calculated columns in a hierarchical Recordset. |
| ADCPROP_UPDATECRITERIA_ENUM | Specifies which fields can be used to detect conflicts during an optimistic update of a row of the data source with a Recordset object. |
| ADCPROP_UPDATERESYNC_ENUM | Specifies whether the UpdateBatch method is followed by an implicit Resync method operation and if so, the scope of that operation. |
| AffectEnum | Specifies which records are affected by an operation. |
| BookmarkEnum | Specifies a bookmark indicating where the operation should begin. |
| CommandTypeEnum | Specifies how a command argument should be interpreted. |
| CompareEnum | Specifies the relative position of two records represented by their bookmarks. |
| ConnectModeEnum | Specifies the available permissions for modifying data in a Connection, opening a Record, or specifying values for the Mode property of the Record and Stream objects. |
| ConnectOptionEnum | Specifies whether the Open method of a Connection object should return after (synchronously) or before (asynchronously) the connection is established. |
| ConnectPromptEnum | Specifies whether a dialog box should be displayed to prompt for missing parameters when opening a connection to an ODBC data source. |
| CopyRecordOptionsEnum | Specifies the behavior of the CopyRecord method. |
| CursorLocationEnum | Specifies the location of the cursor engine. |
| CursorOptionEnum | Specifies what functionality the Supports method should test for. |
| CursorTypeEnum | Specifies the type of cursor used in a Recordset object. |
| DataTypeEnum | Specifies the data type of a Field, Parameter, or Property. |
| EditModeEnum | Specifies the editing status of a record. |
| ErrorValueEnum | Specifies the type of ADO run-time error. |
| EventReasonEnum | Specifies the reason that caused an event to occur. |
| EventStatusEnum | Specifies the current status of the execution of an event. |
| ExecuteOptionEnum | Specifies how a provider should execute a command. |
| FieldEnum | Specifies the special fields referenced in a Record object's Fields collection. |
| FieldAttributeEnum | Specifies one or more attributes of a Field object. |
| FilterGroupEnum | Specifies the group of records to be filtered from a Recordset. |
| GetRowsOptionEnum | Specifies how many records to retrieve from a Recordset. |
| IsolationLevelEnum | Specifies the level of transaction isolation for a Connection object. |
| LineSeparatorsEnum | Specifies the character used as a line separator in text Stream objects. |
| LockTypeEnum | Specifies the type of lock placed on records during editing. |
| MarshalOptionsEnum | Specifies which records should be returned to the server. |
| MoveRecordOptionsEnum | Specifies the behavior of the Record object MoveRecord method. |
| ObjectStateEnum | Specifies whether an object is open or closed, connecting to a data source, executing a command, or fetching data. |
| ParameterAttributesEnum | Specifies the attributes of a Parameter object. |
| ParameterDirectionEnum | Specifies whether the Parameter represents an input parameter, an output parameter, or both, or if the parameter is the return value from a stored procedure. |
| PersistFormatEnum | Specifies the format in which to save a Recordset. |
| PositionEnum | Specifies the current position of the record pointer within a Recordset. |
| PropertyAttributesEnum | Specifies the attributes of a Property object. |
| RecordCreateOptionsEnum | Specifies for the Record object Open method whether an existing Record should be opened, or a new Record should be created. |
| RecordOpenOptionsEnum | Specifies options for opening a Record. These values may be combined by using an OR operator. |
| RecordStatusEnum | Specifies the status of a record with regard to batch updates and other bulk operations. |
| RecordTypeEnum | Specifies the type of Record object. |
| ResyncEnum | Specifies whether underlying values are overwritten by a call to Resync. |
| SaveOptionsEnum | Specifies whether a file should be created or overwritten when saving from a Stream object. The values can be combined with an AND operator. |
| SchemaEnum | Specifies the type of schema Recordset that the OpenSchema method retrieves. |
| SearchDirectionEnum | Specifies the direction of a record search within a Recordset. |
| SeekEnum | Specifies the type of Seek to execute. |
| StreamOpenOptionsEnum | Specifies options for opening a Stream object. The values can be combined with an AND operator. |
| StreamReadEnum | Specifies whether the whole stream or the next line should be read from a Stream object. |
| StreamTypeEnum | Specifies the type of data stored in a Stream object. |
| StreamWriteEnum | Specifies whether a line separator is appended to the string written to a Stream object. |
| StringFormatEnum | Specifies the format when retrieving a Recordset as a string. |
| XactAttributeEnum | Specifies the transaction attributes of a Connection object. |