01: '---------------------------------------
02: ' Microsoft ADO
'
03: ' Copyright (c) 1996-1998 Microsoft Corporation.
'
'
'
04: ' ADO constants include file for VBScript
'
05: '--------------------------------------

06: '---- CursorTypeEnum Values ----
07: Const adOpenForwardOnly = 0
08: Const adOpenKeyset = 1
09: Const adOpenDynamic = 2
10: Const adOpenStatic = 3

11: '---- CursorOptionEnum Values ----
12: Const adHoldRecords = &H00000100
13: Const adMovePrevious = &H00000200
14: Const adAddNew = &H01000400
15: Const adDelete = &H01000800
16: Const adUpdate = &H01008000
17: Const adBookmark = &H00002000
18: Const adApproxPosition = &H00004000
19: Const adUpdateBatch = &H00010000
20: Const adResync = &H00020000
21: Const adNotify = &H00040000
22: Const adFind = &H00080000
23: Const adSeek = &H00400000
24: Const adIndex = &H00800000

25: '---- LockTypeEnum Values ----
26: Const adLockReadOnly = 1
27: Const adLockPessimistic = 2
28: Const adLockOptimistic = 3
29: Const adLockBatchOptimistic = 4

30: '---- ExecuteOptionEnum Values ----
31: Const adAsyncExecute = &H00000010
32: Const adAsyncFetch = &H00000020
33: Const adAsyncFetchNonBlocking = &H00000040
34: Const adExecuteNoRecords = &H00000080

35: '---- ConnectOptionEnum Values ----
36: Const adAsyncConnect = &H00000010

37: '---- ObjectStateEnum Values ----
38: Const adStateClosed = &H00000000
39: Const adStateOpen = &H00000001
40: Const adStateConnecting = &H00000002
41: Const adStateExecuting = &H00000004
42: Const adStateFetching = &H00000008

43: '---- CursorLocationEnum Values ----
44: Const adUseServer = 2
45: Const adUseClient = 3

46: '---- DataTypeEnum Values ----
47: Const adEmpty = 0
48: Const adTinyInt = 16
49: Const adSmallInt = 2
50: Const adInteger = 3
51: Const adBigInt = 20
52: Const adUnsignedTinyInt = 17
53: Const adUnsignedSmallInt = 18
54: Const adUnsignedInt = 19
55: Const adUnsignedBigInt = 21
56: Const adSingle = 4
57: Const adDouble = 5
58: Const adCurrency = 6
59: Const adDecimal = 14
60: Const adNumeric = 131
61: Const adBoolean = 11
62: Const adError = 10
63: Const adUserDefined = 132
64: Const adVariant = 12
65: Const adIDispatch = 9
66: Const adIUnknown = 13
67: Const adGUID = 72
68: Const adDate = 7
69: Const adDBDate = 133
70: Const adDBTime = 134
71: Const adDBTimeStamp = 135
72: Const adBSTR = 8
73: Const adChar = 129
74: Const adVarChar = 200
75: Const adLongVarChar = 201
76: Const adWChar = 130
77: Const adVarWChar = 202
78: Const adLongVarWChar = 203
79: Const adBinary = 128
80: Const adVarBinary = 204
81: Const adLongVarBinary = 205
82: Const adChapter = 136
83: Const adFileTime = 64
84: Const adPropVariant = 138
85: Const adVarNumeric = 139
86: Const adArray = &H2000

87: '---- FieldAttributeEnum Values ----
88: Const adFldMayDefer = &H00000002
89: Const adFldUpdatable = &H00000004
90: Const adFldUnknownUpdatable = &H00000008
91: Const adFldFixed = &H00000010
92: Const adFldIsNullable = &H00000020
93: Const adFldMayBeNull = &H00000040
94: Const adFldLong = &H00000080
95: Const adFldRowID = &H00000100
96: Const adFldRowVersion = &H00000200
97: Const adFldCacheDeferred = &H00001000
98: Const adFldIsChapter = &H00002000
99: Const adFldNegativeScale = &H00004000
100: Const adFldKeyColumn = &H00008000
101: Const adFldIsRowURL = &H00010000
102: Const adFldIsDefaultStream = &H00020000
103: Const adFldIsCollection = &H00040000

104: '---- EditModeEnum Values ----
105: Const adEditNone = &H0000
106: Const adEditInProgress = &H0001
107: Const adEditAdd = &H0002
108: Const adEditDelete = &H0004

109: '---- RecordStatusEnum Values ----
110: Const adRecOK = &H0000000
111: Const adRecNew = &H0000001
112: Const adRecModified = &H0000002
113: Const adRecDeleted = &H0000004
114: Const adRecUnmodified = &H0000008
115: Const adRecInvalid = &H0000010
116: Const adRecMultipleChanges = &H0000040
117: Const adRecPendingChanges = &H0000080
118: Const adRecCanceled = &H0000100
119: Const adRecCantRelease = &H0000400
120: Const adRecConcurrencyViolation = &H0000800
121: Const adRecIntegrityViolation = &H0001000
122: Const adRecMaxChangesExceeded = &H0002000
123: Const adRecObjectOpen = &H0004000
124: Const adRecOutOfMemory = &H0008000
125: Const adRecPermissionDenied = &H0010000
126: Const adRecSchemaViolation = &H0020000
127: Const adRecDBDeleted = &H0040000

128: '---- GetRowsOptionEnum Values ----
129: Const adGetRowsRest = -1

130: '---- PositionEnum Values ----
131: Const adPosUnknown = -1
132: Const adPosBOF = -2
133: Const adPosEOF = -3

134: '---- BookmarkEnum Values ----
135: Const adBookmarkCurrent = 0
136: Const adBookmarkFirst = 1
137: Const adBookmarkLast = 2

138: '---- MarshalOptionsEnum Values ----
139: Const adMarshalAll = 0
140: Const adMarshalModifiedOnly = 1

141: '---- AffectEnum Values ----
142: Const adAffectCurrent = 1
143: Const adAffectGroup = 2
144: Const adAffectAllChapters = 4

145: '---- ResyncEnum Values ----
146: Const adResyncUnderlyingValues = 1
147: Const adResyncAllValues = 2

148: '---- CompareEnum Values ----
149: Const adCompareLessThan = 0
150: Const adCompareEqual = 1
151: Const adCompareGreaterThan = 2
152: Const adCompareNotEqual = 3
153: Const adCompareNotComparable = 4

154: '---- FilterGroupEnum Values ----
155: Const adFilterNone = 0
156: Const adFilterPendingRecords = 1
157: Const adFilterAffectedRecords = 2
158: Const adFilterFetchedRecords = 3
159: Const adFilterConflictingRecords = 5

160: '---- SearchDirectionEnum Values ----
161: Const adSearchForward = 1
162: Const adSearchBackward = -1

163: '---- PersistFormatEnum Values ----
164: Const adPersistADTG = 0
165: Const adPersistXML = 1

166: '---- StringFormatEnum Values ----
167: Const adClipString = 2

168: '---- ConnectPromptEnum Values ----
169: Const adPromptAlways = 1
170: Const adPromptComplete = 2
171: Const adPromptCompleteRequired = 3
172: Const adPromptNever = 4

173: '---- ConnectModeEnum Values ----
174: Const adModeUnknown = 0
175: Const adModeRead = 1
176: Const adModeWrite = 2
177: Const adModeReadWrite = 3
178: Const adModeShareDenyRead = 4
179: Const adModeShareDenyWrite = 8
180: Const adModeShareExclusive = &Hc
181: Const adModeShareDenyNone = &H10
182: Const adModeRecursive = &H400000

183: '---- RecordCreateOptionsEnum Values ----
184: Const adCreateCollection = &H00002000
185: Const adCreateStructDoc = &H80000000
186: Const adCreateNonCollection = &H00000000
187: Const adOpenIfExists = &H02000000
188: Const adCreateOverwrite = &H04000000
189: Const adFailIfNotExists = -1

190: '---- RecordOpenOptionsEnum Values ----
191: Const adOpenRecordUnspecified = -1
192: Const adOpenSource = &H00800000
193: Const adOpenAsync = &H00001000
194: Const adDelayFetchStream = &H00004000
195: Const adDelayFetchFields = &H00008000

196: '---- IsolationLevelEnum Values ----
197: Const adXactUnspecified = &Hffffffff
198: Const adXactChaos = &H00000010
199: Const adXactReadUncommitted = &H00000100
200: Const adXactBrowse = &H00000100
201: Const adXactCursorStability = &H00001000
202: Const adXactReadCommitted = &H00001000
203: Const adXactRepeatableRead = &H00010000
204: Const adXactSerializable = &H00100000
205: Const adXactIsolated = &H00100000

206: '---- XactAttributeEnum Values ----
207: Const adXactCommitRetaining = &H00020000
208: Const adXactAbortRetaining = &H00040000

209: '---- PropertyAttributesEnum Values ----
210: Const adPropNotSupported = &H0000
211: Const adPropRequired = &H0001
212: Const adPropOptional = &H0002
213: Const adPropRead = &H0200
214: Const adPropWrite = &H0400

215: '---- ErrorValueEnum Values ----
216: Const adErrProviderFailed = &Hbb8
217: Const adErrInvalidArgument = &Hbb9
218: Const adErrOpeningFile = &Hbba
219: Const adErrReadFile = &Hbbb
220: Const adErrWriteFile = &Hbbc
221: Const adErrNoCurrentRecord = &Hbcd
222: Const adErrIllegalOperation = &Hc93
223: Const adErrCantChangeProvider = &Hc94
224: Const adErrInTransaction = &Hcae
225: Const adErrFeatureNotAvailable = &Hcb3
226: Const adErrItemNotFound = &Hcc1
227: Const adErrObjectInCollection = &Hd27
228: Const adErrObjectNotSet = &Hd5c
229: Const adErrDataConversion = &Hd5d
230: Const adErrObjectClosed = &He78
231: Const adErrObjectOpen = &He79
232: Const adErrProviderNotFound = &He7a
233: Const adErrBoundToCommand = &He7b
234: Const adErrInvalidParamInfo = &He7c
235: Const adErrInvalidConnection = &He7d
236: Const adErrNotReentrant = &He7e
237: Const adErrStillExecuting = &He7f
238: Const adErrOperationCancelled = &He80
239: Const adErrStillConnecting = &He81
240: Const adErrInvalidTransaction = &He82
241: Const adErrUnsafeOperation = &He84
242: Const adwrnSecurityDialog = &He85
243: Const adwrnSecurityDialogHeader = &He86
244: Const adErrIntegrityViolation = &He87
245: Const adErrPermissionDenied = &He88
246: Const adErrDataOverflow = &He89
247: Const adErrSchemaViolation = &He8a
248: Const adErrSignMismatch = &He8b
249: Const adErrCantConvertvalue = &He8c
250: Const adErrCantCreate = &He8d
251: Const adErrColumnNotOnThisRow = &He8e
252: Const adErrURLIntegrViolSetColumns = &He8f
253: Const adErrURLDoesNotExist = &He8f
254: Const adErrTreePermissionDenied = &He90
255: Const adErrInvalidURL = &He91
256: Const adErrResourceLocked = &He92
257: Const adErrResourceExists = &He93
258: Const adErrCannotComplete = &He94
259: Const adErrVolumeNotFound = &He95
260: Const adErrOutOfSpace = &He96
261: Const adErrResourceOutOfScope = &He97
262: Const adErrUnavailable = &He98
263: Const adErrURLNamedRowDoesNotExist = &He99
264: Const adErrDelResOutOfScope = &He9a
265: Const adErrPropInvalidColumn = &He9b
266: Const adErrPropInvalidOption = &He9c
267: Const adErrPropInvalidValue = &He9d
268: Const adErrPropConflicting = &He9e
269: Const adErrPropNotAllSettable = &He9f
270: Const adErrPropNotSet = &Hea0
271: Const adErrPropNotSettable = &Hea1
272: Const adErrPropNotSupported = &Hea2
273: Const adErrCatalogNotSet = &Hea3
274: Const adErrCantChangeConnection = &Hea4
275: Const adErrFieldsUpdateFailed = &Hea5
276: Const adErrDenyNotSupported = &Hea6
277: Const adErrDenyTypeNotSupported = &Hea7

278: '---- ParameterAttributesEnum Values ----
279: Const adParamSigned = &H0010
280: Const adParamNullable = &H0040
281: Const adParamLong = &H0080

282: '---- ParameterDirectionEnum Values ----
283: Const adParamUnknown = &H0000
284: Const adParamInput = &H0001
285: Const adParamOutput = &H0002
286: Const adParamInputOutput = &H0003
287: Const adParamReturnValue = &H0004

288: '---- CommandTypeEnum Values ----
289: Const adCmdUnknown = &H0008
290: Const adCmdText = &H0001
291: Const adCmdTable = &H0002
292: Const adCmdStoredProc = &H0004
293: Const adCmdFile = &H0100
294: Const adCmdTableDirect = &H0200

295: '---- EventStatusEnum Values ----
296: Const adStatusOK = &H0000001
297: Const adStatusErrorsOccurred = &H0000002
298: Const adStatusCantDeny = &H0000003
299: Const adStatusCancel = &H0000004
300: Const adStatusUnwantedEvent = &H0000005

301: '---- EventReasonEnum Values ----
302: Const adRsnAddNew = 1
303: Const adRsnDelete = 2
304: Const adRsnUpdate = 3
305: Const adRsnUndoUpdate = 4
306: Const adRsnUndoAddNew = 5
307: Const adRsnUndoDelete = 6
308: Const adRsnRequery = 7
309: Const adRsnResynch = 8
310: Const adRsnClose = 9
311: Const adRsnMove = 10
312: Const adRsnFirstChange = 11
313: Const adRsnMoveFirst = 12
314: Const adRsnMoveNext = 13
315: Const adRsnMovePrevious = 14
316: Const adRsnMoveLast = 15

317: '---- SchemaEnum Values ----
318: Const adSchemaProviderSpecific = -1
319: Const adSchemaAsserts = 0
320: Const adSchemaCatalogs = 1
321: Const adSchemaCharacterSets = 2
322: Const adSchemaCollations = 3
323: Const adSchemaColumns = 4
324: Const adSchemaCheckConstraints = 5
325: Const adSchemaConstraintColumnUsage = 6
326: Const adSchemaConstraintTableUsage = 7
327: Const adSchemaKeyColumnUsage = 8
328: Const adSchemaReferentialConstraints = 9
329: Const adSchemaTableConstraints = 10
330: Const adSchemaColumnsDomainUsage = 11
331: Const adSchemaIndexes = 12
332: Const adSchemaColumnPrivileges = 13
333: Const adSchemaTablePrivileges = 14
334: Const adSchemaUsagePrivileges = 15
335: Const adSchemaProcedures = 16
336: Const adSchemaSchemata = 17
337: Const adSchemaSQLLanguages = 18
338: Const adSchemaStatistics = 19
339: Const adSchemaTables = 20
340: Const adSchemaTranslations = 21
341: Const adSchemaProviderTypes = 22
342: Const adSchemaViews = 23
343: Const adSchemaViewColumnUsage = 24
344: Const adSchemaViewTableUsage = 25
345: Const adSchemaProcedureParameters = 26
346: Const adSchemaForeignKeys = 27
347: Const adSchemaPrimaryKeys = 28
348: Const adSchemaProcedureColumns = 29
349: Const adSchemaDBInfoKeywords = 30
350: Const adSchemaDBInfoLiterals = 31
351: Const adSchemaCubes = 32
352: Const adSchemaDimensions = 33
353: Const adSchemaHierarchies = 34
354: Const adSchemaLevels = 35
355: Const adSchemaMeasures = 36
356: Const adSchemaProperties = 37
357: Const adSchemaMembers = 38
358: Const adSchemaTrustees = 39

359: '---- FieldStatusEnum Values ----
360: Const adFieldOK = 0
361: Const adFieldCantConvertValue = 2
362: Const adFieldIsNull = 3
363: Const adFieldTruncated = 4
364: Const adFieldSignMismatch = 5
365: Const adFieldDataOverflow = 6
366: Const adFieldCantCreate = 7
367: Const adFieldUnavailable = 8
368: Const adFieldPermissionDenied = 9
369: Const adFieldIntegrityViolation = 10
370: Const adFieldSchemaViolation = 11
371: Const adFieldBadStatus = 12
372: Const adFieldDefault = 13
373: Const adFieldIgnore = 15
374: Const adFieldDoesNotExist = 16
375: Const adFieldInvalidURL = 17
376: Const adFieldResourceLocked = 18
377: Const adFieldResourceExists = 19
378: Const adFieldCannotComplete = 20
379: Const adFieldVolumeNotFound = 21
380: Const adFieldOutOfSpace = 22
381: Const adFieldCannotDeleteSource = 23
382: Const adFieldReadOnly = 24
383: Const adFieldResourceOutOfScope = 25
384: Const adFieldAlreadyExists = 26
385: Const adFieldPendingInsert = &H10000
386: Const adFieldPendingDelete = &H20000
387: Const adFieldPendingChange = &H40000
388: Const adFieldPendingUnknown = &H80000
389: Const adFieldPendingUnknownDelete = &H100000

390: '---- SeekEnum Values ----
391: Const adSeekFirstEQ = &H1
392: Const adSeekLastEQ = &H2
393: Const adSeekAfterEQ = &H4
394: Const adSeekAfter = &H8
395: Const adSeekBeforeEQ = &H10
396: Const adSeekBefore = &H20

397: '---- ADCPROP_UPDATECRITERIA_ENUM Values ----
398: Const adCriteriaKey = 0
399: Const adCriteriaAllCols = 1
400: Const adCriteriaUpdCols = 2
401: Const adCriteriaTimeStamp = 3

402: '---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----
403: Const adPriorityLowest = 1
404: Const adPriorityBelowNormal = 2
405: Const adPriorityNormal = 3
406: Const adPriorityAboveNormal = 4
407: Const adPriorityHighest = 5

408: '---- ADCPROP_AUTORECALC_ENUM Values ----
409: Const adRecalcUpFront = 0
410: Const adRecalcAlways = 1

411: '---- ADCPROP_UPDATERESYNC_ENUM Values ----

412: '---- ADCPROP_UPDATERESYNC_ENUM Values ----

413: '---- MoveRecordOptionsEnum Values ----
414: Const adMoveUnspecified = -1
415: Const adMoveOverWrite = 1
416: Const adMoveDontUpdateLinks = 2
417: Const adMoveAllowEmulation = 4

418: '---- CopyRecordOptionsEnum Values ----
419: Const adCopyUnspecified = -1
420: Const adCopyOverWrite = 1
421: Const adCopyAllowEmulation = 4
422: Const adCopyNonRecursive = 2

423: '---- StreamTypeEnum Values ----
424: Const adTypeBinary = 1
425: Const adTypeText = 2

426: '---- LineSeparatorEnum Values ----
427: Const adLF = 10
428: Const adCR = 13
429: Const adCRLF = -1

430: '---- StreamOpenOptionsEnum Values ----
431: Const adOpenStreamUnspecified = -1
432: Const adOpenStreamAsync = 1
433: Const adOpenStreamFromRecord = 4

434: '---- StreamWriteEnum Values ----
435: Const adWriteChar = 0
436: Const adWriteLine = 1

437: '---- SaveOptionsEnum Values ----
438: Const adSaveCreateNotExist = 1
439: Const adSaveCreateOverWrite = 2

440: '---- FieldEnum Values ----
441: Const adDefaultStream = -1
442: Const adRecordURL = -2

443: '---- StreamReadEnum Values ----
444: Const adReadAll = -1
445: Const adReadLine = -2

446: '---- RecordTypeEnum Values ----
447: Const adSimpleRecord = 0
448: Const adCollectionRecord = 1
449: Const adStructDoc = 2