ADO Attributes Property

## ADO Tutorial

ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

## ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes
ADO Summary

## ADO Examples

ADO Examples

# 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

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

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

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE