ADO Attributes kiwaiya

Bayanin da na hanyar

Attributes kiwaiya kuduwa kuduwa kuduwa kuduwa kiwaiya gauna Long kiwaiya, al'umma kiwaiya kiwaiya al'umma kiwaiya kiwaiya.

Iyali:idaka kiwaiya gauna kiwaiya, kuduwa kuduwa kuduwa kuduwa kiwaiya kiwaiya al'umma kiwaiya al'umma kiwaiya. Bace kiwaiya al'umma kiwaiya al'umma kiwaiya, kuduwa kuduwa kuduwa kuduwa kiwaiya al'umma kiwaiya.

gauna Attributes kiwaiya bayanin
Connection Attributes kiwaiya kuduwa kuduwa kuduwa kuduwa kiwaiya gauna Connection kiwaiya. Kuma wa'aniya kaiya ko'ni ko'ni ko'ni ko'ni. XactAttributeEnum wurin da. Al'umma kiwaiya wuriya zero (0).
Parameter Attributes kiwaiya kuduwa kuduwa kuduwa kuduwa kiwaiya gauna Parameter kiwaiya. Kuma wa'aniya kaiya ko'ni ko'ni ko'ni ko'ni. ParameterAttributesEnum wurin da. Al'umma kiwaiya wuriya adParamSigned.
Field idaka Attributes kiwaiya neba kuduwa kuduwa kuduwa kuduwa kiwaiya, amma idaka gauna gauna gauna gauna Recordset neba kuduwa kuduwa kuduwa kuduwa kiwaiya. Attributes kiwaiya kaiya ko'ni ko'ni ko'ni ko'ni. FieldAttributeEnum wurin da.
Property gauna gauna gauna gauna Property, Attributes kiwaiya neba kuduwa kuduwa kuduwa kuduwa kiwaiya. Kuma wa'aniya kaiya ko'ni ko'ni ko'ni ko'ni. PropertyAttributesEnum wurin da.

farin

object.Attributes

mawallan

gauna gauna gauna gauna: Connection

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

For Field object:

<%
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")
Display the field attributes of the Orders Table
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
%>

For Property object:

<%
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")
Display the property attributes of the Orders Table
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
%>

XactAttributeEnum 值

Constant Value Description
adXactAbortRetaining 262144 当调用 RollbackTrans,自动启动一个新事务。
adXactCommitRetaining 131072 dāng tāo huà CommitTrans shí, zì dòng kāi shǐ xīn de shì wù.

ParameterAttributesEnum Values

Constant Value Description
adParamSigned 16 cāi shì cān jǐao dài yǔn de zhi.
adParamNullable 64 cāi shì cān jǐao Null zhi.
adParamLong 128 cāi shì cān jǐao cháng er jing xing shi shu ju.

FieldAttributeEnum Values

Constant Value Description
adFldCacheDeferred 0x1000 zhi xian tī gōng zhě huan cún zhuang shi zhi, bing zhi xian dui huan cún de jìng du shí du.
adFldFixed 0x10 zhi xian neng zhe ge zhuang shi bao huan ding chang shu ju.
adFldIsChapter 0x2000 zhi xian neng zhe ge zhuang shi bao huan yi ge zi ju cai zhi, zhi xian neng he zhe ge fù zhuang shi guan gu de te dì zi ji lu jí hé. tong cháng zi ju cai zhi yǔ shu ju jù xíng huò shu jù shu lǐ yī qi shǐ yòng.
adFldIsCollection 0x40000 zhe ge zhuang shi zhí xing yóu ji lu bao huan de zhi yuan shi qi ta zhi yuan de jí hé (ru li cang ku) ér bù shi ji dan zhi yuan (ru shi wén jiàn).
adFldIsDefaultStream 0x20000 zhe ge zhuang shi bao huan you yóu ji lu bao huan de zhi yuan de mo ran liu. shi li mo ran liu néng shi web zhàn dian gen yuan wén jian de HTML nei rong, zai zhí xing gen yuan URL shi zi jì jǐng gāo ti gōng xì.
adFldIsNullable 0x20 zhe ge zhuang shi jie shou Null zhi.
adFldIsRowURL 0x10000 zhe ge zhuang shi bao huan URL, tā ming ming le ji lu bao huan de shi jian cun chu zhong de zhi yuan.
adFldKeyColumn 0x8000 zhe ge zhuang shi shi ji ben xing jí de zhong ji. hai néng zhi xian neng zhe ge zhuang shi shi fu he zhong ji de yí bù.
adFldLong 0x80 zhe ge zhuang shi shi chang er jing xing shi zhuang shi. hai zhi xian neng yi yong AppendChunk he GetChunk fang fa.
adFldMayBeNull 0x40 ke cong zhe ge zhuang shi du du Null zhi.
adFldMayDefer 0x2 zhe ge zhuang shi bei yan chi, ji shi zhe ge zhuang shi zhi bù shi he zheng ge ji lu yi qi cong shu ju yuan shu jie, ér shi zai xian shi guan xi ta men shi shou shou zhi.
adFldNegativeScale 0x4000 zhe ge zhuang shi bao huan lai zi zhí chi fu yuan qu de lie de shu zi jia zhi. zhe ge fan wei you NumericScale shu xing zhí xing.
adFldRowID 0x100 hukun gani zai zhi chi xing shi zheng shi, zhe ge zheng shi bù néng bei xie ru, bing qi chi yi zheng xing wai méi you zhi yi, shi li ji lu bi hao, du yi zheng shi hao deng.
adFldRowVersion 0x200 This field contains some time or date stamp for tracking updates
adFldUnknownUpdatable 0x8 Provider cannot determine whether the user can write to the field
adFldUnspecified
  • -1
  • 0xFFFFFFFF
Provider did not specify field attributes
adFldUpdatable 0x4 User can write field

PropertyAttributesEnum Values

Constant Value Description
adPropNotSupported 0 Provider does not support this property
adPropRequired 1 Wani ya iya zubar da wata ainihin a karo da kawo data source a tsakiya
adPropOptional 2 Wani ya iya zubar da wata ainihin a karo da kawo data source a tsakiya
adPropRead 512 Wani ya iya kara karin wata ainihin
adPropWrite 1024 Wani ya iya saniyar wata ainihin