<%
'------------------------------------- -------------------
'Microsoft ADO
'
'CopyRight (C) 1996-1998 Microsoft Corporation.
'
'
'
'Ado Constants include file for VBScript
'
'------------------------------------- -------------------
'---- CURSORTYPEENUM VALUES -------
Const adopenforwardonly = 0
Const adopenkeyset = 1
Const adopendynamic = 2
Const adopenStatic = 3
'---- Cursoroptionenum VALUES ----
Const adholdrecords = & h00000100
Const admoveprevious = & h00000200
Const adaddnew = & h01000400
Const Addelete = & H01000800
Const adupdate = & h01008000
Const Adbookmark = & H00002000
Const adapproxposition = & h00004000
Const adupdatebatch = & h00010000
Const adresync = & H00020000
Const adnotify = & h00040000
Const adfind = & H00080000
Const Adseek = & H00400000
Const Adindex = & H00800000
'---- LockTyPeenum Values ----
Const AdlockReadonly = 1
Const AdlockPESSIMISTIC = 2
Const AdlockOptimistic = 3
Const AdlockBatchOptimistic = 4
'---- ExecuteOptionENum Values ----
Const Adasyncexecute = & H00000010
Const AdasyncFetch = & H00000020
Const adasyncfetchnonblocking = & h00000040
Const adexecutenorecords = & h00000080
Const adexecutestream = & h00000400
'---- ConnectOptionenum Values ----
Const AdasyncConnect = & H00000010
'---- ObjectStateEnum Values ----
Const adstateclosed = & h00000000
Const adstateopen = & h00000001
Const adstateConnecting = & H00000002
Const adstateexecuting = & h00000004
Const adstatefetching = & h00000008 '---- CursorLocationNum VALUES ----
Const aduseserver = 2
Const aduseclient = 3
'---- DatatyPeenum Values ----
Const adempty = 0
Const ADTINT = 16
Const adsmallint = 2
Const adinteger = 3
Const adbigint = 20
Const adunsignedtinyint = 17
Const adunsignedsmallint = 18
Const adunsignedint = 19
Const adunsignedbigint = 21
Const Adsingle = 4
Const addouble = 5
Const adcurrency = 6
Const addECIMAL = 14
Const adnumeric = 131
Const adboolean = 11
Const adriot = 10
Const adusefined = 132
Const Advariant = 12
Const adidispatch = 9
Const adiunknown = 13
Const adguid = 72
Const addate = 7
Const addbdate = 133
Const addbtime = 134
Const addbtimestamp = 135
Const adbstr = 8
Const adchar = 129
Const advarchar = 200
Const adlongvarchar = 201
Const Adwchar = 130
Const advarwchar = 202
Const Adlongvarwchar = 203
Const adbinary = 128
Const Advarbinary = 204
Const AdlongVarbinary = 205
Const adchapter = 136
Const adfiletime = 64
Const adpropvariant = 138
Const advarnumeric = 139
Const Adaray = & H2000
'---- FieldattributeEnum VALUES ----
Const AdfldMaydefer = & H00000002
Const adfldupdatable = & h00000004
Const AdfldunknownUpdatable = & H00000008
Const adfldfixed = & h00000010
Const Adfldisnullable = & H00000020
Const AdfldMayBenull = & H00000040
Const adfldlong = & h00000080
Const adfldrowid = & h00000100
Const AdfldrowVersion = & H00000200
Const adfldcachedeferred = & h00001000
Const adfldischapter = & h00002000const adfldnegativescale = & H00004000
Const adfldkeycolumn = & h00008000
Const Adfldismrowurl = & H00010000
Const AdfldisDefaultStream = & H00020000
Const Adfldiscollection = & H00040000
'---- EditModeenum VALUES ----
Const AdedNone = & H0000
Const AdeInProgress = & H0001
Const Adeditadd = & H0002
Const Adededelete = & H0004
'---- RecordStatusenum VALUES ----
Const Adrecok = & H0000000
Const Adrecnew = & H0000001
Const adrecmodified = & h0000002
Const adrecdeled = & h0000004
Const adrecunmodified = & h0000008
Const adrecative = & h0000010
Const adrecmultiplechanges = & h0000040
Const adrecpendingchange = & h0000080
Const adrecanceled = & h0000100
Const adreccantrelease = & h0000400
Const adreconcurrencyviolation = & h0000800
Const adrecintegrityviolation = & h0001000
Const adrecmaxchangesexceedededed = & H0002000
Const adrecobjectopen = & h0004000
Const adrecOutofMemory = & H0008000
Const adrecPermissionDenied = & H0010000
Const adrecschemaviolation = & h0020000
Const adrecdbdeleted = & h0040000
'---- GetRowSoptionenum VALUES ----
Const adgetrowsrest = -1
'---- Positionenum VALUES ----
Const adposunknown = -1
Const adposbof = -2
Const adposeof = -3
'---- Bookmarkenum Values ----
Const adbookmarkcurrent = 0
Const adbookmarkfirst = 1
Const adbookmarklast = 2
'---- Marshaloptionsenum VALUES ------
Const admarshalall = 0
Const Admarshalmodifiedonly = 1
'---- Affectenum VALUES ----
Const adAffectCurrent = 1const AdaffectGroup = 2
Const adAffectallchapters = 4
'---- RESYNCENUM VALUES ------
Const adresyncunderlyingValues = 1
Const adresyncallvalues = 2
'---- Comparenum Values ----
Const adcomparelessthan = 0
Const adcompareequal = 1
Const adcompareGreaterthan = 2
Const adcomparenotequal = 3
Const adcomparenotcomparable = 4
'---- Filtergroupenum Values ----
Const adfilternne = 0
Const AdfilterpendingRecords = 1
Const AdfilteraffectedRecords = 2
Const AdfilterFetchedRecords = 3
Const AdfilterConflictingRecords = 5
'---- SearchDirectionNum Values ----
Const adsserchforward = 1
Const adsearchbackward = -1
'---- PersistFormatenum VALUES ----
Const adpersistadtg = 0
Const adpersistxml = 1
'---- StringFormatenum VALUES ------
Const adclipstring = 2
'---- ConnectPRomptenum Values ----
Const adpromptalways = 1
Const AdpromptComplete = 2
Const adpromptCompleteRequired = 3
Const adpromptnever = 4
'---- ConnectModeenum VALUES ----
Const admodeunknown = 0
Const admoderead = 1
Const AdmodeWrite = 2
Const AdmodeReadwrite = 3
Const admodesharedenyread = 4
Const AdmodesharedenyWrite = 8
Const AdmodesharexClusive = & HC
Const Admodesharedenynne = & H10
Const AdmodeRecursive = & H400000
'---- RecordcreateOptionSenum VALUES ----
Const adcreatecollection = & h00002000
Const adcreateStructdoc = & h80000000
Const adcreatenoncollection = & h00000000
Const adopenifexists = & h02000000
Const adcreateoverWrite = & H04000000
Const adfailifnotexists = -1
'---- RecordopenOptionsenum Values ---- Const AdopenRecordunSpecified = -1
Const adopenoutput = & H00800000
Const adopenasync = & h00001000
Const addressfetchstream = & h00004000
Const adDelayFetchfields = & h00008000
Const adopnexecuteCommand = & H00010000
'---- Isolationlevelenum Values ----
Const adxactunspecified = & hfffffffff
Const adxactchaos = & h00000010
Const adxactreaduncommitted = & h00000100
Const adxactbrowse = & h00000100
Const adxactcursorse = & h00001000
Const adxactreadCommitted = & H00001000
Const adxactrepeatableread = & h00010000
Const adxactserializable = & h00100000
Const adxactisolated = & h00100000
'---- XACTATTRIBUTEENUM VALUES --------
Const adxactcommitretaining = & H00020000
Const adxactabortretaining = & h00040000
'---- PropertyAttributesenum Values ----
Const adpropnotsupported = & h0000
Const adproprequired = & h0001
Const adpropopptional = & h0002
Const adpropread = & h0200
Const AdpropWrite = & H0400
'---- ErrorValueenum Values ----
Const aderrproviderfailed = & hbb8
Const aderrinvalidargument = & hbb9
Const aderropeningfile = & hbba
Const aderrreadfile = & hbbb
Const aderrwritefile = & hbbc
Const aderrnocurrentRecord = & HBCD
Const aderrillegaloperation = & hc93
Const aderrcantchangeProvider = & hc94
Const aderrintransaction = & hcae
Const aderrfeaturenotavailable = & hcb3
Const adritemnotfound = & hcc1
Const aderrobjectincollection = & hd27
Const aderrobjectNotSet = & HD5C
Const aderrdataaconversion = & hd5dconst aderrobjectclosed = & he78
Const aderrobjectopen = & he79
Const aderrproviderNotFound = & HE7A
Const adrboundtocommand = & he7b
Const aderrinvalidparaminfo = & he7c
Const aderrinvalidConnection = & he7d
Const aderrnotreeTrant = & he7e
Const aderrstillexecuting = & he7f
Const aderroprationcancelled = & he80
Const aderrstillconnecting = & he81
Const aderrinvalidtransaction = & he82
Const adrunsafeoperty = & he84
Const AdWrnsecurityDialog = & HE85
Const AdWrnsecurityDialogheader = & HE86
Const aderrintegrityviolation = & he87
Const aderrpermissiondenid = & he88
Const aderrdataoverflow = & he89
Const adrschemaviolation = & he8a
Const aderrsignmismatch = & he8b
Const aderrcantconvertValue = & he8c
Const aderrcantcreate = & he8d
Const aderrcolumnnotonthisrow = & he8e
Const aderrurlintegrviolsetColumns = & he8f
Const aderrurldoesnotexist = & he8f
Const aderrtreePermissionDenied = & HE90
Const aderrinvalidurl = & he91
Const adrresourceLocked = & he92
Const adrresourceexists = & he93
Const aderrcannotcomplete = & he94
Const aderrvolumenotfound = & he95
Const adroutofspace = & he96
Const adrresourceOutOfscope = & he97
Const aderrunavailable = & he98
Const aderrurnNamedrowDoesNotexist = & HE99
Const aderrdelresoutofscope = & he9a
Const aderrpropinvalidcolumn = & he9b
Const aderrpropinvalidoption = & he9c
Const aderrpropinvalidvalue = & he9d
Const aderrpropconflicting = & he9econst aderrpropNotallSettable = & he9f
Const aderrPropnotSet = & hea0
Const aderrPropnotSettable = & hea1
Const aderrPropnotSupported = & HEA2
Const aderrcatalogNotSet = & hea3
Const aderrcantchangeconnection = & hea4
Const adrfieldsupdatefailed = & hea5
Const adrdenynyNotsupported = & HEA6
Const adrdenytypenotsupported = & HEA7
'---- Parameterattributesenum VALUES --------
Const adparamsigned = & h0010
Const adpaMnullable = & H0040
Const adparamlong = & H0080
'---- ParameterDirectionNum Values ----
Const adparamunknown = & h0000
Const adparaminput = & h0001
Const adparamoutput = & h0002
Const adparaminputOutput = & H0003
Const adparamreturnvalue = & h0004
'---- CommandTyPeenum Values ----
Const adcmdunknown = & h0008
Const adcmdtext = & h0001
Const adcmdtable = & h0002
Const adcmdstoredProc = & H0004
Const adcmdfile = & h0100
Const adcmdtabledirect = & h0200
'---- EventStatusenum VALUES ----
Const adstusok = & h0000001
Const adstatuserrorsoccurred = & h0000002
Const adstuscantdeyle = & h0000003
Const adstuscancel = & h0000004
Const adstatusnunwantedEvent = & H0000005
'---- Eventreasonenum VALUES ----
Const adrsnaddnew = 1
Const adrsndelete = 2
Const adrsnupdate = 3
Const adrsnundOupdate = 4
Const AdrsNundoadDnew = 5
Const adrsNundodelete = 6
Const adrsnrequery = 7
Const adrsnresynch = 8
Const adrsnclose = 9
Const adrsnmove = 10
Const adrsnfirstchange = 11
Const adrsnmovefirst = 12const AdrSnmovenext = 13
Const adrsnmoveprevious = 14
Const adrsnmovelast = 15
'---- Schemaenum VALUES ----
Const adschemaproviderspecific = -1
Const adschemaAsserts = 0
Const Adschemacatalogs = 1
Const adschemachactersets = 2
Const adschemacollations = 3
Const Adschemacolumns = 4
Const adschemacheckconstraints = 5
Const adschemaconstraintColumnUsage = 6
Const AdschemAconstraintTableusage = 7
Const adschemakeycolumnage = 8
Const adschemareferenceialconstraints = 9
Const AdschematableConstraints = 10
Const adschemacolumnsdomainusage = 11
Const adschemaindexes = 12
Const adschemacolumnprivileges = 13
Const AdschematablePrivileges = 14
Const AdschemausagePrivileges = 15
Const adschemaprocedures = 16
Const adschemaschemata = 17
Const Adschemasqllanguages = 18
Const adschemastatics = 19
Const adschematables = 20
Const adschematranslations = 21
Const Adschemaprovidertypes = 22
Const adschemaviews = 23
Const adschemaviewcolumnage = 24
Const adschemaviewTableusage = 25
Const adschemaprocedureparameters = 26
Const adschemaforeIgnys = 27
Const adschemaprimaryKeys = 28
Const AdschemaprocedureColumns = 29
Const Adschemadbinfokeywords = 30
Const adschemadbinfoliterals = 31
Const adschemacubes = 32
Const adschemadimensions = 33
Const adschemahieraceiES = 34
Const adschemalevels = 35
Const adschemaMameasures = 36
Const adschemaproperties = 37
Const adschemamembers = 38
Const adschematrustees = 39
Const adschemafunctions = 40
Const adschemaActions = 41
Const adschemmists = 42const adschemasets = 43
'---- FieldStatusenum Values ----
Const adfieldok = 0
Const AdfieldcantconVertvalue = 2
Const adfieldisnull = 3
Const adfieldtruncated = 4
Const adfieldsignmismatch = 5
Const adfielddataoverflow = 6
Const adfieldcreate = 7
Const adfieldunavailable = 8
Const adfieldpermissiondenid = 9
Const adfieldintegrityviolation = 10
Const adfieldschemaviolation = 11
Const adfieldbadstatus = 12
Const adfielddefault = 13
Const adfieldignore = 15
Const adfielddoesnotexist = 16
Const adfieldinvalidurl = 17
Const adfieldresourceLocked = 18
Const adfieldresourceexists = 19
Const AdfieldCannotcomplete = 20
Const adfieldvolumenotfound = 21
Const adfieldoutofspace = 22
Const adfieldcannotdeletesource = 23
Const adfieldreadonly = 24
Const adfieldResourceOutofscope = 25
Const adfieldalreadyexists = 26
Const adfieldpedinginsert = & h10000
Const adfieldpeddingdelete = & h20000
Const Adfieldped Change = & H40000
Const adfieldpedinknown = & h80000
Const AdfieldingunkNowndelete = & H100000
'---- Seekenum VALUES ------
Const Adzeekfirsteq = & H1
Const Adzeeklasteq = & H2
Const Adzeekaftereq = & H4
Const adseekafter = & h8
Const adseekbeforeeeq = & h10
Const adseekbefore = & h20
'---- ADCPROP_UPDATECRITERIA_ENUM VALUES ----
Const adcrienteriakey = 0
Const adcrienteriaAllCols = 1
Const adcrienteriaupdcols = 2
Const adcrienteriatimestamp = 3
'---- ADCPROP_ASYNCTHREADPRIORITY_ENUM VALUES ----
Const adprioritylowest = 1
Const adpriorityBelownormal = 2const AdpriorityNormal = 3
Const adpriorityabovenormal = 4
Const adpriorityHighest = 5
'---- ADCPROP_AUTORECALC_ENUM VALUES ------
Const adRecalcupfront = 0
Const adRecalCalways = 1
'---- ADCPROP_UPDATERESYNC_ENUM VALUES ----
'---- ADCPROP_UPDATERESYNC_ENUM VALUES ----
'---- MoveRecordoptionsenum Values ----
Const admoveunspecified = -1
Const AdmoveOverWrite = 1
Const AdmovedontUpdatelinks = 2
Const AdmoveAllowemulation = 4
'---- CopyRecordoptionsenum VALUES ----
Const adcopyunspecified = -1
Const adcopyoverwrite = 1
Const adcopyAllowemulation = 4
Const adcopynonrecurs = 2
'---- StreamTyPeenum Values ----
Const adtypebinary = 1
Const adtypetext = 2
'---- LINESEPARUTORENUM VALUES ------
Const ADLF = 10
Const adcr = 13
Const adcrlf = -1
'---- StreamopenOptionsenum Values ----
Const adopenStreamunSpecified = -1
Const adopenstreamasync = 1
Const adopenstreamfromRecord = 4
'---- StreamWriteEnum Values ----
Const AdwriteChar = 0
Const Adwriteline = 1
'---- SaveOptionSenum Values ----
Const adsavecreatenotexist = 1
Const AdaVecreateOverWrite = 2
'---- Fieldenum VALUES ----
Const addefaultstream = -1
Const adRecordurl = -2
'---- StreamReadenum VALUES ----
Const adreadall = -1
Const adreadLine = -2
'---- RecordtyPeenum Values ----
Const adsimpleRecord = 0
Const adcollectionRecord = 1
Const adstructdoc = 2
%>
