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
