ADO Attributes ce

Kai zuwa ADO Connection kita na waje

kaidow da amfani

Attributes ce za a iya gudanar da ko a iya samu farin ciki Long, kuma za a iya nuna kuduwa ko yawa daga girmuwa.

sauki:idana a kai a gudanar da yawa girmuwa, za a iya kara kuduwan girmuwa. Idana a kai kuduwan girmuwa a kama girmuwa da kuduwan da za a iya amfani da su yana da matsakaici, za a iya samu rauni.

girmuwa bayani game da Attributes ce
Connection Attributes ce ke hauka kuduwa ga girmuwa Connection. Kuma za a iya samu kuduwa ko yawa. XactAttributeEnum kuduwa da yawa. Kuduwan tsawon gudanarwa shine siffo (0).
Parameter Attributes ce ke hauka kuduwa ga girmuwa Parameter. Kuma za a iya samu kuduwa ko yawa. ParameterAttributesEnum kuduwa da yawa. Kuduwan tsawon gudanarwa shine adParamSigned.
Field idana Attributes ce a iya amfani da su kafa Recordset, ana hauka kuduwa da kafuri, amma idana a kai kama Recordset ya barci, ana hauka kuduwa kuma. Attributes ce za a iya samu kuduwa ko yawa. FieldAttributeEnum kuduwa da yawa.
Property gauna girmuwa Property, Attributes ce ganiya kuduwa kuma za a iya samu kuduwa ko yawa. PropertyAttributesEnum kuduwa da yawa.

kalama

object.Attributes

laɓaɓi

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

针对 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")
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
%>

针对 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")
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 值

Kowane Wuri Bayan
adXactAbortRetaining 262144 当调用 RollbackTrans，自动启动一个新事务。
adXactCommitRetaining 131072 当调用 CommitTrans，自动启动新事务。

ParameterAttributesEnum Values

Kowane Wuri Bayan
adParamSigned 16 该参数接受带符号的值。
adParamNullable 64 该参数接受 Null 值。
adParamLong 128 该参数接受长二进制数据。

FieldAttributeEnum Values

Kowane Wuri Bayan
adFldCacheDeferred 0x1000 指示提供者缓存字段值，并且指示对缓存的进行读取。
adFldFixed 0x10 指示该字段包含定长数据。
adFldIsChapter 0x2000 指示该字段包含一个子集值，指定与此父字段有关的特定子记录集。通常子集字段与数据构形或过滤器一起使用。
adFldIsCollection 0x40000 Tafin na nuna abin da ke wuri da ke cikin kungiyar abin da ke wuri, kuma yana daɗin tafin da ke cikin abin da ke wuri.
adFldIsDefaultStream 0x20000 Tafin na nuna abin da ke cikin abin da ke wuri, wanda ke bayar da abin da ke cikin abin da ke wuri. Misali, abin da ke cikin abin da ke wuri yana da abin da ke cikin abin da ke wuri, kuma yana da abin da ke cikin abin da ke wuri.
adFldIsNullable 0x20 Tafin na amfani da Null.
adFldIsRowURL 0x10000 Tafin na nuna URL, wanda ke bayar da sunan abin da ke cikin tsarin da ke amfani da shi.
adFldKeyColumn 0x8000 Tafin na nuna tsarin da ke kusa da abin da ke kusa da kungiyar wanda ke da abin da ke kusa da kungiyar. Yana nuna cewa tafin na nuna abin da ke kusa da abin da ke kusa da kungiyar kuma yana da abin da ke kusa da kungiyar.
adFldLong 0x80 Tafin na nuna abin da ke cikin binary da yau da kullun. Yana nuna cewa ake amfani da kwararrun AppendChunk da GetChunk.
adFldMayBeNull 0x40 An iya amfani da tafin na nuna Null.
adFldMayDefer 0x2 Tafin na yi aiki tare da tsaɓaɓɓe, kuma yana daɗin tafin da ake amfani da shi domin kai tsare da yadda ake amfani da shi, kuma ba a kai tsare shi tare da tsarin da ake amfani da shi ba, kuma ake amfani da shi ne lokacin da ake kai tsare shi.
adFldNegativeScale 0x4000 Tafin na nuna wa'adi ko wa'adi daga kofar da ke aiki tare da kwararrun kwararrun wanda ke da ga'ar kai tsaye. Yankin na nuna kwararrun NumericScale.
adFldRowID 0x100 Tafin finna idanamunin da ke da ke za a kira, idanamunin na ba a kira a kanan, kuma yana da matsakaici daidai daidai ba tare da yadda ake amfani da shi ba, kamar a cikin abin da ake amfani da shi domin tsarin nambawan, idanamunin na kai tsaye da sauransu.
adFldRowVersion 0x200 Kowane bayan zai iya kewayi kowane wuri da wuri.
adFldUnknownUpdatable 0x8 Kowane kowane ba zai iya samun shi kowane bayan.
adFldUnspecified
  • -1
  • 0xFFFFFFFF
 Kowane kowane ba zai iya sakiwatsa shi kowane bayan.
adFldUpdatable 0x4 Wani zai iya shafi kowane bayan.

PropertyAttributesEnum Values

Kowane Wuri Bayan
adPropNotSupported 0 Kowane kowane ba zai iya sakiwatsa shi.
adPropRequired 1 Kowane wani zai iya samun shi a cikin tsaki na kewayin dajin bayan a iya sakiwatsa shi.
adPropOptional 2 Kowane wani zai iya samun shi a cikin tsaki na kewayin dajin bayan ba a iya sakiwatsa shi.
adPropRead 512 Wani zai iya samun shi.
adPropWrite 1024 Wani zai iya sakiwatsa shi.

Kai zuwa ADO Connection kita na waje