ADO Attributes Property

The Attributes property sets or returns a long value that indicates one or more characteristics of an object. Note: When setting multipl...


The Attributes property sets or returns a long value that indicates one or more characteristics of an object.

Note: When setting multiple attributes, it is possible to sum the values.

Object Description of the Attributes Property
Connection The Attributes property has read/write permissions on a Connection object. Its value can be the sum of one or more XactAttributeEnum values. Default value is 0
Parameter The Attributes property has read/write permissions on a Parameter object. Its value can be the sum of one or more ParameterAttributesEnum values. Default value is adParamSigned
Field The Attributes property has read/write permissions when used to create a Recordset, but it has read-only permissions when you open an existing Recordset. Its value can be the sum of one or more FieldAttributeEnum values
Property The Attributes property is read-only for a Property object. Its value can be the sum of one or more PropertyAttributesEnum values

Syntax

object.Attributes

Example

For a Connection object:
<%
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 a 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 a 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 Values

Constant Value Description
adXactAbortRetaining 262144 When calling RollbackTrans it automatically starts a new transaction.
adXactCommitRetaining 131072 When calling CommitTrans it automatically starts a new transaction.



ParameterAttributesEnum Values

Constant Value Description
adParamSigned 16 The parameter will accept signed values.
adParamNullable 64 The parameter will accept null values.
adParamLong 128 The parameter will accept long binary data.



FieldAttributeEnum Values

Constant Value Description
adFldCacheDeferred 0x1000 Provider caches the field values and reads from the cache.
adFldFixed 0x10 Field contains fixed-length data.
adFldIsChapter 0x2000 Field contains a chapter value that specifies a child recordset.
adFldIsCollection 0x40000 The field specifies that the resource represented by the record is a collection of  resources
adFldIsDefaultStream 0x20000 Field contains the default stream for the resource represented by the record.
adFldIsNullable 0x20 Field accepts null values.
adFldIsRowURL 0x10000 Field contains the URL that names the resource from the data store represented by the record.
adFldLong 0x80 Field is a long binary field.
adFldMayBeNull 0x40 You can read null values from the field.
adFldMayDefer 0x2 Field values are not retrieved from the data source with the whole record, but only when you explicitly access them.
adFldNegativeScale 0x4000 Field represents a numeric value from a column that supports negative scale values.
adFldRowID 0x100 Field contains a persistent row identifier that cannot be written to and has no meaningful value except to identify the row (such as a unique id)
adFldRowVersion 0x200 Field contains some kind of time/date stamp used to track updates.
adFldUnknownUpdatable 0x8 The provider cannot determine if you can write to the field.
adFldUnspecified  -1
0xFFFFFFFF
Provider does not specify the field attributes.
adFldUpdatable 0x4 You can write to the field.



PropertyAttributesEnum Values

Constant Value Description
adPropNotSupported 0 The property is not supported by the provider.
adPropRequired 1 The user must specify a value for this property before the data source is initialized.
adPropOptional 2 The user does not need to specify a value for this property before the data source is initialized.
adPropRead 512 The user can read the property.
adPropWrite 1024 The user can set the property.

Goto ADO Property Object Complete List
Name

ADO,131,ASP,3,C++,61,CORE JAVA,1,CSS,115,HTML,297,index,5,JAVASCRIPT,210,OS,47,PHP,65,SAD,53,SERVLETS,23,SOFTWARE ENGINEERING,245,SQL,71,TCP/IP,1,XHTML,9,XML,18,
ltr
item
Best Online Tutorials | Source codes | Programming Languages: ADO Attributes Property
ADO Attributes Property
Best Online Tutorials | Source codes | Programming Languages
https://www.1000sourcecodes.com/2012/05/ado-attributes-property.html
https://www.1000sourcecodes.com/
https://www.1000sourcecodes.com/
https://www.1000sourcecodes.com/2012/05/ado-attributes-property.html
true
357226456970214079
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content