Constant in the ADO object

xiaoxiao2021-03-06  104

<% '----------------------------------------------- -------------------- "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 AdlockReadOnly = 1const AdlockPESSIMISTIC = 2Const AdlockOptimistic = 3const AdlockBatchOptiMistic = 4

'---- ExecuteOptionEnum Values ​​---- Const adAsyncExecute = & H00000010Const adAsyncFetch = & 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 ​​---- Const 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 Adrecuschemaviolation = & H0020000Const AdrecdbDeleted = & H0040000

'---- GetRowSoptionenum Values ​​---- Const AdgetrowsRest = -1

'---- Positionenum VALUES ---- Const adposunknown = -1const adposbof = -2const adposeof = -3

'---- BookMarkenum Values ​​---- Const AdbookmarkCurrent = 0const AdbookMarkFirst = 1Const AdbookmarkLast = 2

'---- Marshaloptionsenum Values ​​---- Const Admarshalall = 0const AdmarshalModifiedOrthly = 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

'---- Filtergrouplenum Values ​​---- Const Adfilternone = 0const AdfilterpendingRecords = 1const AdfilteraffectedRecords = 2const AdfilterFetchedRecords = 3const AdfilterConflictageRecords = 5

'---- SearchDirectionNum Values ​​---- Const AdSearchForward = 1const AdSearchbackward = -1

'---- PersistFormatenum Values ​​---- Const AdpersistAdtg = 0const AdpersistXML = 1

'---- StringFormatenum VALUES ---- Const Adclipstring = 2

'---- ConnectPtenum Values ​​---- Const Adpromptalways = 1const AdpromptComplete = 2Const AdppTCompleteRequired = 3const Adpromptnever = 4

'---- ConnectModeEnum Values ​​---- Const adModeUnknown = 0Const adModeRead = 1Const adModeWrite = 2Const adModeReadWrite = 3Const adModeShareDenyRead = 4Const adModeShareDenyWrite = 8Const adModeShareExclusive = & HcConst adModeShareDenyNone = & H10Const adModeRecursive = & H400000

'---- RecordCreateOptionsEnum Values ​​---- Const adCreateCollection = & H00002000Const adCreateStructDoc = & H80000000Const adCreateNonCollection = & H00000000Const adOpenIfExists = & H02000000Const adCreateOverwrite = & H04000000Const adFailIfNotExists = -1' ---- RecordOpenOptionsEnum Values ​​---- Const adOpenRecordUnspecified = -1Const adOpenOutput = & H00800000Const AdoPenasync = & H00001000Const AddingFetchStream = & H00004000const AddingEfetchfields = & 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 ADXACTCOMMITRETAING = & H00020000Const ADXACTABORTRETAING = & 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 adErrFeatureNotAvailable = & 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 adRsnFirstChange = 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 Adschemaprocedureco lumns = 29Const adSchemaDBInfoKeywords = 30Const adSchemaDBInfoLiterals = 31Const adSchemaCubes = 32Const adSchemaDimensions = 33Const adSchemaHierarchies = 34Const adSchemaLevels = 35Const adSchemaMeasures = 36Const adSchemaProperties = 37Const adSchemaMembers = 38Const adSchemaTrustees = 39Const adSchemaFunctions = 40Const adSchemaActions = 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 adFieldIgnore = 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 Adseekfirst EQ = & h1const adseeklasteq = & h2const adseekaftereq = & h4const adseekafter = & h8const adseekbeforeeeQ = & h10const adseekbefore = & h20

'---- adcprop_updatecriteria_enum value ---- const adcriteriakey = 0const adcriteriaAllCols = 1const adcrienteriaupdcols = 2const adcrienteriatimestamp = 3

'---- adcprop_asyncthreadpriority_enum value ---- const adprioritylowest = 1const AdpringBelownormal = 2const AdpringNormal = 3Const AdpringAbovenormal = 4const AdpringHighest = 5

'---- adcprop_autorecalc_enum value ---- const adrecalcupfront = 0const adRecalWays = 1' ---- adcprop_updateresync_enum value ----

'---- ADCPROP_UPDATERESYNC_ENUM VALUES ----

'---- MoveRecordOptionsenum Values ​​---- Const AdmoveUnspecified = -1const AdmoveOverWrite = 1const AdmoveDontuPdatelinks = 2const AdmoveAlloWemulation = 4

'---- CopyRecordoptionsenum value ---- const adcopyunspecified = -1const adcopyOverWrite = 1const adcopyAllowemulation = 4const AdcopyNonRecursive = 2

'---- StreetPeenum Values ​​---- Const Adtypebinary = 1const Adtypetext = 2

'---- LinseParatorenum Values ​​---- Const ADLF = 10const ADCR = 13const adcrlf = -1

'---- StreamopenOptionsenum Values ​​---- Const AdopenStreamunSpecified = -1const AdoPenStreamasync = 1const AdoPenStreamFromRecord = 4

'---- StreamWriteEnum Values ​​---- Const AdWriteChar = 0const AdWriteLine = 1

'---- SaveOptionsenum Values ​​---- Const AdaVecreatenotexist = 1const AdsavecreateOverWrite = 2

'---- Fieldenum VALUES ---- Const AdefaultStream = -1const adRecordURL = -2

'---- StreamReadenum VALUES ---- Const Adreadall = -1const AdreadLine = -2

'---- RecordtyPeenum Values ​​---- Const AdsimpleRecord = 0const AdcollectionRecord = 1Const AdstructDoc = 2%>

转载请注明原文地址:https://www.9cbs.com/read-101786.html

New Post(0)