adovbs.inc 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521
  1. <%
  2. '--------------------------------------------------------------------
  3. ' Microsoft ADO
  4. '
  5. ' Copyright (c) 1996-1998 Microsoft Corporation.
  6. '
  7. '
  8. '
  9. ' ADO constants include file for VBScript
  10. '
  11. '--------------------------------------------------------------------
  12. '---- CursorTypeEnum Values ----
  13. Const adOpenForwardOnly = 0
  14. Const adOpenKeyset = 1
  15. Const adOpenDynamic = 2
  16. Const adOpenStatic = 3
  17. '---- CursorOptionEnum Values ----
  18. Const adHoldRecords = &H00000100
  19. Const adMovePrevious = &H00000200
  20. Const adAddNew = &H01000400
  21. Const adDelete = &H01000800
  22. Const adUpdate = &H01008000
  23. Const adBookmark = &H00002000
  24. Const adApproxPosition = &H00004000
  25. Const adUpdateBatch = &H00010000
  26. Const adResync = &H00020000
  27. Const adNotify = &H00040000
  28. Const adFind = &H00080000
  29. Const adSeek = &H00400000
  30. Const adIndex = &H00800000
  31. '---- LockTypeEnum Values ----
  32. Const adLockReadOnly = 1
  33. Const adLockPessimistic = 2
  34. Const adLockOptimistic = 3
  35. Const adLockBatchOptimistic = 4
  36. '---- ExecuteOptionEnum Values ----
  37. Const adAsyncExecute = &H00000010
  38. Const adAsyncFetch = &H00000020
  39. Const adAsyncFetchNonBlocking = &H00000040
  40. Const adExecuteNoRecords = &H00000080
  41. Const adExecuteStream = &H00000400
  42. '---- ConnectOptionEnum Values ----
  43. Const adAsyncConnect = &H00000010
  44. '---- ObjectStateEnum Values ----
  45. Const adStateClosed = &H00000000
  46. Const adStateOpen = &H00000001
  47. Const adStateConnecting = &H00000002
  48. Const adStateExecuting = &H00000004
  49. Const adStateFetching = &H00000008
  50. '---- CursorLocationEnum Values ----
  51. Const adUseServer = 2
  52. Const adUseClient = 3
  53. '---- DataTypeEnum Values ----
  54. Const adEmpty = 0
  55. Const adTinyInt = 16
  56. Const adSmallInt = 2
  57. Const adInteger = 3
  58. Const adBigInt = 20
  59. Const adUnsignedTinyInt = 17
  60. Const adUnsignedSmallInt = 18
  61. Const adUnsignedInt = 19
  62. Const adUnsignedBigInt = 21
  63. Const adSingle = 4
  64. Const adDouble = 5
  65. Const adCurrency = 6
  66. Const adDecimal = 14
  67. Const adNumeric = 131
  68. Const adBoolean = 11
  69. Const adError = 10
  70. Const adUserDefined = 132
  71. Const adVariant = 12
  72. Const adIDispatch = 9
  73. Const adIUnknown = 13
  74. Const adGUID = 72
  75. Const adDate = 7
  76. Const adDBDate = 133
  77. Const adDBTime = 134
  78. Const adDBTimeStamp = 135
  79. Const adBSTR = 8
  80. Const adChar = 129
  81. Const adVarChar = 200
  82. Const adLongVarChar = 201
  83. Const adWChar = 130
  84. Const adVarWChar = 202
  85. Const adLongVarWChar = 203
  86. Const adBinary = 128
  87. Const adVarBinary = 204
  88. Const adLongVarBinary = 205
  89. Const adChapter = 136
  90. Const adFileTime = 64
  91. Const adPropVariant = 138
  92. Const adVarNumeric = 139
  93. Const adArray = &H2000
  94. '---- FieldAttributeEnum Values ----
  95. Const adFldMayDefer = &H00000002
  96. Const adFldUpdatable = &H00000004
  97. Const adFldUnknownUpdatable = &H00000008
  98. Const adFldFixed = &H00000010
  99. Const adFldIsNullable = &H00000020
  100. Const adFldMayBeNull = &H00000040
  101. Const adFldLong = &H00000080
  102. Const adFldRowID = &H00000100
  103. Const adFldRowVersion = &H00000200
  104. Const adFldCacheDeferred = &H00001000
  105. Const adFldIsChapter = &H00002000
  106. Const adFldNegativeScale = &H00004000
  107. Const adFldKeyColumn = &H00008000
  108. Const adFldIsRowURL = &H00010000
  109. Const adFldIsDefaultStream = &H00020000
  110. Const adFldIsCollection = &H00040000
  111. '---- EditModeEnum Values ----
  112. Const adEditNone = &H0000
  113. Const adEditInProgress = &H0001
  114. Const adEditAdd = &H0002
  115. Const adEditDelete = &H0004
  116. '---- RecordStatusEnum Values ----
  117. Const adRecOK = &H0000000
  118. Const adRecNew = &H0000001
  119. Const adRecModified = &H0000002
  120. Const adRecDeleted = &H0000004
  121. Const adRecUnmodified = &H0000008
  122. Const adRecInvalid = &H0000010
  123. Const adRecMultipleChanges = &H0000040
  124. Const adRecPendingChanges = &H0000080
  125. Const adRecCanceled = &H0000100
  126. Const adRecCantRelease = &H0000400
  127. Const adRecConcurrencyViolation = &H0000800
  128. Const adRecIntegrityViolation = &H0001000
  129. Const adRecMaxChangesExceeded = &H0002000
  130. Const adRecObjectOpen = &H0004000
  131. Const adRecOutOfMemory = &H0008000
  132. Const adRecPermissionDenied = &H0010000
  133. Const adRecSchemaViolation = &H0020000
  134. Const adRecDBDeleted = &H0040000
  135. '---- GetRowsOptionEnum Values ----
  136. Const adGetRowsRest = -1
  137. '---- PositionEnum Values ----
  138. Const adPosUnknown = -1
  139. Const adPosBOF = -2
  140. Const adPosEOF = -3
  141. '---- BookmarkEnum Values ----
  142. Const adBookmarkCurrent = 0
  143. Const adBookmarkFirst = 1
  144. Const adBookmarkLast = 2
  145. '---- MarshalOptionsEnum Values ----
  146. Const adMarshalAll = 0
  147. Const adMarshalModifiedOnly = 1
  148. '---- AffectEnum Values ----
  149. Const adAffectCurrent = 1
  150. Const adAffectGroup = 2
  151. Const adAffectAllChapters = 4
  152. '---- ResyncEnum Values ----
  153. Const adResyncUnderlyingValues = 1
  154. Const adResyncAllValues = 2
  155. '---- CompareEnum Values ----
  156. Const adCompareLessThan = 0
  157. Const adCompareEqual = 1
  158. Const adCompareGreaterThan = 2
  159. Const adCompareNotEqual = 3
  160. Const adCompareNotComparable = 4
  161. '---- FilterGroupEnum Values ----
  162. Const adFilterNone = 0
  163. Const adFilterPendingRecords = 1
  164. Const adFilterAffectedRecords = 2
  165. Const adFilterFetchedRecords = 3
  166. Const adFilterConflictingRecords = 5
  167. '---- SearchDirectionEnum Values ----
  168. Const adSearchForward = 1
  169. Const adSearchBackward = -1
  170. '---- PersistFormatEnum Values ----
  171. Const adPersistADTG = 0
  172. Const adPersistXML = 1
  173. '---- StringFormatEnum Values ----
  174. Const adClipString = 2
  175. '---- ConnectPromptEnum Values ----
  176. Const adPromptAlways = 1
  177. Const adPromptComplete = 2
  178. Const adPromptCompleteRequired = 3
  179. Const adPromptNever = 4
  180. '---- ConnectModeEnum Values ----
  181. Const adModeUnknown = 0
  182. Const adModeRead = 1
  183. Const adModeWrite = 2
  184. Const adModeReadWrite = 3
  185. Const adModeShareDenyRead = 4
  186. Const adModeShareDenyWrite = 8
  187. Const adModeShareExclusive = &Hc
  188. Const adModeShareDenyNone = &H10
  189. Const adModeRecursive = &H400000
  190. '---- RecordCreateOptionsEnum Values ----
  191. Const adCreateCollection = &H00002000
  192. Const adCreateStructDoc = &H80000000
  193. Const adCreateNonCollection = &H00000000
  194. Const adOpenIfExists = &H02000000
  195. Const adCreateOverwrite = &H04000000
  196. Const adFailIfNotExists = -1
  197. '---- RecordOpenOptionsEnum Values ----
  198. Const adOpenRecordUnspecified = -1
  199. Const adOpenOutput = &H00800000
  200. Const adOpenAsync = &H00001000
  201. Const adDelayFetchStream = &H00004000
  202. Const adDelayFetchFields = &H00008000
  203. Const adOpenExecuteCommand = &H00010000
  204. '---- IsolationLevelEnum Values ----
  205. Const adXactUnspecified = &Hffffffff
  206. Const adXactChaos = &H00000010
  207. Const adXactReadUncommitted = &H00000100
  208. Const adXactBrowse = &H00000100
  209. Const adXactCursorStability = &H00001000
  210. Const adXactReadCommitted = &H00001000
  211. Const adXactRepeatableRead = &H00010000
  212. Const adXactSerializable = &H00100000
  213. Const adXactIsolated = &H00100000
  214. '---- XactAttributeEnum Values ----
  215. Const adXactCommitRetaining = &H00020000
  216. Const adXactAbortRetaining = &H00040000
  217. '---- PropertyAttributesEnum Values ----
  218. Const adPropNotSupported = &H0000
  219. Const adPropRequired = &H0001
  220. Const adPropOptional = &H0002
  221. Const adPropRead = &H0200
  222. Const adPropWrite = &H0400
  223. '---- ErrorValueEnum Values ----
  224. Const adErrProviderFailed = &Hbb8
  225. Const adErrInvalidArgument = &Hbb9
  226. Const adErrOpeningFile = &Hbba
  227. Const adErrReadFile = &Hbbb
  228. Const adErrWriteFile = &Hbbc
  229. Const adErrNoCurrentRecord = &Hbcd
  230. Const adErrIllegalOperation = &Hc93
  231. Const adErrCantChangeProvider = &Hc94
  232. Const adErrInTransaction = &Hcae
  233. Const adErrFeatureNotAvailable = &Hcb3
  234. Const adErrItemNotFound = &Hcc1
  235. Const adErrObjectInCollection = &Hd27
  236. Const adErrObjectNotSet = &Hd5c
  237. Const adErrDataConversion = &Hd5d
  238. Const adErrObjectClosed = &He78
  239. Const adErrObjectOpen = &He79
  240. Const adErrProviderNotFound = &He7a
  241. Const adErrBoundToCommand = &He7b
  242. Const adErrInvalidParamInfo = &He7c
  243. Const adErrInvalidConnection = &He7d
  244. Const adErrNotReentrant = &He7e
  245. Const adErrStillExecuting = &He7f
  246. Const adErrOperationCancelled = &He80
  247. Const adErrStillConnecting = &He81
  248. Const adErrInvalidTransaction = &He82
  249. Const adErrUnsafeOperation = &He84
  250. Const adwrnSecurityDialog = &He85
  251. Const adwrnSecurityDialogHeader = &He86
  252. Const adErrIntegrityViolation = &He87
  253. Const adErrPermissionDenied = &He88
  254. Const adErrDataOverflow = &He89
  255. Const adErrSchemaViolation = &He8a
  256. Const adErrSignMismatch = &He8b
  257. Const adErrCantConvertvalue = &He8c
  258. Const adErrCantCreate = &He8d
  259. Const adErrColumnNotOnThisRow = &He8e
  260. Const adErrURLIntegrViolSetColumns = &He8f
  261. Const adErrURLDoesNotExist = &He8f
  262. Const adErrTreePermissionDenied = &He90
  263. Const adErrInvalidURL = &He91
  264. Const adErrResourceLocked = &He92
  265. Const adErrResourceExists = &He93
  266. Const adErrCannotComplete = &He94
  267. Const adErrVolumeNotFound = &He95
  268. Const adErrOutOfSpace = &He96
  269. Const adErrResourceOutOfScope = &He97
  270. Const adErrUnavailable = &He98
  271. Const adErrURLNamedRowDoesNotExist = &He99
  272. Const adErrDelResOutOfScope = &He9a
  273. Const adErrPropInvalidColumn = &He9b
  274. Const adErrPropInvalidOption = &He9c
  275. Const adErrPropInvalidValue = &He9d
  276. Const adErrPropConflicting = &He9e
  277. Const adErrPropNotAllSettable = &He9f
  278. Const adErrPropNotSet = &Hea0
  279. Const adErrPropNotSettable = &Hea1
  280. Const adErrPropNotSupported = &Hea2
  281. Const adErrCatalogNotSet = &Hea3
  282. Const adErrCantChangeConnection = &Hea4
  283. Const adErrFieldsUpdateFailed = &Hea5
  284. Const adErrDenyNotSupported = &Hea6
  285. Const adErrDenyTypeNotSupported = &Hea7
  286. Const adErrProviderNotSpecified = &Hea9
  287. Const adErrConnectionStringTooLong = &Heaa
  288. '---- ParameterAttributesEnum Values ----
  289. Const adParamSigned = &H0010
  290. Const adParamNullable = &H0040
  291. Const adParamLong = &H0080
  292. '---- ParameterDirectionEnum Values ----
  293. Const adParamUnknown = &H0000
  294. Const adParamInput = &H0001
  295. Const adParamOutput = &H0002
  296. Const adParamInputOutput = &H0003
  297. Const adParamReturnValue = &H0004
  298. '---- CommandTypeEnum Values ----
  299. Const adCmdUnknown = &H0008
  300. Const adCmdText = &H0001
  301. Const adCmdTable = &H0002
  302. Const adCmdStoredProc = &H0004
  303. Const adCmdFile = &H0100
  304. Const adCmdTableDirect = &H0200
  305. '---- EventStatusEnum Values ----
  306. Const adStatusOK = &H0000001
  307. Const adStatusErrorsOccurred = &H0000002
  308. Const adStatusCantDeny = &H0000003
  309. Const adStatusCancel = &H0000004
  310. Const adStatusUnwantedEvent = &H0000005
  311. '---- EventReasonEnum Values ----
  312. Const adRsnAddNew = 1
  313. Const adRsnDelete = 2
  314. Const adRsnUpdate = 3
  315. Const adRsnUndoUpdate = 4
  316. Const adRsnUndoAddNew = 5
  317. Const adRsnUndoDelete = 6
  318. Const adRsnRequery = 7
  319. Const adRsnResynch = 8
  320. Const adRsnClose = 9
  321. Const adRsnMove = 10
  322. Const adRsnFirstChange = 11
  323. Const adRsnMoveFirst = 12
  324. Const adRsnMoveNext = 13
  325. Const adRsnMovePrevious = 14
  326. Const adRsnMoveLast = 15
  327. '---- SchemaEnum Values ----
  328. Const adSchemaProviderSpecific = -1
  329. Const adSchemaAsserts = 0
  330. Const adSchemaCatalogs = 1
  331. Const adSchemaCharacterSets = 2
  332. Const adSchemaCollations = 3
  333. Const adSchemaColumns = 4
  334. Const adSchemaCheckConstraints = 5
  335. Const adSchemaConstraintColumnUsage = 6
  336. Const adSchemaConstraintTableUsage = 7
  337. Const adSchemaKeyColumnUsage = 8
  338. Const adSchemaReferentialConstraints = 9
  339. Const adSchemaTableConstraints = 10
  340. Const adSchemaColumnsDomainUsage = 11
  341. Const adSchemaIndexes = 12
  342. Const adSchemaColumnPrivileges = 13
  343. Const adSchemaTablePrivileges = 14
  344. Const adSchemaUsagePrivileges = 15
  345. Const adSchemaProcedures = 16
  346. Const adSchemaSchemata = 17
  347. Const adSchemaSQLLanguages = 18
  348. Const adSchemaStatistics = 19
  349. Const adSchemaTables = 20
  350. Const adSchemaTranslations = 21
  351. Const adSchemaProviderTypes = 22
  352. Const adSchemaViews = 23
  353. Const adSchemaViewColumnUsage = 24
  354. Const adSchemaViewTableUsage = 25
  355. Const adSchemaProcedureParameters = 26
  356. Const adSchemaForeignKeys = 27
  357. Const adSchemaPrimaryKeys = 28
  358. Const adSchemaProcedureColumns = 29
  359. Const adSchemaDBInfoKeywords = 30
  360. Const adSchemaDBInfoLiterals = 31
  361. Const adSchemaCubes = 32
  362. Const adSchemaDimensions = 33
  363. Const adSchemaHierarchies = 34
  364. Const adSchemaLevels = 35
  365. Const adSchemaMeasures = 36
  366. Const adSchemaProperties = 37
  367. Const adSchemaMembers = 38
  368. Const adSchemaTrustees = 39
  369. Const adSchemaFunctions = 40
  370. Const adSchemaActions = 41
  371. Const adSchemaCommands = 42
  372. Const adSchemaSets = 43
  373. '---- FieldStatusEnum Values ----
  374. Const adFieldOK = 0
  375. Const adFieldCantConvertValue = 2
  376. Const adFieldIsNull = 3
  377. Const adFieldTruncated = 4
  378. Const adFieldSignMismatch = 5
  379. Const adFieldDataOverflow = 6
  380. Const adFieldCantCreate = 7
  381. Const adFieldUnavailable = 8
  382. Const adFieldPermissionDenied = 9
  383. Const adFieldIntegrityViolation = 10
  384. Const adFieldSchemaViolation = 11
  385. Const adFieldBadStatus = 12
  386. Const adFieldDefault = 13
  387. Const adFieldIgnore = 15
  388. Const adFieldDoesNotExist = 16
  389. Const adFieldInvalidURL = 17
  390. Const adFieldResourceLocked = 18
  391. Const adFieldResourceExists = 19
  392. Const adFieldCannotComplete = 20
  393. Const adFieldVolumeNotFound = 21
  394. Const adFieldOutOfSpace = 22
  395. Const adFieldCannotDeleteSource = 23
  396. Const adFieldReadOnly = 24
  397. Const adFieldResourceOutOfScope = 25
  398. Const adFieldAlreadyExists = 26
  399. Const adFieldPendingInsert = &H10000
  400. Const adFieldPendingDelete = &H20000
  401. Const adFieldPendingChange = &H40000
  402. Const adFieldPendingUnknown = &H80000
  403. Const adFieldPendingUnknownDelete = &H100000
  404. '---- SeekEnum Values ----
  405. Const adSeekFirstEQ = &H1
  406. Const adSeekLastEQ = &H2
  407. Const adSeekAfterEQ = &H4
  408. Const adSeekAfter = &H8
  409. Const adSeekBeforeEQ = &H10
  410. Const adSeekBefore = &H20
  411. '---- ADCPROP_UPDATECRITERIA_ENUM Values ----
  412. Const adCriteriaKey = 0
  413. Const adCriteriaAllCols = 1
  414. Const adCriteriaUpdCols = 2
  415. Const adCriteriaTimeStamp = 3
  416. '---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----
  417. Const adPriorityLowest = 1
  418. Const adPriorityBelowNormal = 2
  419. Const adPriorityNormal = 3
  420. Const adPriorityAboveNormal = 4
  421. Const adPriorityHighest = 5
  422. '---- ADCPROP_AUTORECALC_ENUM Values ----
  423. Const adRecalcUpFront = 0
  424. Const adRecalcAlways = 1
  425. '---- ADCPROP_UPDATERESYNC_ENUM Values ----
  426. Const adResyncNone = 0
  427. Const adResyncAutoIncrement = 1
  428. Const adResyncConflicts = 2
  429. Const adResyncUpdates = 4
  430. Const adResyncInserts = 8
  431. Const adResyncAll = 15
  432. '---- MoveRecordOptionsEnum Values ----
  433. Const adMoveUnspecified = -1
  434. Const adMoveOverWrite = 1
  435. Const adMoveDontUpdateLinks = 2
  436. Const adMoveAllowEmulation = 4
  437. '---- CopyRecordOptionsEnum Values ----
  438. Const adCopyUnspecified = -1
  439. Const adCopyOverWrite = 1
  440. Const adCopyAllowEmulation = 4
  441. Const adCopyNonRecursive = 2
  442. '---- StreamTypeEnum Values ----
  443. Const adTypeBinary = 1
  444. Const adTypeText = 2
  445. '---- LineSeparatorEnum Values ----
  446. Const adLF = 10
  447. Const adCR = 13
  448. Const adCRLF = -1
  449. '---- StreamOpenOptionsEnum Values ----
  450. Const adOpenStreamUnspecified = -1
  451. Const adOpenStreamAsync = 1
  452. Const adOpenStreamFromRecord = 4
  453. '---- StreamWriteEnum Values ----
  454. Const adWriteChar = 0
  455. Const adWriteLine = 1
  456. '---- SaveOptionsEnum Values ----
  457. Const adSaveCreateNotExist = 1
  458. Const adSaveCreateOverWrite = 2
  459. '---- FieldEnum Values ----
  460. Const adDefaultStream = -1
  461. Const adRecordURL = -2
  462. '---- StreamReadEnum Values ----
  463. Const adReadAll = -1
  464. Const adReadLine = -2
  465. '---- RecordTypeEnum Values ----
  466. Const adSimpleRecord = 0
  467. Const adCollectionRecord = 1
  468. Const adStructDoc = 2
  469. %>