|
Name | Value | Description |
---|---|---|
adAffectAll | 3 | Operation affects all records in the recordset. |
adAffectAllChapters | 4 | Operation affects all child (chapter) records. |
adAffectCurrent | 1 | Operation affects only the current record. |
adAffectGroup | 2 | Operation affects records that satisfy the current Filter property. |
Name | Value | Description |
---|---|---|
adBookmarkCurrent |
| Default. Start at the current record. |
adBookmarkFirst | 1 | Start at the first record. |
adBookmarkLast | 2 | Start at the last record. |
Name | Value | Description |
---|---|---|
adResyncAll | 15 | Only invoke the Resync for each row that has pending changes. |
adResyncAutoIncrement | 1 | Default. Only invoke Resync for all successfully inserted rows, including their AutoIncrement column values. |
adResyncConflicts | 2 | Only invoke Resync for which the last Update or Delete failed due to a concurrency conflict. |
adResyncInserts | 8 | Only invoke Resync for all successfully inserted rows, including their Identity column values. |
adResyncNone |
| Do not invoke Resync . |
adResyncUpdates | 4 | Only invoke Resync for all successfully updated rows. |
Name | Value | Description |
---|---|---|
adCmdFile | 256 | Indicates that the provider should evaluate CommandText as a previously persisted file. |
adCmdStoredProc | 4 | Indicates that the provider should evaluate CommandText as a stored procedure. |
adCmdTable | 2 | Indicates that the provider should generate a SQL query to return all rows from the table named in CommandText . |
adCmdTableDirect | 512 | Indicates that the provider should return all rows from the table named in CommandText . |
adCmdText | 1 | Indicates that the provider should evaluate CommandText as textual definition of a command, such as a SQL statement. |
adCmdUnknown | 8 | Indicates that the type of command in CommandText unknown. |
Name | Value | Description |
---|---|---|
adCompareEqual | 1 | The bookmarks are equal. |
adCompareGreaterThan | 2 | The first bookmark is after the second. |
adCompareLessThan |
| The first bookmark is before the second. |
adCompareNotComparable | 4 | The bookmarks cannot be compared. |
adCompareNotEqual | 3 | The bookmarks are not equal and not ordered. |
Name | Value | Description |
---|---|---|
adModeRead | 1 | Indicates read-only permissions. |
adModeReadWrite | 3 | Indicates read/write permissions. |
adModeShareDenyNone | 16 | Prevents others from opening connection with any permissions. |
adModeShareDenyRead | 4 | Prevents others from opening connection with read permissions. |
adModeShareDenyWrite | 8 | Prevents others from opening connection with write permissions. |
adModeShareExclusive | 12 | Prevents others from opening connection. |
adModeUnknown |
| Default. Indicates that the permissions have not yet been set or cannot be determined. |
adModeWrite | 2 | Indicates write-only permissions. |
Name | Value | Description |
---|---|---|
adAsyncConnect | 16 | Open the connection asynchronously. |
adConnectUnspecified | -1 | The connection mode is unspecified. |
Name | Value | Description |
---|---|---|
adPromptAlways | 1 | Always prompt for connection information. |
adPromptComplete | 2 | Only prompt if not enough information was supplied. |
adPromptCompleteRequired | 3 | Only prompt if not enough information was supplied, but disable any options not directly applicable to the connection. |
adPromptNever | 4 | Default. Never prompt for connection information. |
Name | Value | Description |
---|---|---|
adUseClient | 3 | Use client-side cursors supplied by the local cursor library. |
adUseClientBatch | 3 | Use client-side cursors supplied by the local cursor library. |
adUseNone | 1 | No cursor services are used. |
adUseServer | 2 | Default. Uses data provider driver supplied cursors. |
Name | Value | Description |
---|---|---|
adAddNew | 16778240 | You can use the AddNew method to add new records. |
adApproxPosition | 16384 | You can read and set the AbsolutePosition and AbsolutePage properties. |
adBookmark | 8192 | You can use the Bookmark property to access specific records. |
adDelete | 16779264 | You can use the Delete method to delete records. |
adFind | 524288 | You can use the Find method to find records. |
adHoldRecords | 256 | You can retrieve more records or change the next retrieve position without committing all pending changes. |
adIndex | 8388608 | You can use the Index property to name an index. This value is new to ADO 2.1. |
adMovePrevious | 512 | You can use the ModeFirst , MovePrevious , Move and GetRows methods . |
adNotify | 262144 | The recordset supports Notifications. |
adResync | 131072 | You can update the cursor with the data visible in the underlying database with the Resync method. |
adSeek | 4194304 | You can use the Seek method to find a row in a Recordset. This value is new to ADO 2.1. |
adUpdate | 16809984 | You can use the Update method to modify existing records. |
adUpdateBatch | 65536 | You can use the UpdateBatch or CancelBatch methods to transfer changes to the provider in groups. |
Name | Value | Description |
---|---|---|
adOpenDynamic | 2 | Opens a dynamic type cursor. |
adOpenForwardOnly |
| Default. Opens a forward-only type cursor |
adOpenKeyset | 1 | Opens a keyset type cursor. |
adOpenStatic | 3 | Opens a static type cursor. |
adOpenUnspecified | -1 | Indicates an unspecified value for cursor type. |
Name | Value | Description |
---|---|---|
adBigInt | 20 | An 8-byte signed integer. |
adBinary | 128 | A binary value. |
adBoolean | 11 | A Boolean value. |
adBSTR | 8 | A null- terminated character string. |
adChapter | 136 | A chapter type, indicating a child recordset. |
adChar | 129 | A String value. |
adCurrency | 6 | A currency value. An 8-byte signed integer scaled by 10,000, with 4 digits to the right of the decimal point. |
adDate | 7 | A Date value. A Double where the whole part is the number of days since December 30 1899, and the fractional part is a fraction of the day. |
adDBDate | 133 | A date value (yyyymmdd). |
adDBFileTime | 137 | A database file time. |
adDBTime | 134 | A time value (hhmmss). |
adDBTimeStamp | 135 | A date-time stamp (yyyymmddhhmmss plus a fraction in billionths). |
adDecimal | 14 | An exact numeric value with fixed precision and scale. |
adDouble | 5 | A double-precision floating point value. |
adEmpty |
| No value was specified. |
adError | 10 | A 32-bit error code. |
adFileTime | 64 | A DOS/Win32 file time. The number of 100 nanosecond intervals since Jan 1 1601. |
adGUID | 72 | A globally unique identifier. |
adIDispatch | 9 | A pointer to an IDispatch interface on an OLE object. |
adInteger | 3 | A 4-byte signed integer. |
adIUnknown | 13 | A pointer to an IUnknown interface on an OLE object. |
adLongVarBinary | 205 | A long binary value. |
adLongVarChar | 201 | A long String value. |
adLongVarWChar | 203 | A long null-terminated string value. |
adNumeric | 131 | An exact numeric value with a fixed precision and scale. |
adPropVariant | 138 | A variant that is not equivalent to an Automation variant. |
adSingle | 4 | A single-precision floating point value. |
adSmallInt | 2 | A 2-byte signed integer. |
adTinyInt | 16 | A 1-byte signed integer. |
adUnsignedBigInt | 21 | An 8-byte unsigned integer. |
adUnsignedInt | 19 | A 4-byte unsigned integer. |
adUnsignedSmallInt | 18 | A 2-byte unsigned integer. |
adUnsignedTinyInt | 17 | A 1-byte unsigned integer. |
adUserDefined | 132 | A user -defined variable. |
adVarBinary | 204 | A binary value. |
adVarChar | 200 | A String value. |
adVariant | 12 | An Automation Variant. |
adVarNumeric | 139 | A variable width exact numeric, with a signed scale value. |
adVarWChar | 202 | A null-terminated Unicode character string. |
adWChar | 130 | A null-terminated Unicode character string. |
Name | Value | Description |
---|---|---|
adEditAdd | 2 | Indicates that the AddNew method has been invoked and the current record in the buffer is a new record that hasn't been saved to the database. |
adEditDelete | 4 | Indicates that the Delete method has been invoked. |
adEditInProgress | 1 | Indicates that data in the current record has been modified but not saved. |
adEditNone |
| Indicates that no editing is in progress. |
Name | Value | Description |
---|---|---|
adErrBoundToCommand | 3707 | The application cannot change the ActiveConnection property of a Recordset object with a Command object as its source. |
adErrDataConversion | 3421 | The application is using a value of the wrong type for the current application. |
adErrFeatureNotAvailable | 3251 | The operation requested by the application is not supported by the provider. |
adErrIllegalOperation | 3219 | The operation requested by the application is not allowed in this context. |
adErrInTransaction | 3246 | The application cannot explicitly close a Connection object while in the middle of a transaction. |
adErrInvalidArgument | 3001 | The application is using arguments that are the wrong type, are out of the acceptable range, or are in conflict with one another. |
adErrInvalidConnection | 3709 | The application requested an operation on an object with a reference to a closed or invalid Connection object. |
adErrInvalidParamInfo | 3708 | The application has improperly defined a Parameter object. |
adErrItemNotFound | 3265 | ADO could not find the object in the collection. |
adErrNoCurrentRecord | 3021 | Either BOF or EOF is True , or the current record has been deleted. The operation requested by the application requires a current record. |
adErrNotExecuting | 3715 | The operation is not executing. |
adErrNotReentrant | 3710 | The operation is not reentrant. |
adErrObjectClosed | 3704 | The operation requested by the application is not allowed if the object is closed. |
adErrObjectInCollection | 3367 | Can't append. Object already in collection. |
adErrObjectNotSet | 3420 | The object referenced by the application no longer points to a valid object. |
adErrObjectOpen | 3705 | The operation requested by the application is not allowed if the object is open. |
adErrOperationCancelled | 3712 | The operation was cancelled. |
adErrProviderNotFound | 3706 | ADO could not find the specified provider. |
adErrStillConnecting | 3713 | The operation is still connecting. |
adErrStillExecuting | 3711 | The operation is still executing. |
adErrUnsafeOperation | 3716 | The operation is unsafe under these circumstances. |
Name | Value | Description |
---|---|---|
adRsnAddNew | 1 | A new record is to be added. |
adRsnClose | 9 | The object is being closed. |
adRsnDelete | 2 | The record is being deleted. |
adRsnFirstChange | 11 | The record has been changed for the first time. |
adRsnMove | 10 | A Move has been invoked and the current record pointer is being moved. |
adRsnMoveFirst | 12 | A MoveFirst has been invoked and the current record pointer is being moved. |
adRsnMoveLast | 15 | A MoveLast has been invoked and the current record pointer is being moved. |
adRsnMoveNext | 13 | A MoveNext has been invoked and the current record pointer is being moved. |
adRsnMovePrevious | 14 | A MovePrevious has been invoked and the current record pointer is being moved. |
adRsnRequery | 7 | The recordset was requeried. |
adRsnResynch | 8 | The recordset was resynchronized. |
adRsnUndoAddNew | 5 | The addition of a new record has been cancelled. |
adRsnUndoDelete | 6 | The deletion of a record has been cancelled. |
adRsnUndoUpdate | 4 | The update of a record has been cancelled. |
adRsnUpdate | 3 | The record is being updated. |
Name | Value | Description |
---|---|---|
adStatusCancel | 4 | Request cancellation of the operation that is about to occur. |
adStatusCantDeny | 3 | A Will event cannot request cancellation of the operation about to occur. |
adStatusErrorsOccurred | 2 | The operation completed unsuccessfully, or a Will event cancelled the operation. |
adStatusOK | 1 | The operation completed successfully. |
adStatusUnwantedEvent | 5 | Events for this operation are no longer required. |
Name | Value | Description |
---|---|---|
adAsyncExecute | 16 | The operation is executed asynchronously. |
adAsyncFetch | 32 | The records are fetched asynchronously. |
adAsyncFetchNonBlocking | 64 | The records are fetched asynchronously without blocking subsequent operations. |
adExecuteNoRecords | 128 | Indicates CommandText is a command or stored procedure that does not return rows. Always combined with adCmdText or adCmdStoreProc . |
Name | Value | Description |
---|---|---|
adFldCacheDeferred | 4096 | Indicates that the provider caches field values and that subsequent reads are done from the cache. |
adFldFixed | 16 | Indicates that the field contains fixed-length data. |
adFldIsNullable | 32 | Indicates that the field accepts Null values. |
adFldKeyColumn | 32768 | The field is part of a key column. |
adFldLong | 128 | Indicates that the field is a long binary field, and that the AppendChunk and GetChunk methods can be used. |
adFldMayBeNull | 64 | Indicates that you can read Null values from the field. |
adFldMayDefer | 2 | Indicates that the field is deferred, that is, the field values are not retrieved from the data source with the whole record, but only when you access them. |
adFldNegativeScale | 16384 | The field has a negative scale. |
adFldRowID | 256 | Indicates that the field some kind of record ID. |
adFldRowVersion | 512 | Indicates that the field time or date stamp used to track updates. |
adFldUnknownUpdatable | 8 | Indicates that the provider cannot determine if you can write to the field. |
adFldUpdatable | 4 | Indicates that you can write to the field. |
Name | Value | Description |
---|---|---|
adFilterAffectedRecords | 2 | Allows you to view only records affected by the last Delete , Resync , UpdateBatch , or CancelBatch method. |
adFilterConflictingRecords | 5 | Allows you to view the records that failed the last batch update attempt. |
adFilterFetchedRecords | 3 | Allows you to view records in the current cache. |
adFilterNone |
| Removes the current filter and restores all records to view. |
adFilterPendingRecords | 1 | Allows you to view only the records that have changed but have not been sent to the server. Only applicable for batch update mode. |
adFilterPredicate | 4 | Allows you to view records that failed the last batch update attempt. |
Name | Value | Description |
---|---|---|
adGetRowsRest | -1 | Retrieves the remainder of the rows in the recordset. |
Name | Value | Description |
---|---|---|
adXactBrowse | 256 | Indicates that from one transaction you can view uncommitted changes in other transactions. |
adXactChaos | 16 | Default. Indicates that you cannot overwrite pending changes from more highly isolated transactions. |
adXactCursorStability | 4096 | Default. Indicates that from one transaction you can view changes in other transactions only after they have been committed. |
adXactIsolated | 1048576 | Indicates that transactions are conducted in isolation of other transactions. |
adXactReadCommitted | 4096 | Same as adXactCursorStability . |
adXactReadUncommitted | 256 | Same as adXactBrowse . |
adXactRepeatableRead | 65536 | Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets. |
adXactSerializable | 1048576 | Same as adXactIsolated . |
adXactUnspecified | -1 | Indicates that the provider is using a different IsolationLevel than specified, but that the level cannot be identified. |
Name | Value | Description |
---|---|---|
adLockBatchOptimistic | 4 | Optimistic batch updates. |
adLockOptimistic | 3 | Optimistic locking, record by record. The provider locks records when Update is called. |
adLockPessimistic | 2 | Pessimistic locking, record by record. The provider locks the record immediately upon editing. |
adLockReadOnly | 1 | Default. Read-only, data cannot be modified. |
adLockUnspecified | -1 | The clone is created with the same lock type as the original. |
Name | Value | Description |
---|---|---|
adMarshalAll |
| Default. Indicates that all rows are returned to the server. |
adMarshalModifiedOnly | 1 | Indicates that only modified rows are returned to the server. |
Name | Value | Description |
---|---|---|
adStateClosed |
| Default. Indicates that the object is closed. |
adStateConnecting | 2 | Indicates that the object is connecting. |
adStateExecuting | 4 | Indicates that the object is executing a command. |
adStateFetching | 8 | Indicates that the rows of the recordset are being fetched. |
adStateOpen | 1 | Indicates that the object is open. |
Name | Value | Description |
---|---|---|
adParamLong | 128 | Indicates that the parameter accepts long binary data. |
adParamNullable | 64 | Indicates that the parameter accepts Null values. |
adParamSigned | 16 | Default. Indicates that the parameter accepts signed values. |
Name | Value | Description |
---|---|---|
adParamInput | 1 | Default. Indicates an input parameter. |
adParamInputOutput | 3 | Indicates both an input and output parameter. |
adParamOutput | 2 | Indicates an output parameter. |
adParamReturnValue | 4 | Indicates a return value. |
adParamUnknown |
| Indicates parameter direction is unknown. |
Name | Value | Description |
---|---|---|
adPersistADTG |
| Default. Persist data in Advanced Data Table Gram format. |
adPersistXML | 1 | Persist data in XML format. |
Name | Value | Description |
---|---|---|
adPosBOF | -2 | The current record pointer is at BOF . |
adPosEOF | -3 | The current record pointer is at EOF . |
adPosUnknown | -1 | The Recordset is empty, the current position is unknown, or the provider does not support the AbsolutePage property. |
Name | Value | Description |
---|---|---|
adPropNotSupported |
| Indicates that the property is not supported by the provider. |
adPropOptional | 2 | Indicates that the user does not need to specify a value for this property before the data source is initialized . |
adPropRead | 512 | Indicates that the user can read the property. |
adPropRequired | 1 | Indicates that the user must specify a value for this property before the data source is initialized. |
adPropWrite | 1024 | Indicates that the user can set the property. |
Name | Value | Description |
---|---|---|
adRecCanceled | 256 | The record was not saved because the operation was cancelled. |
adRecCantRelease | 1024 | The new record was not saved because of existing record locks. |
adRecConcurrencyViolation | 2048 | The record was not saved because optimistic concurrency was in use. |
adRecDBDeleted | 262144 | The record has already been deleted from the data source. |
adRecDeleted | 4 | The record was deleted. |
adRecIntegrityViolation | 4096 | The record was not saved because the user violated integrity constraints. |
adRecInvalid | 16 | The record was not saved because its bookmark is invalid. |
adRecMaxChangesExceeded | 8192 | The record was not saved because there were too many pending changes. |
Name | Value | Description |
---|---|---|
adResyncAllValues | 2 | Default. Data is overwritten and pending updates are cancelled. |
adResyncUnderlyingValues | 1 | Data is not overwritten and pending updates are not cancelled. |
Name | Value | Description |
---|---|---|
adSchemaAsserts |
| Request assert information. |
adSchemaCatalogs | 1 | Request catalog information. |
adSchemaCharacterSets | 2 | Request character set information. |
adSchemaCheckConstraints | 5 | Request check constraint information. |
adSchemaCollations | 3 | Request collation information. |
adSchemaColumnPrivileges | 13 | Request column privilege information. |
adSchemaColumns | 4 | Request column information. |
adSchemaColumnsDomainUsage | 11 | Request column domain usage information. |
adSchemaConstraintColumnUsage | 6 | Request column constraint usage information. |
adSchemaConstraintTableUsage | 7 | Request table constraint usage information. |
adSchemaCubes | 32 | For multi-dimensional data, view the Cubes schema. |
adSchemaDBInfoKeywords | 30 | Request the keywords from the provider. |
adSchemaDBInfoLiterals | 31 | Request the literals from the provider. |
adSchemaDimensions | 33 | For multi-dimensional data, view the Dimensions schema. |
adSchemaForeignKeys | 27 | Request foreign key information. |
adSchemaHierarchies | 34 | For multi-dimensional data, view the Hierarchies schema. |
adSchemaIndexes | 12 | Request index information. |
adSchemaKeyColumnUsage | 8 | Request key column usage information. |
adSchemaLevels | 35 | For multi-dimensional data, view the Levels schema. |
adSchemaMeasures | 36 | For multi-dimensional data, view the Measures schema. |
adSchemaMembers | 38 | For multi-dimensional data, view the Members schema. |
adSchemaPrimaryKeys | 28 | Request primary key information. |
adSchemaProcedureColumns | 29 | Request stored procedure column information. |
adSchemaProcedureParameters | 26 | Request stored procedure parameter information. |
adSchemaProcedures | 16 | Request stored procedure information. |
adSchemaProperties | 37 | For multi-dimensional data, view the Properties schema. |
adSchemaProviderSpecific | -1 | Request provider specific information. |
adSchemaProviderTypes | 22 | Request provider type information. |
adSchemaReferentialContraints | 9 | Request referential constraint information. |
adSchemaSchemata | 17 | Request schema information. |
adSchemaSQLLanguages | 18 | Request SQL language support information. |
adSchemaStatistics | 19 | Request statistics information. |
adSchemaTableConstraints | 10 | Request table constraint information. |
adSchemaTablePrivileges | 14 | Request table privilege information. |
adSchemaTables | 20 | Request information about the tables. |
adSchemaTranslations | 21 | Request character set translation information. |
adSchemaTrustees | 39 | Request trustee information. This value is new for ADO 2.1. |
adSchemaUsagePrivileges | 15 | Request user privilege information. |
adSchemaViewColumnUsage | 24 | Request column usage in views information. |
adSchemaViews | 23 | Request view information. |
adSchemaViewTableUsage | 25 | Request table usage in views information. |
Name | Value | Description |
---|---|---|
adSearchBackward | -1 | Search backward from the current record. |
adSearchForward | 1 | Search forward from the current record. |
Name | Value | Description |
---|---|---|
adSearchBackward | -1 | Search backward from the current record. |
adSearchForward | 1 | Search forward from the current record. |
Name | Value | Description |
---|---|---|
adSeekAfter | 8 | Seek the record after the match. |
adSeekAfterEQ | 4 | Seek the record equal to the match, or if no match is found, the record after where the match would have been. |
adSeekBefore | 32 | Seek the record before the match. |
adSeekBeforeEQ | 16 | Seek the record equal to the match, or if no match is found, the record before where the match would have been. |
adSeekFirstEQ | 1 | Seek the first record equal to the match. |
adSeekLastEQ | 2 | Seek the last record equal to the match. |
Name | Value | Description |
---|---|---|
adClipString | 2 | Rows are delimited by user defined values. |
Name | Value | Description |
---|---|---|
adXactAbortRetaining | 262144 | The provider will automatically start a new transaction after a RollbackTrans method call. |
adXactAsyncPhaseOne | 524288 | Perform an asynchronous commit. |
adXactCommitRetaining | 131072 | The provider will automatically start a new transaction after a CommitTrans method call. |
adXactSyncPhaseOne | 1048576 | Performs a synchronous commit. |
|