Edit

ADO Enumerated Constants

  • Article

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.

Constant 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 that indicates 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 the Fields collection of a Record object.
FieldAttributeEnum Specifies one or more attributes of a Field object.
FieldStatusEnum Specifies the status 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. Specifies the direction of a record search within a Recordset.
SearchDirectionEnum Specifies the direction of a record search within a Recordset. Specifies the type of Seek to execute.
SeekEnum Specifies the type of Seek to execute. Specifies options for opening a Stream object. The values can be combined with an AND operator.
StreamOpenOptionsEnum Specifies options for opening a Stream object. The values can be combined with an AND operator. Specifies whether the whole stream or the next line should be read from a Stream object.
StreamReadEnum Specifies whether the whole stream or the next line should be read from a Stream object. Specifies the type of data stored in a Stream object.
StreamTypeEnum Specifies the type of data stored in a Stream object. Specifies whether a line separator is appended to the string written to a Stream object.
StreamWriteEnum Specifies whether a line separator is appended to the string written to a Stream object. Specifies the format when retrieving a Recordset as a string.
StringFormatEnum Specifies the format when retrieving a Recordset as a string. Specifies the transaction attributes of a Connection object.
XactAttributeEnum Specifies the transaction attributes of a Connection object.

See Also

ADO API Reference
ADO Collections
ADO Dynamic Properties
Appendix B: ADO Errors
ADO Events
ADO Methods
ADO Object Model
ADO Objects and Interfaces
ADO Properties