ADO Attributes Property
 Complete Connection Object Reference
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
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
%> |
Example - 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
%> |
Example - 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. |
Complete Connection Object Reference
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
|
