ADO Attributes Property
 Complete Field 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 Field Object Reference
Create a free Flash website with our simple, online web design editing platform. Stunning templates
and user-friendly tools make website building easy and fun.
Start Creating your free website now!
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file,
Excel 2007, XBRL, or Web services data. Then it transforms data instantly or
auto-generates royalty-free code for recurrent conversions.
New features in Version 2010!
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
- Available in 32-bit and 64-bit versions
Download a fully-functional trial today!
|
|
|
|
