ADO はバージョンにより微妙にクラスが異なる．オブジェクトブラウザーからクラスとメンバーを抽出して比較してみた．
Microsoft ActiveX DataObjects X.X Library のオブジェクト，メンバーおよび戻り値
Microsoft ActiveX DataObjects 2.8 Library および Microsoft ActiveX DataObjects 6.1 Library のオブジェクト，メンバーおよび戻り値の一覧を示す．Field オブジェクトおよび Fields コレクションは 6.1 には存在せず，廃止されたようである．
| CLASS | Member | Return(2.8) | Return(6.1) |
|---|---|---|---|
| Command | ActiveConnection | Connection | Connection |
| Command | Cancel | Sub | Sub |
| Command | CommandStream | Variant | Variant |
| Command | CommandText | String | String |
| Command | CommandTimeout | Long | Long |
| Command | CommandType | CommandTypeEnum | CommandTypeEnum |
| Command | CreateParameter | Parameter | Parameter |
| Command | Dialect | String | String |
| Command | Execute | Recordset | Recordset |
| Command | Name | String | String |
| Command | NamedParameters | Boolean | Boolean |
| Command | Parameters | Parameters | Parameters |
| Command | Prepared | Boolean | Boolean |
| Command | Properties | Properties | Properties |
| Command | State | Long | Long |
| Connection | Attributes | String | Long |
| Connection | BeginTrans | Long | Long |
| Connection | Cancel | Sub | Sub |
| Connection | Close | Sub | Sub |
| Connection | CommandTimeout | Long | Long |
| Connection | CommitTrans | Sub | Sub |
| Connection | ConnectionString | String | String |
| Connection | ConnectionTimeout | Long | Long |
| Connection | CursorLocation | CursorLocationEnum | CursorLocationEnum |
| Connection | DefaultDatabase | String | String |
| Connection | Errors | Errors | Errors |
| Connection | Execute | Recordset | Recordset |
| Connection | IsolationLevel | IsolationLevelEnum | IsolationLevelEnum |
| Connection | Mode | ConnectModeEnum | ConnectModeEnum |
| Connection | Open | Sub | Sub |
| Connection | OpenSchema | Recordset | Recordset |
| Connection | Properties | Properties | Properties |
| Connection | Provider | String | String |
| Connection | RollbackTrans | Sub | Sub |
| Connection | State | Long | Long |
| Connection | Version | String | String |
| Error | Description | String | String |
| Error | HelpContext | Long | Long |
| Error | HelpFile | String | String |
| Error | NativeError | Long | Long |
| Error | Number | Long | Long |
| Error | Source | String | String |
| Error | SQLState | String | String |
| Errors | Clear | Sub | Sub |
| Errors | Count | Long | Long |
| Errors | Item | Error | Error |
| Errors | Refresh | Sub | Sub |
| Field | ActualSize | ADO_LONGPTR | |
| Field | AppendChunk | Sub | |
| Field | Attributes | Long | |
| Field | DataFormat | Unknown | |
| Field | DefinedSize | ADO_LONGPTR | |
| Field | GetChunk | Function | |
| Field | Name | String | |
| Field | NumericScale | Byte | |
| Field | OriginalValue | Variant | |
| Field | Precision | Byte | |
| Field | Properties | Properties | |
| Field | Status | Long | |
| Field | Type | DataTypeEnum | |
| Field | UnderlyingValue | Variant | |
| Field | Value | Variant | |
| Fields | Append | Sub | |
| Fields | CancelUpdate | Sub | |
| Fields | Count | Long | |
| Fields | Delete | Sub | |
| Fields | Item | Field | |
| Fields | Refresh | Sub | |
| Fields | Resync | Sub | |
| Fields | Update | Sub | |
| Parameter | AppendChunk | Sub | Sub |
| Parameter | Attributes | Long | Long |
| Parameter | Direction | ParameterDirectionEnum | ParameterDirectionEnum |
| Parameter | Name | String | String |
| Parameter | NumericScale | Byte | Byte |
| Parameter | Precision | Byte | Byte |
| Parameter | Properties | Properties | Properties |
| Parameter | Size | ADO_LONGPTR | Long |
| Parameter | Type | DataTypeEnum | DataTypeEnum |
| Parameter | Value | Variant | Variant |
| Parameters | Append | Sub | Sub |
| Parameters | Count | Long | Long |
| Parameters | Delete | Sub | Sub |
| Parameters | Item | Parameter | Parameter |
| Parameters | Refresh | Sub | Sub |
| Properties | Count | Long | Long |
| Properties | Item | Property | Property |
| Properties | Refresh | Sub | Sub |
| Property | Attributes | Long | Long |
| Property | Name | String | String |
| Property | Type | DataTypeEnum | DataTypeEnum |
| Property | Value | Variant | Variant |
| Record | ActiveConnection | Variant | Variant |
| Record | Cancel | Sub | Sub |
| Record | Close | Sub | Sub |
| Record | CopyRecord | String | String |
| Record | DeleteRecord | Sub | Sub |
| Record | Fields | Fields | Fields |
| Record | GetChildren | Recordset | Recordset |
| Record | Mode | ConnectModeEnum | ConnectModeEnum |
| Record | MoveRecord | String | String |
| Record | Open | Sub | Sub |
| Record | ParentURL | String | String |
| Record | Properties | Properties | Properties |
| Record | RecordType | RecordTypeEnum | RecordTypeEnum |
| Record | Source | Variant | Variant |
| Record | State | ObjectStateEnum | ObjectStateEnum |
| Recordset | AbsolutePage | PositionEnum_Param | PositionEnum |
| Recordset | AbsolutePosition | PositionEnum_Param | PositionEnum |
| Recordset | ActiveCommand | Object | Object |
| Recordset | ActiveConnection | Variant | Variant |
| Recordset | AddNew | Sub | Sub |
| Recordset | BOF | Boolean | Boolean |
| Recordset | Bookmark | Variant | Variant |
| Recordset | CacheSize | Long | Long |
| Recordset | Cancel | Sub | Sub |
| Recordset | CancelBatch | Sub | Sub |
| Recordset | CancelUpdate | Sub | Sub |
| Recordset | Clone | Recordset | Recordset |
| Recordset | Close | Sub | Sub |
| Recordset | CompareBookmarks | CompareEnum | CompareEnum |
| Recordset | CursorLocation | CursorLocationEnum | CursorLocationEnum |
| Recordset | CursorType | CursorTypeEnum | CursorTypeEnum |
| Recordset | DataMember | String | String |
| Recordset | DataSource | Unknown | Unknown |
| Recordset | Delete | Sub | Sub |
| Recordset | EditMode | EditModeEnum | EditModeEnum |
| Recordset | EOF | Boolean | Boolean |
| Recordset | Fields | Fields | Fields |
| Recordset | Filter | Variant | Variant |
| Recordset | Find | Sub | Sub |
| Recordset | GetRows | Function | Function |
| Recordset | GetString | String | String |
| Recordset | Index | String | Long |
| Recordset | LockType | LockTypeEnum | LockTypeEnum |
| Recordset | MarshalOptions | MarshalOptionsEnum | MarshalOptionsEnum |
| Recordset | MaxRecords | ADO_LONGPTR | Long |
| Recordset | Move | Sub | Sub |
| Recordset | MoveFirst | Sub | Sub |
| Recordset | MoveLast | Sub | Sub |
| Recordset | MoveNext | Sub | Sub |
| Recordset | MovePrevious | Sub | Sub |
| Recordset | NextRecordset | Recordset | Recordset |
| Recordset | Open | Sub | Sub |
| Recordset | PageCount | ADO_LONGPTR | Long |
| Recordset | PageSize | Long | Long |
| Recordset | Properties | Properties | Properties |
| Recordset | RecordCount | ADO_LONGPTR | Long |
| Recordset | Requery | Sub | Sub |
| Recordset | Resync | Sub | Sub |
| Recordset | Save | Sub | Sub |
| Recordset | Seek | Sub | Sub |
| Recordset | Sort | String | String |
| Recordset | Source | Variant | Variant |
| Recordset | State | Long | Long |
| Recordset | Status | Long | Long |
| Recordset | StayInSync | Boolean | Boolean |
| Recordset | Supports | Boolean | Boolean |
| Recordset | Update | Sub | Sub |
| Recordset | UpdateBatch | Sub | Sub |
| Stream | Cancel | Sub | Sub |
| Stream | Charset | String | String |
| Stream | Close | Sub | Sub |
| Stream | CopyTo | Sub | Sub |
| Stream | EOS | Boolean | Boolean |
| Stream | Flush | Sub | Sub |
| Stream | LineSeparator | LineSeparatorEnum | LineSeparatorEnum |
| Stream | LoadFromFile | Sub | Sub |
| Stream | Mode | ConnectModeEnum | ConnectModeEnum |
| Stream | Open | Sub | Sub |
| Stream | Position | ADO_LONGPTR | Long |
| Stream | Read | Function | Function |
| Stream | ReadText | String | String |
| Stream | SaveToFile | Sub | Sub |
| Stream | SetEOS | Sub | Sub |
| Stream | Size | ADO_LONGPTR | Long |
| Stream | SkipLine | Sub | Sub |
| Stream | State | ObjectStateEnum | ObjectStateEnum |
| Stream | Type | StreamTypeEnum | StreamTypeEnum |
| Stream | Write | Sub | Sub |
| Stream | WriteText | Sub | Sub |
ADODB の ENUM 列挙体
ADODB の列挙体の一覧を示す．バージョンの下の数値は列挙体の定数を示す．空欄は列挙体が存在しないことを示す．
ADCPROP_ASYNCTHREADPRIORITY_ENUM
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adPriorityAboveNormal | 4 | 4 |
| adPriorityBelowNormal | 2 | 2 |
| adPriorityHighest | 5 | 5 |
| adPriorityLowest | 1 | 1 |
| adPriorityNormal | 3 | 3 |
ADCPROP_AUTORECALC_ENUM
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adRecalcAlways | 1 | 1 |
| adRecalcUpFront | 0 | 0 |
ADCPROP_UPDATECRITERIA_ENUM
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCriteriaAllCols | 1 | 1 |
| adCriteriaKey | 0 | 0 |
| adCriteriaTimeStamp | 3 | 3 |
| adCriteriaUpdCols | 2 | 2 |
ADCPROP_UPDATERESYNC_ENUM
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adResyncAll | 15 | 15 |
| adResyncAutoIncrement | 1 | 1 |
| adResyncConflicts | 2 | 2 |
| adResyncInserts | 8 | 8 |
| adResyncNone | 0 | 0 |
| adResyncUpdates | 4 | 4 |
AffectEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adAffectAll | 3 | 3 |
| adAffectAllChapters | 4 | 4 |
| adAffectCurrent | 1 | 1 |
| adAffectGroup | 2 | 2 |
BookmarkEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adBookmarkCurrent | 0 | 0 |
| adBookmarkFirst | 1 | 1 |
| adBookmarkLast | 2 | 2 |
CommandTypeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCmdFile | 256 | 256 |
| adCmdStoredProc | 4 | 4 |
| adCmdTable | 2 | 2 |
| adCmdTableDirect | 512 | 512 |
| adCmdText | 1 | 1 |
| adCmdUnknown | 8 | 8 |
| adCmdUnspecified | -1 |
CompareEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCompareEqual | 1 | 1 |
| adCompareGreaterThan | 2 | 2 |
| adCompareLessThan | 0 | 0 |
| adCompareNotComparable | 4 | 4 |
| adCompareNotEqual | 3 | 3 |
ConnectModeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adModeRead | 1 | 1 |
| adModeReadWrite | 3 | 3 |
| adModeRecursive | 4194304 | 4194304 |
| adModeShareDenyNone | 16 | 16 |
| adModeShareDenyRead | 4 | 4 |
| adModeShareDenyWrite | 8 | 8 |
| adModeShareExclusive | 12 | 12 |
| adModeUnknown | 0 | 0 |
| adModeWrite | 2 | 2 |
ConnectOptionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adAsyncConnect | 16 | 16 |
| adConnectUnspecified | -1 |
ConnectPromptEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adPromptAlways | 1 | 1 |
| adPromptComplete | 2 | 2 |
| adPromptCompleteRequired | 3 | 3 |
| adPromptNever | 4 | 4 |
CopyRecordOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCopyAllowEmulation | 4 | 4 |
| adCopyNonRecursive | 2 | 2 |
| adCopyOverWrite | 1 | 1 |
| adCopyUnspecified | -1 | -1 |
CursorLocationEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adUseClient | 3 | 3 |
| adUseClientBatch | 3 | |
| adUseNone | 1 | |
| adUseServer | 2 | 2 |
CursorOptionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adAddNew | 16778240 | 16778240 |
| adApproxPosition | 16384 | 16384 |
| adBookmark | 8192 | 8192 |
| adDelete | 16779264 | 16779264 |
| adFind | 524288 | 524288 |
| adHoldRecords | 256 | 256 |
| adIndex | 8388608 | 8388608 |
| adMovePrevious | 512 | 512 |
| adNotify | 262144 | 262144 |
| adResync | 131072 | 131072 |
| adSeek | 4194304 | 4194304 |
| adUpdate | 16809984 | 16809984 |
| adUpdateBatch | 65536 | 65536 |
CursorTypeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adOpenDynamic | 2 | 2 |
| adOpenForwardOnly | 0 | 0 |
| adOpenKeyset | 1 | 1 |
| adOpenStatic | 3 | 3 |
| adOpenUnspecified | -1 |
DataTypeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adArray | 8192 | 8192 |
| adBigInt | 20 | 20 |
| adBinary | 128 | 128 |
| adBoolean | 11 | 11 |
| adBSTR | 8 | 8 |
| adChapter | 136 | 136 |
| adChar | 129 | 129 |
| adCurrency | 6 | 6 |
| adDate | 7 | 7 |
| adDBDate | 133 | 133 |
| adDBTime | 134 | 134 |
| adDBTimeStamp | 135 | 135 |
| adDecimal | 14 | 14 |
| adDouble | 5 | 5 |
| adEmpty | 0 | 0 |
| adError | 10 | 10 |
| adFileTime | 64 | 64 |
| adGUID | 72 | 72 |
| adIDispatch | 9 | 9 |
| adInteger | 3 | 3 |
| adIUnknown | 13 | 13 |
| adLongVarBinary | 205 | 205 |
| adLongVarChar | 201 | 201 |
| adLongVarWChar | 203 | 203 |
| adNumeric | 131 | 131 |
| adPropVariant | 138 | 138 |
| adSingle | 4 | 4 |
| adSmallInt | 2 | 2 |
| adTinyInt | 16 | 16 |
| adUnsignedBigInt | 21 | 21 |
| adUnsignedInt | 19 | 19 |
| adUnsignedSmallInt | 18 | 18 |
| adUnsignedTinyInt | 17 | 17 |
| adUserDefined | 132 | 132 |
| adVarBinary | 204 | 204 |
| adVarChar | 200 | 200 |
| adVariant | 12 | 12 |
| adVarNumeric | 139 | 139 |
| adVarWChar | 202 | 202 |
| adWChar | 130 | 130 |
EditModeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adEditAdd | 2 | 2 |
| adEditDelete | 4 | 4 |
| adEditInProgress | 1 | 1 |
| adEditNone | 0 | 0 |
| adErrNotExecuting | 3715 |
ErrorValueEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adErrBoundToCommand | 3707 | 3707 |
| adErrCannotComplete | 3732 | 3732 |
| adErrCantChangeConnection | 3748 | 3748 |
| adErrCantChangeProvider | 3220 | 3220 |
| adErrCantConvertvalue | 3724 | 3724 |
| adErrCantCreate | 3725 | 3725 |
| adErrCatalogNotSet | 3747 | 3747 |
| adErrColumnNotOnThisRow | 3726 | 3726 |
| adErrConnectionStringTooLong | 3754 | 3754 |
| adErrDataConversion | 3421 | 3421 |
| adErrDataOverflow | 3721 | 3721 |
| adErrDelResOutOfScope | 3738 | 3738 |
| adErrDenyNotSupported | 3750 | 3750 |
| adErrDenyTypeNotSupported | 3751 | 3751 |
| adErrFeatureNotAvailable | 3251 | 3251 |
| adErrFieldsUpdateFailed | 3749 | 3749 |
| adErrIllegalOperation | 3219 | 3219 |
| adErrIntegrityViolation | 3719 | 3719 |
| adErrInTransaction | 3246 | 3246 |
| adErrInvalidArgument | 3001 | 3001 |
| adErrInvalidConnection | 3709 | 3709 |
| adErrInvalidParamInfo | 3708 | 3708 |
| adErrInvalidTransaction | 3714 | 3714 |
| adErrInvalidURL | 3729 | 3729 |
| adErrItemNotFound | 3265 | 3265 |
| adErrNoCurrentRecord | 3021 | 3021 |
| adErrNotExecuting | 3715 | |
| adErrNotReentrant | 3710 | 3710 |
| adErrObjectClosed | 3704 | 3704 |
| adErrObjectInCollection | 3367 | 3367 |
| adErrObjectNotSet | 3420 | 3420 |
| adErrObjectOpen | 3705 | 3705 |
| adErrOpeningFile | 3002 | 3002 |
| adErrOperationCancelled | 3712 | 3712 |
| adErrOutOfSpace | 3734 | 3734 |
| adErrPermissionDenied | 3720 | 3720 |
| adErrPropConflicting | 3742 | 3742 |
| adErrPropInvalidColumn | 3739 | 3739 |
| adErrPropInvalidOption | 3740 | 3740 |
| adErrPropInvalidValue | 3741 | 3741 |
| adErrPropNotAllSettable | 3743 | 3743 |
| adErrPropNotSet | 3744 | 3744 |
| adErrPropNotSettable | 3745 | 3745 |
| adErrPropNotSupported | 3746 | 3746 |
| adErrProviderFailed | 3000 | 3000 |
| adErrProviderNotFound | 3706 | 3706 |
| adErrProviderNotSpecified | 3753 | 3753 |
| adErrReadFile | 3003 | 3003 |
| adErrResourceExists | 3731 | 3731 |
| adErrResourceLocked | 3730 | 3730 |
| adErrResourceOutOfScope | 3735 | 3735 |
| adErrSchemaViolation | 3722 | 3722 |
| adErrSignMismatch | 3723 | 3723 |
| adErrStillConnecting | 3713 | 3713 |
| adErrStillExecuting | 3711 | 3711 |
| adErrTreePermissionDenied | 3728 | 3728 |
| adErrUnavailable | 3736 | 3736 |
| adErrUnsafeOperation | 3716 | 3716 |
| adErrURLDoesNotExist | 3727 | 3727 |
| adErrURLNamedRowDoesNotExist | 3737 | 3737 |
| adErrVolumeNotFound | 3733 | 3733 |
| adErrWriteFile | 3004 | 3004 |
| adwrnSecurityDialog | 3717 | 3717 |
| adwrnSecurityDialogHeader | 3718 | 3718 |
EventReasonEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adRsnAddNew | 1 | 1 |
| adRsnClose | 9 | 9 |
| adRsnDelete | 2 | 2 |
| adRsnFirstChange | 11 | 11 |
| adRsnMove | 10 | 10 |
| adRsnMoveFirst | 12 | 12 |
| adRsnMoveLast | 15 | 15 |
| adRsnMoveNext | 13 | 13 |
| adRsnMovePrevious | 14 | 14 |
| adRsnRequery | 7 | 7 |
| adRsnResynch | 8 | 8 |
| adRsnUndoAddNew | 5 | 5 |
| adRsnUndoDelete | 6 | 6 |
| adRsnUndoUpdate | 4 | 4 |
| adRsnUpdate | 3 | 3 |
EventStatusEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adStatusCancel | 4 | 4 |
| adStatusCantDeny | 3 | 3 |
| adStatusErrorsOccurred | 2 | 2 |
| adStatusOK | 1 | 1 |
| adStatusUnwantedEvent | 5 | 5 |
ExecuteOptionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adAsyncExecute | 16 | 16 |
| adAsyncFetch | 32 | 32 |
| adAsyncFetchNonBlocking | 64 | 64 |
| adExecuteNoRecords | 128 | 128 |
| adExecuteRecord | 2048 | 2048 |
| adExecuteStream | 1024 | 1024 |
| adOptionUnspecified | -1 | -1 |
FieldAttributeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adFldCacheDeferred | 4096 | 4096 |
| adFldFixed | 16 | 16 |
| adFldIsChapter | 8192 | 8192 |
| adFldIsCollection | 262144 | 262144 |
| adFldIsDefaultStream | 131072 | 131072 |
| adFldIsNullable | 32 | 32 |
| adFldIsRowURL | 65536 | 65536 |
| adFldKeyColumn | 32768 | 32768 |
| adFldLong | 128 | 128 |
| adFldMayBeNull | 64 | 64 |
| adFldMayDefer | 2 | 2 |
| adFldNegativeScale | 16384 | 16384 |
| adFldRowID | 256 | 256 |
| adFldRowVersion | 512 | 512 |
| adFldUnknownUpdatable | 8 | 8 |
| adFldUnspecified | -1 | -1 |
| adFldUpdatable | 4 | 4 |
FieldEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adDefaultStream | -1 | -1 |
| adRecordURL | -2 | -2 |
FieldStatusEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adFieldAlreadyExists | 26 | 26 |
| adFieldBadStatus | 12 | 12 |
| adFieldCannotComplete | 20 | 20 |
| adFieldCannotDeleteSource | 23 | 23 |
| adFieldCantConvertValue | 2 | 2 |
| adFieldCantCreate | 7 | 7 |
| adFieldDataOverflow | 6 | 6 |
| adFieldDefault | 13 | 13 |
| adFieldDoesNotExist | 16 | 16 |
| adFieldIgnore | 15 | 15 |
| adFieldIntegrityViolation | 10 | 10 |
| adFieldInvalidURL | 17 | 17 |
| adFieldIsNull | 3 | 3 |
| adFieldOK | 0 | 0 |
| adFieldOutOfSpace | 22 | 22 |
| adFieldPendingChange | 262144 | 262144 |
| adFieldPendingDelete | 131072 | 131072 |
| adFieldPendingInsert | 65536 | 65536 |
| adFieldPendingUnknown | 524288 | 524288 |
| adFieldPendingUnknownDelete | 1048576 | 1048576 |
| adFieldPermissionDenied | 9 | 9 |
| adFieldReadOnly | 24 | 24 |
| adFieldResourceExists | 19 | 19 |
| adFieldResourceLocked | 18 | 18 |
| adFieldResourceOutOfScope | 25 | 25 |
| adFieldSchemaViolation | 11 | 11 |
| adFieldSignMismatch | 5 | 5 |
| adFieldTruncated | 4 | 4 |
| adFieldUnavailable | 8 | 8 |
| adFieldVolumeNotFound | 21 | 21 |
FilterGroupEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adFilterAffectedRecords | 2 | 2 |
| adFilterConflictingRecords | 5 | 5 |
| adFilterFetchedRecords | 3 | 3 |
| adFilterNone | 0 | 0 |
| adFilterPendingRecords | 1 | 1 |
| adFilterPredicate | 4 | 4 |
GetRowsOptionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adGetRowsRest | -1 | -1 |
IsolationLevelEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adXactBrowse | 256 | 256 |
| adXactChaos | 16 | 16 |
| adXactCursorStability | 4096 | 4096 |
| adXactIsolated | 1048576 | 1048576 |
| adXactReadCommitted | 4096 | 4096 |
| adXactReadUncommitted | 256 | 256 |
| adXactRepeatableRead | 65536 | 65536 |
| adXactSerializable | 1048576 | 1048576 |
| adXactUnspecified | -1 | -1 |
LineSeparatorEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCR | 13 | 13 |
| adCRLF | -1 | -1 |
| adLF | 10 | 10 |
LockTypeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adLockBatchOptimistic | 4 | 4 |
| adLockOptimistic | 3 | 3 |
| adLockPessimistic | 2 | 2 |
| adLockReadOnly | 1 | 1 |
| adLockUnspecified | -1 | -1 |
MarshalOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adMarshalAll | 0 | 0 |
| adMarshalModifiedOnly | 1 | 1 |
MoveRecordOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adMoveAllowEmulation | 4 | 4 |
| adMoveDontUpdateLinks | 2 | 2 |
| adMoveOverWrite | 1 | 1 |
| adMoveUnspecified | -1 | -1 |
ObjectStateEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adStateClosed | 0 | 0 |
| adStateConnecting | 2 | 2 |
| adStateExecuting | 4 | 4 |
| adStateFetching | 8 | 8 |
| adStateOpen | 1 | 1 |
ParameterAttributesEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adParamLong | 128 | 128 |
| adParamNullable | 64 | 64 |
| adParamSigned | 16 | 16 |
ParameterDirectionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adParamInput | 1 | 1 |
| adParamInputOutput | 3 | 3 |
| adParamOutput | 2 | 2 |
| adParamReturnValue | 4 | 4 |
| adParamUnknown | 0 | 0 |
PersistFormatEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adPersistADTG | 0 | 0 |
| adPersistXML | 1 | 1 |
PositionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adPosBOF | -2 | -2 |
| adPosEOF | -3 | -3 |
| adPosUnknown | -1 | -1 |
PropertyAttributesEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adPropNotSupported | 0 | 0 |
| adPropOptional | 2 | 2 |
| adPropRead | 512 | 512 |
| adPropRequired | 1 | 1 |
| adPropWrite | 1024 | 1024 |
RecordCreateOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCreateCollection | 8192 | 8192 |
| adCreateNonCollection | 0 | 0 |
| adCreateOverwrite | 67108864 | 67108864 |
| adCreateStructDoc | -2147483648 | -2147483648 |
| adFailIfNotExists | -1 | -1 |
| adOpenIfExists | 33554432 | 33554432 |
RecordOpenOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adDelayFetchFields | 32768 | 32768 |
| adDelayFetchStream | 16384 | 16384 |
| adOpenAsync | 4096 | 4096 |
| adOpenExecuteCommand | 65536 | 65536 |
| adOpenOutput | 8388608 | 8388608 |
| adOpenRecordUnspecified | -1 | -1 |
| adOpenSource | 8388608 | 8388608 |
RecordStatusEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adRecCanceled | 256 | 256 |
| adRecCantRelease | 1024 | 1024 |
| adRecConcurrencyViolation | 2048 | 2048 |
| adRecDBDeleted | 262144 | 262144 |
| adRecDeleted | 4 | 4 |
| adRecIntegrityViolation | 4096 | 4096 |
| adRecInvalid | 16 | 16 |
| adRecMaxChangesExceeded | 8192 | 8192 |
| adRecModified | 2 | 2 |
| adRecMultipleChanges | 64 | 64 |
| adRecNew | 1 | 1 |
| adRecObjectOpen | 16384 | 16384 |
| adRecOK | 0 | 0 |
| adRecOutOfMemory | 32768 | 32768 |
| adRecPendingChanges | 128 | 128 |
| adRecPermissionDenied | 65536 | 65536 |
| adRecSchemaViolation | 131072 | 131072 |
| adRecUnmodified | 8 | 8 |
RecordTypeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adCollectionRecord | 1 | 1 |
| adSimpleRecord | 0 | 0 |
| adStructDoc | 2 | 2 |
ResyncEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adResyncAllValues | 2 | 2 |
| adResyncUnderlyingValues | 1 | 1 |
SaveOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adSaveCreateNotExist | 1 | 1 |
| adSaveCreateOverWrite | 2 | 2 |
SchemaEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adSchemaActions | 41 | 41 |
| adSchemaAsserts | 0 | 0 |
| adSchemaCatalogs | 1 | 1 |
| adSchemaCharacterSets | 2 | 2 |
| adSchemaCheckConstraints | 5 | 5 |
| adSchemaCollations | 3 | 3 |
| adSchemaColumnPrivileges | 13 | 13 |
| adSchemaColumns | 4 | 4 |
| adSchemaColumnsDomainUsage | 11 | 11 |
| adSchemaCommands | 42 | 42 |
| adSchemaConstraintColumnUsage | 6 | 6 |
| adSchemaConstraintTableUsage | 7 | 7 |
| adSchemaCubes | 32 | 32 |
| adSchemaDBInfoKeywords | 30 | 30 |
| adSchemaDBInfoLiterals | 31 | 31 |
| adSchemaDimensions | 33 | 33 |
| adSchemaForeignKeys | 27 | 27 |
| adSchemaFunctions | 40 | 40 |
| adSchemaHierarchies | 34 | 34 |
| adSchemaIndexes | 12 | 12 |
| adSchemaKeyColumnUsage | 8 | 8 |
| adSchemaLevels | 35 | 35 |
| adSchemaMeasures | 36 | 36 |
| adSchemaMembers | 38 | 38 |
| adSchemaPrimaryKeys | 28 | 28 |
| adSchemaProcedureColumns | 29 | 29 |
| adSchemaProcedureParameters | 26 | 26 |
| adSchemaProcedures | 16 | 16 |
| adSchemaProperties | 37 | 37 |
| adSchemaProviderSpecific | -1 | -1 |
| adSchemaProviderTypes | 22 | 22 |
| adSchemaReferentialConstraints | 9 | 9 |
| adSchemaReferentialContraints | 9 | 9 |
| adSchemaSchemata | 17 | 17 |
| adSchemaSets | 43 | 43 |
| adSchemaSQLLanguages | 18 | 18 |
| adSchemaStatistics | 19 | 19 |
| adSchemaTableConstraints | 10 | 10 |
| adSchemaTablePrivileges | 14 | 14 |
| adSchemaTables | 20 | 20 |
| adSchemaTranslations | 21 | 21 |
| adSchemaTrustees | 39 | 39 |
| adSchemaUsagePrivileges | 15 | 15 |
| adSchemaViewColumnUsage | 24 | 24 |
| adSchemaViews | 23 | 23 |
| adSchemaViewTableUsage | 25 | 25 |
SearchDirection
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adSearchBackward | -1 | |
| adSearchForward | 1 |
SearchDirectionEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adSearchBackward | -1 | -1 |
| adSearchForward | 1 | 1 |
SeekEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adSeekAfter | 8 | 8 |
| adSeekAfterEQ | 4 | 4 |
| adSeekBefore | 32 | 32 |
| adSeekBeforeEQ | 16 | 16 |
| adSeekFirstEQ | 1 | 1 |
| adSeekLastEQ | 2 | 2 |
StreamOpenOptionsEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adOpenStreamAsync | 1 | 1 |
| adOpenStreamFromRecord | 4 | 4 |
| adOpenStreamUnspecified | -1 | -1 |
StreamReadEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adReadAll | -1 | -1 |
| adReadLine | -2 | -2 |
StreamTypeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adTypeBinary | 1 | 1 |
| adTypeText | 2 | 2 |
StreamWriteEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adWriteChar | 0 | 0 |
| adWriteLine | 1 | 1 |
| stWriteChar | 0 | 0 |
| stWriteLine | 1 | 1 |
StringFormatEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adClipString | 2 | 2 |
XactAttributeEnum
| Microsoft ActiveX DataObjects X.X Library | 2.8 | 6.1 |
|---|---|---|
| adXactAbortRetaining | 262144 | 262144 |
| adXactAsyncPhaseOne | 524288 | 524288 |
| adXactCommitRetaining | 131072 | 131072 |
| adXactSyncPhaseOne | 1048576 | 1048576 |