Menü

VBScript-ADO-Konstanten

Zurück | Ebene zurück

Nachfolgend sind die wichtigsten ADO (ActiveX Data Objects) Konstanten als VBScript-Deklaration aufgeführt. Alle Angaben ohne Gewähr.


' Cursor Type
const adOpenUnspecified = &HFFFFFFFF
const adOpenForwardOnly = 0
const adOpenKeyset = 1
const adOpenDynamic = 2
const adOpenStatic = 3

' Cursor Options
const adHoldRecords = &H00000100
const adMovePrevious = &H00000200
const adAddNew = &H01000400
const adDelete = &H01000800
const adUpdate = &H01008000
const adBookmark = &H00002000
const adApproxPosition = &H00004000
const adUpdateBatch = &H00010000
const adResync = &H00020000
const adNotify = &H00040000
const adFind = &H00080000
const adSeek = &H00400000
const adIndex = &H00800000



' LockTypeEnum constants
const adLockUnspecified = &HFFFFFFFF
const adLockReadOnly = &H00000001
const adLockPessimistic = &H00000002
const adLockOptimistic = &H00000003
const adLockBatchOptimistic = &H00000004

' ************************************************ 
' ExecuteOptionEnum constants
' Konstanten für die Command.Execute Methode  
' ************************************************ 
const adOptionUnspecified = &HFFFFFFFF
const adAsyncExecute = &H00000010
const adAsyncFetch = &H00000020
const adAsyncFetchNonBlocking = &H00000040
' wenn kein Recordset als Rückgabe erwartet 
' wird, sollte unbedingt diese Option 
' angegeben werden, da sich die die 
' Ausführungsgeschwindigkeit des Befehls 
' hierdurch merkbar beschleunigt
const adExecuteNoRecords = &H00000080

' ConnectOptionEnum constants
const adConnectUnspecified = &HFFFFFFFF
const adAsyncConnect = &H00000010

' ObjectStateEnum constants
const adStateClosed = &H00000000
const adStateOpen = &H00000001
const adStateConnecting = &H00000002
const adStateExecuting = &H00000004
const adStateFetching = &H00000008

' CursorLocationEnum constants
const adUseNone = &H00000001
const adUseServer = &H00000002
const adUseClient = &H00000003
const adUseClientBatch = &H00000003

' DataTypeEnum constants
const adEmpty = &H00000000
const adTinyInt = &H00000010
const adSmallInt = &H00000002
const adInteger = &H00000003
const adBigInt = &H00000014
const adUnsignedTinyInt = &H00000011
const adUnsignedSmallInt = &H00000012
const adUnsignedInt = &H00000013
const adUnsignedBigInt = &H00000015
const adSingle = &H00000004
const adDouble = &H00000005
const adCurrency = &H00000006
const adDecimal = &H0000000E
const adNumeric = &H00000083
const adBoolean = &H0000000B
const adError = &H0000000A
const adUserDefined = &H00000084
const adVariant = &H0000000C
const adIDispatch = &H00000009
const adIUnknown = &H0000000D
const adGUID = &H00000048
const adDate = &H00000007
const adDBDate = &H00000085
const adDBTime = &H00000086
const adDBTimeStamp = &H00000087
const adBSTR = &H00000008
const adChar = &H00000081
const adVarChar = &H000000C8
const adLongVarChar = &H000000C9
const adWChar = &H00000082
const adVarWChar = &H000000CA
const adLongVarWChar = &H000000CB
const adBinary = &H00000080
const adVarBinary = &H000000CC
const adLongVarBinary = &H000000CD
const adChapter = &H00000088
const adFileTime = &H00000040
const adDBFileTime = &H00000089
const adPropVariant = &H0000008A
const adVarNumeric = &H0000008B

' FieldAttributeEnum constants
const adFldUnspecified = &HFFFFFFFF
const adFldMayDefer = &H00000002
const adFldUpdatable = &H00000004
const adFldUnknownUpdatable = &H00000008
const adFldFixed = &H00000010
const adFldIsNullable = &H00000020
const adFldMayBeNull = &H00000040
const adFldLong = &H00000080
const adFldRowID = &H00000100
const adFldRowVersion = &H00000200
const adFldCacheDeferred = &H00001000
const adFldNegativeScale = &H00004000
const adFldKeyColumn = &H00008000

' EditModeEnum constants
const adEditNone = &H00000000
const adEditInProgress = &H00000001
const adEditAdd = &H00000002
const adEditDelete = &H00000004

' RecordStatusEnum constants
const adRecOK = &H00000000
const adRecNew = &H00000001
const adRecModified = &H00000002
const adRecDeleted = &H00000004
const adRecUnmodified = &H00000008
const adRecInvalid = &H00000010
const adRecMultipleChanges = &H00000040
const adRecPendingChanges = &H00000080
const adRecCanceled = &H00000100
const adRecCantRelease = &H00000400
const adRecConcurrencyViolation = &H00000800
const adRecIntegrityViolation = &H00001000
const adRecMaxChangesExceeded = &H00002000
const adRecObjectOpen = &H00004000
const adRecOutOfMemory = &H00008000
const adRecPermissionDenied = &H00010000
const adRecSchemaViolation = &H00020000
const adRecDBDeleted = &H00040000

' GetRowsOptionEnum constants
const adGetRowsRest = &HFFFFFFFF

' PositionEnum constants
const adPosUnknown = &HFFFFFFFF
const adPosBOF = &HFFFFFFFE
const adPosEOF = &HFFFFFFFD

' BookmarkEnum constants
const adBookmarkCurrent = &H00000000
const adBookmarkFirst = &H00000001
const adBookmarkLast = &H00000002

' MarshalOptionsEnum constants
const adMarshalAll = &H00000000
const adMarshalModifiedOnly = &H00000001

' AffectEnum constants
const adAffectCurrent = &H00000001
const adAffectGroup = &H00000002
const adAffectAll = &H00000003
const adAffectAllChapters = &H00000004

' ResyncEnum constants
const adResyncUnderlyingValues = &H00000001
const adResyncAllValues = &H00000002

' CompareEnum constants
const adCompareLessThan = &H00000000
const adCompareEqual = &H00000001
const adCompareGreaterThan = &H00000002
const adCompareNotEqual = &H00000003
const adCompareNotComparable = &H00000004

' FilterGroupEnum constants
const adFilterNone = &H00000000
const adFilterPendingRecords = &H00000001
const adFilterAffectedRecords = &H00000002
const adFilterFetchedRecords = &H00000003
const adFilterPredicate = &H00000004
const adFilterConflictingRecords = &H00000005

' SearchDirectionEnum constants
const adSearchForward = &H00000001
const adSearchBackward = &HFFFFFFFF

' PersistFormatEnum constants
const adPersistADTG = &H00000000
const adPersistXML = &H00000001

' StringFormatEnum constants
const adClipString = &H00000002

' ConnectPromptEnum constants
const adPromptAlways = &H00000001
const adPromptComplete = &H00000002
const adPromptCompleteRequired = &H00000003
const adPromptNever = &H00000004

' ConnectModeEnum constants
const adModeUnknown = &H00000000
const adModeRead = &H00000001
const adModeWrite = &H00000002
const adModeReadWrite = &H00000003
const adModeShareDenyRead = &H00000004
const adModeShareDenyWrite = &H00000008
const adModeShareExclusive = &H0000000C
const adModeShareDenyNone = &H00000010

' IsolationLevelEnum constants
const adXactUnspecified = &HFFFFFFFF
const adXactChaos = &H00000010
const adXactReadUncommitted = &H00000100
const adXactBrowse = &H00000100
const adXactCursorStability = &H00001000
const adXactReadCommitted = &H00001000
const adXactRepeatableRead = &H00010000
const adXactSerializable = &H00100000
const adXactIsolated = &H00100000

' XactAttributeEnum constants
const adXactCommitRetaining = &H00020000
const adXactAbortRetaining = &H00040000
const adXactAsyncPhaseOne = &H00080000
const adXactSyncPhaseOne = &H00100000

' PropertyAttributesEnum constants
const adPropNotSupported = &H00000000
const adPropRequired = &H00000001
const adPropOptional = &H00000002
const adPropRead = &H00000200
const adPropWrite = &H00000400

' ErrorValueEnum constants
const adErrInvalidArgument = &H00000BB9
const adErrNoCurrentRecord = &H00000BCD
const adErrIllegalOperation = &H00000C93
const adErrInTransaction = &H00000CAE
const adErrFeatureNotAvailable = &H00000CB3
const adErrItemNotFound = &H00000CC1
const adErrObjectInCollection = &H00000D27
const adErrObjectNotSet = &H00000D5C
const adErrDataConversion = &H00000D5D
const adErrObjectClosed = &H00000E78
const adErrObjectOpen = &H00000E79
const adErrProviderNotFound = &H00000E7A
const adErrBoundToCommand = &H00000E7B
const adErrInvalidParamInfo = &H00000E7C
const adErrInvalidConnection = &H00000E7D
const adErrNotReentrant = &H00000E7E
const adErrStillExecuting = &H00000E7F
const adErrOperationCancelled = &H00000E80
const adErrStillConnecting = &H00000E81
const adErrNotExecuting = &H00000E83
const adErrUnsafeOperation = &H00000E84

' ParameterAttributesEnum constants
const adParamSigned = &H00000010
const adParamNullable = &H00000040
const adParamLong = &H00000080

' ParameterDirectionEnum constants
const adParamUnknown = &H00000000
const adParamInput = &H00000001
const adParamOutput = &H00000002
const adParamInputOutput = &H00000003
const adParamReturnValue = &H00000004

' CommandTypeEnum constants
const adCmdUnspecified = &HFFFFFFFF
const adCmdUnknown = &H00000008
const adCmdText = &H00000001
const adCmdTable = &H00000002
const adCmdStoredProc = &H00000004
const adCmdFile = &H00000100
const adCmdTableDirect = &H00000200

' EventStatusEnum constants
const adStatusOK = &H00000001
const adStatusErrorsOccurred = &H00000002
const adStatusCantDeny = &H00000003
const adStatusCancel = &H00000004
const adStatusUnwantedEvent = &H00000005

' EventReasonEnum constants
const adRsnAddNew = &H00000001
const adRsnDelete = &H00000002
const adRsnUpdate = &H00000003
const adRsnUndoUpdate = &H00000004
const adRsnUndoAddNew = &H00000005
const adRsnUndoDelete = &H00000006
const adRsnRequery = &H00000007
const adRsnResynch = &H00000008
const adRsnClose = &H00000009
const adRsnMove = &H0000000A
const adRsnFirstChange = &H0000000B
const adRsnMoveFirst = &H0000000C
const adRsnMoveNext = &H0000000D
const adRsnMovePrevious = &H0000000E
const adRsnMoveLast = &H0000000F



' SchemaEnum constants
const adSchemaProviderSpecific = &HFFFFFFFF
const adSchemaAsserts = &H00000000
const adSchemaCatalogs = &H00000001
const adSchemaCharacterSets = &H00000002
const adSchemaCollations = &H00000003
const adSchemaColumns = &H00000004
const adSchemaCheckConstraints = &H00000005
const adSchemaConstraintColumnUsage = &H00000006
const adSchemaConstraintTableUsage = &H00000007
const adSchemaKeyColumnUsage = &H00000008
const adSchemaReferentialConstraints = &H00000009
const adSchemaTableConstraints = &H0000000A
const adSchemaColumnsDomainUsage = &H0000000B
const adSchemaIndexes = &H0000000C
const adSchemaColumnPrivileges = &H0000000D
const adSchemaTablePrivileges = &H0000000E
const adSchemaUsagePrivileges = &H0000000F
const adSchemaProcedures = &H00000010
const adSchemaSchemata = &H00000011
const adSchemaSQLLanguages = &H00000012
const adSchemaStatistics = &H00000013
const adSchemaTables = &H00000014
const adSchemaTranslations = &H00000015
const adSchemaProviderTypes = &H00000016
const adSchemaViews = &H00000017
const adSchemaViewColumnUsage = &H00000018
const adSchemaViewTableUsage = &H00000019
const adSchemaProcedureParameters = &H0000001A
const adSchemaForeignKeys = &H0000001B
const adSchemaPrimaryKeys = &H0000001C
const adSchemaProcedureColumns = &H0000001D
const adSchemaDBInfoKeywords = &H0000001E
const adSchemaDBInfoLiterals = &H0000001F
const adSchemaCubes = &H00000020
const adSchemaDimensions = &H00000021
const adSchemaHierarchies = &H00000022
const adSchemaLevels = &H00000023
const adSchemaMeasures = &H00000024
const adSchemaProperties = &H00000025
const adSchemaMembers = &H00000026
const adSchemaTrustees = &H00000027

' SeekEnum constants
const adSeekFirstEQ = &H00000001
const adSeekLastEQ = &H00000002
const adSeekAfterEQ = &H00000004
const adSeekAfter = &H00000008
const adSeekBeforeEQ = &H00000010
const adSeekBefore = &H00000020

' ADCPROP_UPDATECRITERIA_ENUM constants
const adCriteriaKey = &H00000000
const adCriteriaAllCols = &H00000001
const adCriteriaUpdCols = &H00000002
const adCriteriaTimeStamp = &H00000003

' ADCPROP_ASYNCTHREADPRIORITY_ENUM constants
const adPriorityLowest = &H00000001
const adPriorityBelowNormal = &H00000002
const adPriorityNormal = &H00000003
const adPriorityAboveNormal = &H00000004
const adPriorityHighest = &H00000005

' CEResyncEnum constants
const adResyncNone = &H00000000
const adResyncAutoIncrement = &H00000001
const adResyncConflicts = &H00000002
const adResyncUpdates = &H00000004
const adResyncInserts = &H00000008
const adResyncAll = &H0000000F

' ADCPROP_AUTORECALC_ENUM constants
const adRecalcUpFront = &H00000000
const adRecalcAlways = &H00000001