| 33 |
ghuddy |
1 |
<%
|
|
|
2 |
'--------------------------------------------------------------------
|
|
|
3 |
' Microsoft ADO
|
|
|
4 |
'
|
|
|
5 |
' (c) 1996-1998 Microsoft Corporation. All Rights Reserved.
|
|
|
6 |
'
|
|
|
7 |
'
|
|
|
8 |
'
|
|
|
9 |
' ADO constants include file for VBScript
|
|
|
10 |
'
|
|
|
11 |
'--------------------------------------------------------------------
|
|
|
12 |
|
|
|
13 |
'---- CursorTypeEnum Values ----
|
|
|
14 |
Const adOpenForwardOnly = 0
|
|
|
15 |
Const adOpenKeyset = 1
|
|
|
16 |
Const adOpenDynamic = 2
|
|
|
17 |
Const adOpenStatic = 3
|
|
|
18 |
|
|
|
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 |
|
|
|
34 |
'---- LockTypeEnum Values ----
|
|
|
35 |
Const adLockReadOnly = 1
|
|
|
36 |
Const adLockPessimistic = 2
|
|
|
37 |
Const adLockOptimistic = 3
|
|
|
38 |
Const adLockBatchOptimistic = 4
|
|
|
39 |
|
|
|
40 |
'---- ExecuteOptionEnum Values ----
|
|
|
41 |
Const adRunAsync = &H00000010
|
|
|
42 |
Const adAsyncExecute = &H00000010
|
|
|
43 |
Const adAsyncFetch = &H00000020
|
|
|
44 |
Const adAsyncFetchNonBlocking = &H00000040
|
|
|
45 |
Const adExecuteNoRecords = &H00000080
|
|
|
46 |
|
|
|
47 |
'---- ConnectOptionEnum Values ----
|
|
|
48 |
Const adAsyncConnect = &H00000010
|
|
|
49 |
|
|
|
50 |
'---- ObjectStateEnum Values ----
|
|
|
51 |
Const adStateClosed = &H00000000
|
|
|
52 |
Const adStateOpen = &H00000001
|
|
|
53 |
Const adStateConnecting = &H00000002
|
|
|
54 |
Const adStateExecuting = &H00000004
|
|
|
55 |
Const adStateFetching = &H00000008
|
|
|
56 |
|
|
|
57 |
'---- CursorLocationEnum Values ----
|
|
|
58 |
Const adUseServer = 2
|
|
|
59 |
Const adUseClient = 3
|
|
|
60 |
|
|
|
61 |
'---- DataTypeEnum Values ----
|
|
|
62 |
Const adEmpty = 0
|
|
|
63 |
Const adTinyInt = 16
|
|
|
64 |
Const adSmallInt = 2
|
|
|
65 |
Const adInteger = 3
|
|
|
66 |
Const adBigInt = 20
|
|
|
67 |
Const adUnsignedTinyInt = 17
|
|
|
68 |
Const adUnsignedSmallInt = 18
|
|
|
69 |
Const adUnsignedInt = 19
|
|
|
70 |
Const adUnsignedBigInt = 21
|
|
|
71 |
Const adSingle = 4
|
|
|
72 |
Const adDouble = 5
|
|
|
73 |
Const adCurrency = 6
|
|
|
74 |
Const adDecimal = 14
|
|
|
75 |
Const adNumeric = 131
|
|
|
76 |
Const adBoolean = 11
|
|
|
77 |
Const adError = 10
|
|
|
78 |
Const adUserDefined = 132
|
|
|
79 |
Const adVariant = 12
|
|
|
80 |
Const adIDispatch = 9
|
|
|
81 |
Const adIUnknown = 13
|
|
|
82 |
Const adGUID = 72
|
|
|
83 |
Const adDate = 7
|
|
|
84 |
Const adDBDate = 133
|
|
|
85 |
Const adDBTime = 134
|
|
|
86 |
Const adDBTimeStamp = 135
|
|
|
87 |
Const adBSTR = 8
|
|
|
88 |
Const adChar = 129
|
|
|
89 |
Const adVarChar = 200
|
|
|
90 |
Const adLongVarChar = 201
|
|
|
91 |
Const adWChar = 130
|
|
|
92 |
Const adVarWChar = 202
|
|
|
93 |
Const adLongVarWChar = 203
|
|
|
94 |
Const adBinary = 128
|
|
|
95 |
Const adVarBinary = 204
|
|
|
96 |
Const adLongVarBinary = 205
|
|
|
97 |
Const adChapter = 136
|
|
|
98 |
Const adFileTime = 64
|
|
|
99 |
Const adDBFileTime = 137
|
|
|
100 |
Const adPropVariant = 138
|
|
|
101 |
Const adVarNumeric = 139
|
|
|
102 |
|
|
|
103 |
'---- FieldAttributeEnum Values ----
|
|
|
104 |
Const adFldMayDefer = &H00000002
|
|
|
105 |
Const adFldUpdatable = &H00000004
|
|
|
106 |
Const adFldUnknownUpdatable = &H00000008
|
|
|
107 |
Const adFldFixed = &H00000010
|
|
|
108 |
Const adFldIsNullable = &H00000020
|
|
|
109 |
Const adFldMayBeNull = &H00000040
|
|
|
110 |
Const adFldLong = &H00000080
|
|
|
111 |
Const adFldRowID = &H00000100
|
|
|
112 |
Const adFldRowVersion = &H00000200
|
|
|
113 |
Const adFldCacheDeferred = &H00001000
|
|
|
114 |
Const adFldKeyColumn = &H00008000
|
|
|
115 |
|
|
|
116 |
'---- EditModeEnum Values ----
|
|
|
117 |
Const adEditNone = &H0000
|
|
|
118 |
Const adEditInProgress = &H0001
|
|
|
119 |
Const adEditAdd = &H0002
|
|
|
120 |
Const adEditDelete = &H0004
|
|
|
121 |
|
|
|
122 |
'---- RecordStatusEnum Values ----
|
|
|
123 |
Const adRecOK = &H0000000
|
|
|
124 |
Const adRecNew = &H0000001
|
|
|
125 |
Const adRecModified = &H0000002
|
|
|
126 |
Const adRecDeleted = &H0000004
|
|
|
127 |
Const adRecUnmodified = &H0000008
|
|
|
128 |
Const adRecInvalid = &H0000010
|
|
|
129 |
Const adRecMultipleChanges = &H0000040
|
|
|
130 |
Const adRecPendingChanges = &H0000080
|
|
|
131 |
Const adRecCanceled = &H0000100
|
|
|
132 |
Const adRecCantRelease = &H0000400
|
|
|
133 |
Const adRecConcurrencyViolation = &H0000800
|
|
|
134 |
Const adRecIntegrityViolation = &H0001000
|
|
|
135 |
Const adRecMaxChangesExceeded = &H0002000
|
|
|
136 |
Const adRecObjectOpen = &H0004000
|
|
|
137 |
Const adRecOutOfMemory = &H0008000
|
|
|
138 |
Const adRecPermissionDenied = &H0010000
|
|
|
139 |
Const adRecSchemaViolation = &H0020000
|
|
|
140 |
Const adRecDBDeleted = &H0040000
|
|
|
141 |
|
|
|
142 |
'---- GetRowsOptionEnum Values ----
|
|
|
143 |
Const adGetRowsRest = -1
|
|
|
144 |
|
|
|
145 |
'---- PositionEnum Values ----
|
|
|
146 |
Const adPosUnknown = -1
|
|
|
147 |
Const adPosBOF = -2
|
|
|
148 |
Const adPosEOF = -3
|
|
|
149 |
|
|
|
150 |
'---- enum Values ----
|
|
|
151 |
Const adBookmarkCurrent = 0
|
|
|
152 |
Const adBookmarkFirst = 1
|
|
|
153 |
Const adBookmarkLast = 2
|
|
|
154 |
|
|
|
155 |
'---- MarshalOptionsEnum Values ----
|
|
|
156 |
Const adMarshalAll = 0
|
|
|
157 |
Const adMarshalModifiedOnly = 1
|
|
|
158 |
|
|
|
159 |
'---- AffectEnum Values ----
|
|
|
160 |
Const adAffectCurrent = 1
|
|
|
161 |
Const adAffectGroup = 2
|
|
|
162 |
Const adAffectAll = 3
|
|
|
163 |
Const adAffectAllChapters = 4
|
|
|
164 |
|
|
|
165 |
'---- ResyncEnum Values ----
|
|
|
166 |
Const adResyncUnderlyingValues = 1
|
|
|
167 |
Const adResyncAllValues = 2
|
|
|
168 |
|
|
|
169 |
'---- CompareEnum Values ----
|
|
|
170 |
Const adCompareLessThan = 0
|
|
|
171 |
Const adCompareEqual = 1
|
|
|
172 |
Const adCompareGreaterThan = 2
|
|
|
173 |
Const adCompareNotEqual = 3
|
|
|
174 |
Const adCompareNotComparable = 4
|
|
|
175 |
|
|
|
176 |
'---- FilterGroupEnum Values ----
|
|
|
177 |
Const adFilterNone = 0
|
|
|
178 |
Const adFilterPendingRecords = 1
|
|
|
179 |
Const adFilterAffectedRecords = 2
|
|
|
180 |
Const adFilterFetchedRecords = 3
|
|
|
181 |
Const adFilterPredicate = 4
|
|
|
182 |
Const adFilterConflictingRecords = 5
|
|
|
183 |
|
|
|
184 |
'---- SearchDirectionEnum Values ----
|
|
|
185 |
Const adSearchForward = 1
|
|
|
186 |
Const adSearchBackward = -1
|
|
|
187 |
|
|
|
188 |
'---- PersistFormatEnum Values ----
|
|
|
189 |
Const adPersistADTG = 0
|
|
|
190 |
Const adPersistXML = 1
|
|
|
191 |
|
|
|
192 |
'---- StringFormatEnum Values ----
|
|
|
193 |
Const adStringXML = 0
|
|
|
194 |
Const adStringHTML = 1
|
|
|
195 |
Const adClipString = 2
|
|
|
196 |
|
|
|
197 |
'---- ConnectPromptEnum Values ----
|
|
|
198 |
Const adPromptAlways = 1
|
|
|
199 |
Const adPromptComplete = 2
|
|
|
200 |
Const adPromptCompleteRequired = 3
|
|
|
201 |
Const adPromptNever = 4
|
|
|
202 |
|
|
|
203 |
'---- ConnectModeEnum Values ----
|
|
|
204 |
Const adModeUnknown = 0
|
|
|
205 |
Const adModeRead = 1
|
|
|
206 |
Const adModeWrite = 2
|
|
|
207 |
Const adModeReadWrite = 3
|
|
|
208 |
Const adModeShareDenyRead = 4
|
|
|
209 |
Const adModeShareDenyWrite = 8
|
|
|
210 |
Const adModeShareExclusive = &Hc
|
|
|
211 |
Const adModeShareDenyNone = &H10
|
|
|
212 |
|
|
|
213 |
'---- IsolationLevelEnum Values ----
|
|
|
214 |
Const adXactUnspecified = &Hffffffff
|
|
|
215 |
Const adXactChaos = &H00000010
|
|
|
216 |
Const adXactReadUncommitted = &H00000100
|
|
|
217 |
Const adXactBrowse = &H00000100
|
|
|
218 |
Const adXactCursorStability = &H00001000
|
|
|
219 |
Const adXactReadCommitted = &H00001000
|
|
|
220 |
Const adXactRepeatableRead = &H00010000
|
|
|
221 |
Const adXactSerializable = &H00100000
|
|
|
222 |
Const adXactIsolated = &H00100000
|
|
|
223 |
|
|
|
224 |
'---- XactAttributeEnum Values ----
|
|
|
225 |
Const adXactCommitRetaining = &H00020000
|
|
|
226 |
Const adXactAbortRetaining = &H00040000
|
|
|
227 |
|
|
|
228 |
'---- PropertyAttributesEnum Values ----
|
|
|
229 |
Const adPropNotSupported = &H0000
|
|
|
230 |
Const adPropRequired = &H0001
|
|
|
231 |
Const adPropOptional = &H0002
|
|
|
232 |
Const adPropRead = &H0200
|
|
|
233 |
Const adPropWrite = &H0400
|
|
|
234 |
|
|
|
235 |
'---- ErrorValueEnum Values ----
|
|
|
236 |
Const adErrInvalidArgument = &Hbb9
|
|
|
237 |
Const adErrNoCurrentRecord = &Hbcd
|
|
|
238 |
Const adErrIllegalOperation = &Hc93
|
|
|
239 |
Const adErrInTransaction = &Hcae
|
|
|
240 |
Const adErrFeatureNotAvailable = &Hcb3
|
|
|
241 |
Const adErrItemNotFound = &Hcc1
|
|
|
242 |
Const adErrObjectInCollection = &Hd27
|
|
|
243 |
Const adErrObjectNotSet = &Hd5c
|
|
|
244 |
Const adErrDataConversion = &Hd5d
|
|
|
245 |
Const adErrObjectClosed = &He78
|
|
|
246 |
Const adErrObjectOpen = &He79
|
|
|
247 |
Const adErrProviderNotFound = &He7a
|
|
|
248 |
Const adErrBoundToCommand = &He7b
|
|
|
249 |
Const adErrInvalidParamInfo = &He7c
|
|
|
250 |
Const adErrInvalidConnection = &He7d
|
|
|
251 |
Const adErrNotReentrant = &He7e
|
|
|
252 |
Const adErrStillExecuting = &He7f
|
|
|
253 |
Const adErrOperationCancelled = &He80
|
|
|
254 |
Const adErrStillConnecting = &He81
|
|
|
255 |
Const adErrNotExecuting = &He83
|
|
|
256 |
Const adErrUnsafeOperation = &He84
|
|
|
257 |
|
|
|
258 |
'---- ParameterAttributesEnum Values ----
|
|
|
259 |
Const adParamSigned = &H0010
|
|
|
260 |
Const adParamNullable = &H0040
|
|
|
261 |
Const adParamLong = &H0080
|
|
|
262 |
|
|
|
263 |
'---- ParameterDirectionEnum Values ----
|
|
|
264 |
Const adParamUnknown = &H0000
|
|
|
265 |
Const adParamInput = &H0001
|
|
|
266 |
Const adParamOutput = &H0002
|
|
|
267 |
Const adParamInputOutput = &H0003
|
|
|
268 |
Const adParamReturnValue = &H0004
|
|
|
269 |
|
|
|
270 |
'---- CommandTypeEnum Values ----
|
|
|
271 |
Const adCmdUnknown = &H0008
|
|
|
272 |
Const adCmdText = &H0001
|
|
|
273 |
Const adCmdTable = &H0002
|
|
|
274 |
Const adCmdStoredProc = &H0004
|
|
|
275 |
Const adCmdFile = &H0100
|
|
|
276 |
Const adCmdTableDirect = &H0200
|
|
|
277 |
|
|
|
278 |
'---- EventStatusEnum Values ----
|
|
|
279 |
Const adStatusOK = &H0000001
|
|
|
280 |
Const adStatusErrorsOccurred = &H0000002
|
|
|
281 |
Const adStatusCantDeny = &H0000003
|
|
|
282 |
Const adStatusCancel = &H0000004
|
|
|
283 |
Const adStatusUnwantedEvent = &H0000005
|
|
|
284 |
|
|
|
285 |
'---- EventReasonEnum Values ----
|
|
|
286 |
Const adRsnAddNew = 1
|
|
|
287 |
Const adRsnDelete = 2
|
|
|
288 |
Const adRsnUpdate = 3
|
|
|
289 |
Const adRsnUndoUpdate = 4
|
|
|
290 |
Const adRsnUndoAddNew = 5
|
|
|
291 |
Const adRsnUndoDelete = 6
|
|
|
292 |
Const adRsnRequery = 7
|
|
|
293 |
Const adRsnResynch = 8
|
|
|
294 |
Const adRsnClose = 9
|
|
|
295 |
Const adRsnMove = 10
|
|
|
296 |
Const adRsnFirstChange = 11
|
|
|
297 |
Const adRsnMoveFirst = 12
|
|
|
298 |
Const adRsnMoveNext = 13
|
|
|
299 |
Const adRsnMovePrevious = 14
|
|
|
300 |
Const adRsnMoveLast = 15
|
|
|
301 |
|
|
|
302 |
'---- SchemaEnum Values ----
|
|
|
303 |
Const adSchemaProviderSpecific = -1
|
|
|
304 |
Const adSchemaAsserts = 0
|
|
|
305 |
Const adSchemaCatalogs = 1
|
|
|
306 |
Const adSchemaCharacterSets = 2
|
|
|
307 |
Const adSchemaCollations = 3
|
|
|
308 |
Const adSchemaColumns = 4
|
|
|
309 |
Const adSchemaCheckConstraints = 5
|
|
|
310 |
Const adSchemaConstraintColumnUsage = 6
|
|
|
311 |
Const adSchemaConstraintTableUsage = 7
|
|
|
312 |
Const adSchemaKeyColumnUsage = 8
|
|
|
313 |
Const adSchemaReferentialConstraints = 9
|
|
|
314 |
Const adSchemaTableConstraints = 10
|
|
|
315 |
Const adSchemaColumnsDomainUsage = 11
|
|
|
316 |
Const adSchemaIndexes = 12
|
|
|
317 |
Const adSchemaColumnPrivileges = 13
|
|
|
318 |
Const adSchemaTablePrivileges = 14
|
|
|
319 |
Const adSchemaUsagePrivileges = 15
|
|
|
320 |
Const adSchemaProcedures = 16
|
|
|
321 |
Const adSchemaSchemata = 17
|
|
|
322 |
Const adSchemaSQLLanguages = 18
|
|
|
323 |
Const adSchemaStatistics = 19
|
|
|
324 |
Const adSchemaTables = 20
|
|
|
325 |
Const adSchemaTranslations = 21
|
|
|
326 |
Const adSchemaProviderTypes = 22
|
|
|
327 |
Const adSchemaViews = 23
|
|
|
328 |
Const adSchemaViewColumnUsage = 24
|
|
|
329 |
Const adSchemaViewTableUsage = 25
|
|
|
330 |
Const adSchemaProcedureParameters = 26
|
|
|
331 |
Const adSchemaForeignKeys = 27
|
|
|
332 |
Const adSchemaPrimaryKeys = 28
|
|
|
333 |
Const adSchemaProcedureColumns = 29
|
|
|
334 |
Const adSchemaDBInfoKeywords = 30
|
|
|
335 |
Const adSchemaDBInfoLiterals = 31
|
|
|
336 |
Const adSchemaCubes = 32
|
|
|
337 |
Const adSchemaDimensions = 33
|
|
|
338 |
Const adSchemaHierarchies = 34
|
|
|
339 |
Const adSchemaLevels = 35
|
|
|
340 |
Const adSchemaMeasures = 36
|
|
|
341 |
Const adSchemaProperties = 37
|
|
|
342 |
Const adSchemaMembers = 38
|
|
|
343 |
|
|
|
344 |
'---- SeekEnum Values ----
|
|
|
345 |
Const adSeekFirstEQ = &H1
|
|
|
346 |
Const adSeekLastEQ = &H2
|
|
|
347 |
Const adSeekAfterEQ = &H4
|
|
|
348 |
Const adSeekAfter = &H8
|
|
|
349 |
Const adSeekBeforeEQ = &H10
|
|
|
350 |
Const adSeekBefore = &H20
|
|
|
351 |
|
|
|
352 |
'---- ADCPROP_UPDATECRITERIA_ENUM Values ----
|
|
|
353 |
Const adCriteriaKey = 0
|
|
|
354 |
Const adCriteriaAllCols = 1
|
|
|
355 |
Const adCriteriaUpdCols = 2
|
|
|
356 |
Const adCriteriaTimeStamp = 3
|
|
|
357 |
|
|
|
358 |
'---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----
|
|
|
359 |
Const adPriorityLowest = 1
|
|
|
360 |
Const adPriorityBelowNormal = 2
|
|
|
361 |
Const adPriorityNormal = 3
|
|
|
362 |
Const adPriorityAboveNormal = 4
|
|
|
363 |
Const adPriorityHighest = 5
|
|
|
364 |
|
|
|
365 |
'---- CEResyncEnum Values ----
|
|
|
366 |
Const adResyncNone = 0
|
|
|
367 |
Const adResyncAutoIncrement = 1
|
|
|
368 |
Const adResyncConflicts = 2
|
|
|
369 |
Const adResyncUpdates = 4
|
|
|
370 |
Const adResyncInserts = 8
|
|
|
371 |
Const adResyncAll = 15
|
|
|
372 |
|
|
|
373 |
'---- ADCPROP_AUTORECALC_ENUM Values ----
|
|
|
374 |
Const adRecalcUpFront = 0
|
|
|
375 |
Const adRecalcAlways = 1
|
|
|
376 |
%>
|