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