<% '----------------------------------------------- -------------------- "Microsoft Ado '' Copyright (C) 1996-1998 Microsoft Corporation. '' 'Ado Constants include file for vbscript' -------------------------------------------------- ---------------- '---- CURSORTYPEENUM VALUES ---- Const AdopenForwardonly = 0const AdopenKeyset = 1Const AdoPENDYNAMIC = 2const AdopenStatic = 3' ---- CursorOptionENum VALUES --- -Const adHoldRecords = & H00000100Const adMovePrevious = & H00000200Const adAddNew = & H01000400Const adDelete = & H01000800Const adUpdate = & H01008000Const adBookmark = & H00002000Const adApproxPosition = & H00004000Const adUpdateBatch = & H00010000Const adResync = & H00020000Const adNotify = & H00040000Const adFind = & H00080000Const adSeek = & H00400000Const adIndex = & H00800000 '---- LockTypeEnum Values - --Const adLockPessimistic = 2const AdlockOptimistic = 3const AdlockBatchOptiMistic = 4 '---- ExecuteOptionNum Values ---- Const Adasyncexecute = & H00000010const Ada syncFetch = & H00000020Const adAsyncFetchNonBlocking = & H00000040Const adExecuteNoRecords = & H00000080Const adExecuteStream = & H00000400 '---- ConnectOptionEnum Values ---- Const adAsyncConnect = & H00000010' ---- ObjectStateEnum Values ---- Const adStateClosed = & H00000000Const adStateOpen = & H00000001Const adStateConnecting = & H00000002Const adStateExecuting = & H00000004const adstatefetching = & h00000008 '
---- CursorLocationEnum Values ---- Const adUseServer = 2Const adUseClient = 3 '---- DataTypeEnum Values ---- Const adEmpty = 0Const adTinyInt = 16Const adSmallInt = 2Const adInteger = 3Const adBigInt = 20Const adUnsignedTinyInt = 17Const adUnsignedSmallInt = 18Const adUnsignedInt = 19Const adUnsignedBigInt = 21Const adSingle = 4Const adDouble = 5Const adCurrency = 6Const adDecimal = 14Const adNumeric = 131Const adBoolean = 11Const adError = 10Const adUserDefined = 132Const adVariant = 12Const adIDispatch = 9Const adIUnknown = 13Const adGUID = 72Const adDate = 7Const adDBDate = 133Const adDBTime = 134Const adDBTimeStamp = 135Const adBSTR = 8Const adChar = 129Const adVarChar = 200Const adLongVarChar = 201Const adWChar = 130Const adVarWChar = 202Const adLongVarWChar = 203Const adBinary = 128Const adVarBinary = 204Const adLongVarBinary = 205Const adChapter = 136Const adFileTime = 64Const adPropVariant = 138Const adVarNumeric = 139Const adArray = & H2000 ' ---- FieldattributeEnum VALUES ---- Co nst adFldMayDefer = & H00000002Const adFldUpdatable = & H00000004Const adFldUnknownUpdatable = & H00000008Const adFldFixed = & H00000010Const adFldIsNullable = & H00000020Const adFldMayBeNull = & H00000040Const adFldLong = & H00000080Const adFldRowID = & H00000100Const adFldRowVersion = & H00000200Const adFldCacheDeferred = & H00001000Const adFldIsChapter = & H00002000Const adFldNegativeScale = & H00004000Const adFldKeyColumn = & H00008000Const adFldIsRowURL = &
H00010000Const adFldIsDefaultStream = & H00020000Const adFldIsCollection = & H00040000 '---- EditModeEnum Values ---- Const adEditNone = & H0000Const adEditInProgress = & H0001Const adEditAdd = & H0002Const adEditDelete = & H0004' ---- RecordStatusEnum Values ---- Const adRecOK = & H0000000Const adRecNew = & H0000001Const adRecModified = & H0000002Const adRecDeleted = & H0000004Const adRecUnmodified = & H0000008Const adRecInvalid = & H0000010Const adRecMultipleChanges = & H0000040Const adRecPendingChanges = & H0000080Const adRecCanceled = & H0000100Const adRecCantRelease = & H0000400Const adRecConcurrencyViolation = & H0000800Const adRecIntegrityViolation = & H0001000Const adRecMaxChangesExceeded = & H0002000Const adRecObjectOpen = & H0004000Const adRecOutOfMemory = & H0008000Const adRecPermissionDenied = & H0010000Const adRecSchemaViolation = & H0020000Const adRecDBDeleted = & H0040000 '- - GetRowSOptionNum Values ---- Const AdgetrowSrest = -1 '---- Positionenum VALUES ---- Const Adposunknown = -1Const Adposbo F = -2Const adPosEOF = -3 '---- BookmarkEnum Values ---- Const adBookmarkCurrent = 0Const adBookmarkFirst = 1Const adBookmarkLast = 2' ---- MarshalOptionsEnum Values ---- Const adMarshalAll = 0Const adMarshalModifiedOnly = 1 '- - Affectenum Values ---- Const AdaffectCurrent = 1Const AdaffectGroup = 2const AdaffectAllchapters = 4 '---- RESYNCENUM VALUES ---- Const AdResyncunderlyingValues = 1const AdResyncallVALUES = 2'
---- CompareEnum Values ---- Const adCompareLessThan = 0Const adCompareEqual = 1Const adCompareGreaterThan = 2Const adCompareNotEqual = 3Const adCompareNotComparable = 4 '---- FilterGroupEnum Values ---- Const adFilterNone = 0Const adFilterPendingRecords = 1Const adFilterAffectedRecords = 2Const adFilterFetchedRecords = 3Const adFilterConflictingRecords = 5 '---- SearchDirectionEnum Values ---- Const adSearchForward = 1Const adSearchBackward = -1' ---- PersistFormatEnum Values ---- Const adPersistADTG = 0Const adPersistXML = 1 '---- StringFormatEnum Values --- -Const adClipString = 2 '---- ConnectPromptEnum Values ---- Const adPromptAlways = 1Const adPromptComplete = 2Const adPromptCompleteRequired = 3Const adPromptNever = 4' ---- ConnectModeEnum Values ---- Const adModeUnknown = 0Const adModeRead = 1Const adModeWrite = 2Const AdmodeReadwrite = 3const AdmodesharedenyRead = 4const AdmodesharedenyWrite = 8const AdmodesharexClusive = & HcConst Admodesharedenynynone = & H10const AdmodeRecursive = & H 400000 '---- RecordCreateOptionsEnum Values ---- Const adCreateCollection = & H00002000Const adCreateStructDoc = & H80000000Const adCreateNonCollection = & H00000000Const adOpenIfExists = & H02000000Const adCreateOverwrite = & H04000000Const adFailIfNotExists = -1' ---- RecordOpenOptionsEnum Values ---- Const adOpenRecordUnspecified = -1Const adOpenOutput = & H00800000const adopenasync = & h00001000const addelayFetchstream = & h00004000const addelayFetchfields = & h00008000const adopnexecuteCommand = &
H00010000 '---- IsolationLevelEnum Values ---- Const adXactUnspecified = & HffffffffConst adXactChaos = & H00000010Const adXactReadUncommitted = & H00000100Const adXactBrowse = & H00000100Const adXactCursorStability = & H00001000Const adXactReadCommitted = & H00001000Const adXactRepeatableRead = & H00010000Const adXactSerializable = & H00100000Const adXactIsolated = & H00100000' ---- XactAttributeEnum Values --- -Const adXactCommitRetaining = & H00020000Const adXactAbortRetaining = & H00040000 '---- PropertyAttributesEnum Values ---- Const adPropNotSupported = & H0000Const adPropRequired = & H0001Const adPropOptional = & H0002Const adPropRead = & H0200Const adPropWrite = & H0400' ---- ErrorValueEnum Values ---- Const adErrProviderFailed = & Hbb8Const adErrInvalidArgument = & Hbb9Const adErrOpeningFile = & HbbaConst adErrReadFile = & HbbbConst adErrWriteFile = & HbbcConst adErrNoCurrentRecord = & HbcdConst adErrIllegalOperation = & Hc93Const adErrCantChangeProvider = & Hc94Const adErrInTransaction = & HcaeConst adE rrFeatureNotAvailable = & Hcb3Const adErrItemNotFound = & Hcc1Const adErrObjectInCollection = & Hd27Const adErrObjectNotSet = & Hd5cConst adErrDataConversion = & Hd5dConst adErrObjectClosed = & He78Const adErrObjectOpen = & He79Const adErrProviderNotFound = & He7aConst adErrBoundToCommand = & He7bConst adErrInvalidParamInfo = & He7cConst adErrInvalidConnection = & He7dConst adErrNotReentrant = & He7eConst adErrStillExecuting = &
He7fConst adErrOperationCancelled = & He80Const adErrStillConnecting = & He81Const adErrInvalidTransaction = & He82Const adErrUnsafeOperation = & He84Const adwrnSecurityDialog = & He85Const adwrnSecurityDialogHeader = & He86Const adErrIntegrityViolation = & He87Const adErrPermissionDenied = & He88Const adErrDataOverflow = & He89Const adErrSchemaViolation = & He8aConst adErrSignMismatch = & He8bConst adErrCantConvertvalue = & He8cConst adErrCantCreate = & He8dConst adErrColumnNotOnThisRow = & He8eConst adErrURLIntegrViolSetColumns = & He8fConst adErrURLDoesNotExist = & He8fConst adErrTreePermissionDenied = & He90Const adErrInvalidURL = & He91Const adErrResourceLocked = & He92Const adErrResourceExists = & He93Const adErrCannotComplete = & He94Const adErrVolumeNotFound = & He95Const adErrOutOfSpace = & He96Const adErrResourceOutOfScope = & He97Const adErrUnavailable = & He98Const adErrURLNamedRowDoesNotExist = & He99Const adErrDelResOutOfScope = & He9aConst adErrPropInvalidColumn = & He9bConst adErrPropInvalidOption = & He9cConst adErrPropInvalidValue = & He9dConst adErrPropConflicting = & He9eConst adErrPropNotAllSettable = & He9fConst adErrPropNotSet = & Hea0Const adErrPropNotSettable = & Hea1Const adErrPropNotSupported = & Hea2Const adErrCatalogNotSet = & Hea3Const adErrCantChangeConnection = & Hea4Const adErrFieldsUpdateFailed = & Hea5Const adErrDenyNotSupported = & Hea6Const adErrDenyTypeNotSupported = & Hea7Const adErrProviderNotSpecified =
& Hea9 '---- ParameterAttributesEnum Values ---- Const adParamSigned = & H0010Const adParamNullable = & H0040Const adParamLong = & H0080' ---- ParameterDirectionEnum Values ---- Const adParamUnknown = & H0000Const adParamInput = & H0001Const adParamOutput = & H0002Const adParamInputOutput = & H0003Const adParamReturnValue = & H0004 ' ---- CommandTypeEnum Values ---- Const adCmdUnknown = & H0008Const adCmdText = & H0001Const adCmdTable = & H0002Const adCmdStoredProc = & H0004Const adCmdFile = & H0100Const adCmdTableDirect = & H0200 '---- EventStatusEnum Values ---- Const adStatusOK = & H0000001Const adStatusErrorsOccurred = & H0000002Const adStatusCantDeny = & H0000003Const adStatusCancel = & H0000004Const adStatusUnwantedEvent = & H0000005 '---- EventReasonEnum Values ---- Const adRsnAddNew = 1Const adRsnDelete = 2Const adRsnUpdate = 3Const adRsnUndoUpdate = 4Const adRsnUndoAddNew = 5Const adRsnUndoDelete = 6Const adRsnRequery = 7Const adRsnResynch = 8Const adRsnClose = 9Const adRsnMove = 10Const adRsnFirstChan ge = 11Const adRsnMoveFirst = 12Const adRsnMoveNext = 13Const adRsnMovePrevious = 14Const adRsnMoveLast = 15 '---- SchemaEnum Values ---- Const adSchemaProviderSpecific = -1Const adSchemaAsserts = 0Const adSchemaCatalogs = 1Const adSchemaCharacterSets = 2Const adSchemaCollations = 3Const adSchemaColumns = 4Const adSchemaCheckConstraints = 5Const adSchemaConstraintColumnUsage = 6const AdschemAconstraintTableusage = 7const AdschemakeyColumnUsage =
8Const adSchemaReferentialConstraints = 9Const adSchemaTableConstraints = 10Const adSchemaColumnsDomainUsage = 11Const adSchemaIndexes = 12Const adSchemaColumnPrivileges = 13Const adSchemaTablePrivileges = 14Const adSchemaUsagePrivileges = 15Const adSchemaProcedures = 16Const adSchemaSchemata = 17Const adSchemaSQLLanguages = 18Const adSchemaStatistics = 19Const adSchemaTables = 20Const adSchemaTranslations = 21Const adSchemaProviderTypes = 22Const adSchemaViews = 23Const adSchemaViewColumnUsage = 24Const adSchemaViewTableUsage = 25Const adSchemaProcedureParameters = 26Const adSchemaForeignKeys = 27Const adSchemaPrimaryKeys = 28Const adSchemaProcedureColumns = 29Const adSchemaDBInfoKeywords = 30Const adSchemaDBInfoLiterals = 31Const adSchemaCubes = 32Const adSchemaDimensions = 33Const adSchemaHierarchies = 34Const adSchemaLevels = 35Const adSchemaMeasures = 36Const adSchemaProperties = 37Const adSchemaMembers = 38Const adSchemaTrustees = 39Const adSchemaFunctions = 40Const adSchemaActio ns = 41Const adSchemaCommands = 42Const adSchemaSets = 43 '---- FieldStatusEnum Values ---- Const adFieldOK = 0Const adFieldCantConvertValue = 2Const adFieldIsNull = 3Const adFieldTruncated = 4Const adFieldSignMismatch = 5Const adFieldDataOverflow = 6Const adFieldCantCreate = 7Const adFieldUnavailable = 8Const adFieldPermissionDenied = 9Const adFieldIntegrityViolation = 10const adfieldschemaviolation = 11const adfieldbadstatus = 12const adfieldDefault = 13const adfieldore = 15const adfieldDoesNoteXist = 16const AdfieldInvalidURL =
17Const adFieldResourceLocked = 18Const adFieldResourceExists = 19Const adFieldCannotComplete = 20Const adFieldVolumeNotFound = 21Const adFieldOutOfSpace = 22Const adFieldCannotDeleteSource = 23Const adFieldReadOnly = 24Const adFieldResourceOutOfScope = 25Const adFieldAlreadyExists = 26Const adFieldPendingInsert = & H10000Const adFieldPendingDelete = & H20000Const adFieldPendingChange = & H40000Const adFieldPendingUnknown = & H80000Const adFieldPendingUnknownDelete = & H100000 '---- SeekEnum Values ---- Const adSeekFirstEQ = & H1Const adSeekLastEQ = & H2Const adSeekAfterEQ = & H4Const adSeekAfter = & H8Const adSeekBeforeEQ = & H10Const adSeekBefore = & H20 '---- ADCPROP_UPDATECRITERIA_ENUM Values ---- Const adCriteriaKey = 0Const adCriteriaAllCols = 1Const adCriteriaUpdCols = 2Const adCriteriaTimeStamp = 3' - - ADCPROP_ASYNCTHREADPRIORITY_ENUM VALUES ---- const adpriorityLowest = 1const AdpringBelownormal = 2const AdpringNormal = 3Const AdpringAbovenormal = 4const AdpringHighest = 5 '- - ADCPROP_AUTORECALC_ENUM Values ---- Const adRecalcUpFront = 0Const adRecalcAlways = 1 '---- ADCPROP_UPDATERESYNC_ENUM Values ----' ---- ADCPROP_UPDATERESYNC_ENUM Values ---- '---- MoveRecordOptionsEnum Values ---- Const adMoveUnspecified = -1Const adMoveOverWrite = 1Const adMoveDontUpdateLinks = 2Const adMoveAllowEmulation = 4 '---- CopyRecordOptionsEnum Values ---- Const adCopyUnspecified = -1Const adCopyOverWrite = 1Const adCopyAllowEmulation = 4Const adCopyNonRecursive = 2'
