动网论坛,站长建站首选,国内使用量最多的论坛软件 动网论坛官方技术讨论区 站长工具 申请属于您自己的免费论坛
首页 | 新闻资讯 | 网站运营 | 网络编程 | 数据库 | 服务器 | 网页设计 | 图像媒体 | 网络应用 | 搜索优化 | 资源下载 | 动网主机 | DVBOX
    本站内  互联网 ASP论坛  ASP.Net论坛  PHP论坛
  
   VBScript → 阅读文章

 ASP经典包含文件(ADO for VBScript)

作者来源: 
阅读 2195 人次 , 2006-4-3 0:01:00 


<%
'--------------------------------------------------------------------
' 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

'---- connectoptionenum values ----
const adasyncconnect = &h00000010

'---- objectstateenum values ----
const adstateclosed = &h00000000
const adstateopen = &h00000001
const adstateconnecting = &h00000002
const adstateexecuting = &h00000004
const adstatefetching = &h00000008

'---- cursorlocationenum values ----
const aduseserver = 2
const aduseclient = 3

'---- datatypeenum values ----
const adempty = 0
const adtinyint = 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 aderror = 10
const aduserdefined = 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 adarray = &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 = &h00002000
const adfldnegativescale = &h00004000
const adfldkeycolumn = &h00008000
const adfldisrowurl = &h00010000
const adfldisdefaultstream = &h00020000
const adfldiscollection = &h00040000

'---- editmodeenum values ----
const adeditnone = &h0000
const adeditinprogress = &h0001
const adeditadd = &h0002
const adeditdelete = &h0004

'---- recordstatusenum values ----
const adrecok = &h0000000
const adrecnew = &h0000001
const adrecmodified = &h0000002
const adrecdeleted = &h0000004
const adrecunmodified = &h0000008
const adrecinvalid = &h0000010
const adrecmultiplechanges = &h0000040
const adrecpendingchanges = &h0000080
const adreccanceled = &h0000100
const adreccantrelease = &h0000400
const adrecconcurrencyviolation = &h0000800
const adrecintegrityviolation = &h0001000
const adrecmaxchangesexceeded = &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 = 1
const adaffectgroup = 2
const adaffectallchapters = 4

'---- resyncenum values ----
const adresyncunderlyingvalues = 1
const adresyncallvalues = 2

'---- compareenum values ----
const adcomparelessthan = 0
const adcompareequal = 1
const adcomparegreaterthan = 2
const adcomparenotequal = 3
const adcomparenotcomparable = 4

'---- filtergroupenum values ----
const adfilternone = 0
const adfilterpendingrecords = 1
const adfilteraffectedrecords = 2
const adfilterfetchedrecords = 3
const adfilterconflictingrecords = 5

'---- searchdirectionenum values ----
const adsearchforward = 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 admodeshareexclusive = &hc
const admodesharedenynone = &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 adopensource = &h00800000
const adopenasync = &h00001000
const addelayfetchstream = &h00004000
const addelayfetchfields = &h00008000

'---- isolationlevelenum values ----
const adxactunspecified = &hffffffff
const adxactchaos = &h00000010
const adxactreaduncommitted = &h00000100
const adxactbrowse = &h00000100
const adxactcursorstability = &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 adpropoptional = &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 aderritemnotfound = &hcc1
const aderrobjectincollection = &hd27
const aderrobjectnotset = &hd5c
const aderrdataconversion = &hd5d
const aderrobjectclosed = &he78
const aderrobjectopen = &he79
const aderrprovidernotfound = &he7a
const aderrboundtocommand = &he7b
const aderrinvalidparaminfo = &he7c
const aderrinvalidconnection = &he7d
const aderrnotreentrant = &he7e
const aderrstillexecuting = &he7f
const aderroperationcancelled = &he80
const aderrstillconnecting = &he81
const aderrinvalidtransaction = &he82
const aderrunsafeoperation = &he84
const adwrnsecuritydialog = &he85
const adwrnsecuritydialogheader = &he86
const aderrintegrityviolation = &he87
const aderrpermissiondenied = &he88
const aderrdataoverflow = &he89
const aderrschemaviolation = &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 aderrresourcelocked = &he92
const aderrresourceexists = &he93
const aderrcannotcomplete = &he94
const aderrvolumenotfound = &he95
const aderroutofspace = &he96
const aderrresourceoutofscope = &he97
const aderrunavailable = &he98
const aderrurlnamedrowdoesnotexist = &he99
const aderrdelresoutofscope = &he9a
const aderrpropinvalidcolumn = &he9b
const aderrpropinvalidoption = &he9c
const aderrpropinvalidvalue = &he9d
const aderrpropconflicting = &he9e
const aderrpropnotallsettable = &he9f
const aderrpropnotset = &hea0
const aderrpropnotsettable = &hea1
const aderrpropnotsupported = &hea2
const aderrcatalognotset = &hea3
const aderrcantchangeconnection = &hea4
const aderrfieldsupdatefailed = &hea5
const aderrdenynotsupported = &hea6
const aderrdenytypenotsupported = &hea7

'---- parameterattributesenum values ----
const adparamsigned = &h0010
const adparamnullable = &h0040
const adparamlong = &h0080

'---- parameterdirectionenum 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 adstatusok = &h0000001
const adstatuserrorsoccurred = &h0000002
const adstatuscantdeny = &h0000003
const adstatuscancel = &h0000004
const adstatusunwantedevent = &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 = 12
const adrsnmovenext = 13
const adrsnmoveprevious = 14
const adrsnmovelast = 15

'---- schemaenum values ----
const adschemaproviderspecific = -1
const adschemaasserts = 0
const adschemacatalogs = 1
const adschemacharactersets = 2
const adschemacollations = 3
const adschemacolumns = 4
const adschemacheckconstraints = 5
const adschemaconstraintcolumnusage = 6
const adschemaconstrainttableusage = 7
const adschemakeycolumnusage = 8
const adschemareferentialconstraints = 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 adschemastatistics = 19
const adschematables = 20
const adschematranslations = 21
const adschemaprovidertypes = 22
const adschemaviews = 23
const adschemaviewcolumnusage = 24
const adschemaviewtableusage = 25
const adschemaprocedureparameters = 26
const adschemaforeignkeys = 27
const adschemaprimarykeys = 28
const adschemaprocedurecolumns = 29
const adschemadbinfokeywords = 30
const adschemadbinfoliterals = 31
const adschemacubes = 32
const adschemadimensions = 33
const adschemahierarchies = 34
const adschemalevels = 35
const adschemameasures = 36
const adschemaproperties = 37
const adschemamembers = 38
const adschematrustees = 39

'---- fieldstatusenum values ----
const adfieldok = 0
const adfieldcantconvertvalue = 2
const adfieldisnull = 3
const adfieldtruncated = 4
const adfieldsignmismatch = 5
const adfielddataoverflow = 6
const adfieldcantcreate = 7
const adfieldunavailable = 8
const adfieldpermissiondenied = 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 adfieldpendinginsert = &h10000
const adfieldpendingdelete = &h20000
const adfieldpendingchange = &h40000
const adfieldpendingunknown = &h80000
const adfieldpendingunknowndelete = &h100000

'---- seekenum values ----
const adseekfirsteq = &h1
const adseeklasteq = &h2
const adseekaftereq = &h4
const adseekafter = &h8
const adseekbeforeeq = &h10
const adseekbefore = &h20

'---- adcprop_updatecriteria_enum values ----
const adcriteriakey = 0
const adcriteriaallcols = 1
const adcriteriaupdcols = 2
const adcriteriatimestamp = 3

'---- adcprop_asyncthreadpriority_enum values ----
const adprioritylowest = 1
const adprioritybelownormal = 2
const 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 adcopynonrecursive = 2

'---- streamtypeenum values ----
const adtypebinary = 1
const adtypetext = 2

'---- lineseparatorenum 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 adsavecreateoverwrite = 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
%>

 本文Tags组网  
 收藏本文  打印本文  论坛讨论  关闭窗口
· 上一篇:VBScript和JavaScript 的比较
· 下一篇:Microsoft VBscript运行时错误(完整版)
· VBScript GetLocale 函数
· LTrim、RTrim 和 Trim 函数
· VBScript IsObject 函数
· Microsoft(R) Visual Basic(R) Scripting Edition
· VBScript Chr 函数


关于本站 | 联系我们 | 业务合作 | 客户案例 | 诚聘英才 | 广告合作 | 收藏本站
海口动网先锋网络科技有限公司版权所有
Copyright © 2000 - 2006 Cndw.Com
中华人民共和国电信与信息服务业务经营许可证编号 琼 ICP 020077