adovbs.inc 14 KB

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