Kina Attributes ya ADO

Return to ADO Parameter Object Reference Manual

Mifano na matumizi

Kina Attributes inaweza kusaidia au kurejea thamani ya Long, thamani inaweza kubadilika kina au viwango vingi ya kina hii.

Madoa:Kama inasemekana kusaidia vingine kina, inafikia kushaangazia kina kwa uadilifu. Kama inasemekana kusaidia thamani ya kina inayoweza kwa vingine kina vitafutaji, inasababisha kosa.

kina kivyo cha kina Attributes
Connection Kina Attributes ina ruhusa wa kurea na kusoma kwa kina Connection. Na thamani yake inaweza kwa kilimo au viwango vingi XactAttributeEnum kivyo cha thamani. Mwaka wa chaguo ni namba zero (0).
Parameter Kina Attributes ina ruhusa wa kurea na kusoma kwa kina Parameter. Na thamani yake inaweza kwa kilimo au viwango vingi ParameterAttributesEnum kivyo cha thamani. Mwaka wa chaguo ni adParamSigned.
Field Kwa uwanja wa Attributes kina ina ruhusa wa kurea na kusoma kwa kuzia Recordset, lakini kama inasemekana Recordset zilizochukuliwa, ina ruhusa wa kusikitika. Kina Attributes inaweza kwa kilimo au viwango vingi FieldAttributeEnum kivyo cha thamani.
Property Kwa kina Property, kina Attributes ni kusikitika. Na thamani yake inaweza kwa kilimo au viwango vingi. PropertyAttributesEnum kivyo cha thamani.

mashairi

object.Attributes

mimpo

kwa Connection kina mbinu:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
response.write(conn.Attributes)
conn.close
%>

Kuhusu Kipengele cha Field:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn
set f=Server.CreateObject("ADODB.Field")
Kuonyesha ujumbe wa matumizi ya Mifumo ya Tablica ya Orders
for each f in rs.Fields
  response.write("Attr:" & f.Attributes & "<br />")
  response.write("Name:" & f.Name & "<br />")
  response.write("Value:" & f.Value & "<br />")
Next
rs.Close
conn.close
set rs=nothing
set conn=nothing
%>

Kuhusu Kipengele cha Property:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn
set prop=Server.CreateObject("ADODB.Property")
Kuonyesha ujumbe wa matumizi ya Tablica ya Orders
for each prop in rs.Properties
  response.write("Attr:" & prop.Attributes & "<br />")
  response.write("Name:" & prop.Name & "<br />")
  response.write("Value:" & prop.Value & "<br />")
next
rs.close
conn.close
set rs=nothing
set conn=nothing
%>

Wertu wa XactAttributeEnum

Constant Value Description
adXactAbortRetaining 262144 Kisha cha kutumia RollbackTrans, inarudisha uharibifu mpya.
adXactCommitRetaining 131072 当调用 CommitTrans，自动启动新事务。

ParameterAttributesEnum Values

Constant Value Description
adParamSigned 16 该参数接受带符号的值。
adParamNullable 64 该参数接受 Null 值。
adParamLong 128 该参数接受长二进制数据。

FieldAttributeEnum Values

Constant Value Description
adFldCacheDeferred 0x1000 指示提供者缓存字段值，并且指示对缓存的进行读取。
adFldFixed 0x10 指示该字段包含定长数据。
adFldIsChapter 0x2000 指示该字段包含一个子集值，指定与此父字段有关的特定子记录集。通常子集字段与数据构形或过滤器一起使用。
adFldIsCollection 0x40000 该字段指定由记录表示的资源是其他资源的集合（如文件夹）而不仅是简单资源（如文本文件）。
adFldIsDefaultStream 0x20000 该字段包含由记录表示的资源的默认流。例如，默认流可以是 Web 站点根文件夹的 HTML 内容，在指定根 URL 时自动提供。
adFldIsNullable 0x20 Hii la nafasi inaonyesha thamani ya kinaadui.
adFldIsRowURL 0x10000 Hii la nafasi inaonyesha URL, ambao inaonyesha mabaki ya data ya rekodi yenye maana. URL hii inamshiriki katika kusaidia kusoma data.
adFldKeyColumn 0x8000 Hii la nafasi inaonyesha kinaadui kinaadui cha kikabila cha rekodi kinaadui. Inaonyesha pia kuwa hii la nafasi inaenea kinaadui kinaadui cha kinaadui kinaadui.
adFldLong 0x80 Hii la nafasi inaonyesha kiwango cha data cha adui kubwa. Inaonyesha pia kuwa inaweza kutumika kwa vifaa vya kuongeza kichwa cha data (AppendChunk) na kuwasiliana na kichwa cha data (GetChunk).
adFldMayBeNull 0x40 Inaweza kusomwa thamani ya kinaadui kutoka kwa hii la nafasi.
adFldMayDefer 0x2 Hii la nafasi inaonyesha thamani inayopita, hivyo thamani hii haipaswa kusomwa kwa pamoja na rekodi kwa sababu ya kusafirisha kwa data ya msingi, bali inasomwa kwa sababu ya kusababisha kusafirisha.
adFldNegativeScale 0x4000 Hii la nafasi inaonyesha thamani ya adui kutoka kwa msingi wa data ambao inaadui kwa uadilifu wa rangi ya namba. Hii rangi inaonyeshwa na uwezo wa NumericScale.
adFldRowID 0x100 Hii la nafasi hii inahusika na kiwango cha upinde wa muhimu, kiwango hiki kinahitajika kwa kugudisha, hivyo hakina maana kwa sababu ya muhimu wa mawili, kama ni namba ya rekodi, kiwango cha kinaadui au kinaadui kinaadui.
adFldRowVersion 0x200 This field contains some time or date stamp used for tracking updates.
adFldUnknownUpdatable 0x8 The provider cannot determine whether the user can write to the field.
adFldUnspecified
  • -1
  • 0xFFFFFFFF
 The provider has not specified field attributes.
adFldUpdatable 0x4 Users can write fields.

PropertyAttributesEnum Values

Constant Value Description
adPropNotSupported 0 The provider does not support this property.
adPropRequired 1 Users must specify the value of this property before initializing the data source.
adPropOptional 2 Users do not need to specify the value of this property before initializing the data source.
adPropRead 512 Users can read this property.
adPropWrite 1024 Users can set this property.

Return to ADO Parameter Object Reference Manual