HOME

ADO Tutorial
ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO SQL
ADO Demo

ADO Objects
ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream

Examples
ADO Examples
Award Winning Web Host Full Services Including Ecommerce
Please visit our sponsors !

The Attributes Property

Back

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

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.


Back

Jump to: Top of Page or HOME or Printer Friendly Printer friendly page


Search W3Schools:


What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves


We Help You For Free. You Can Help Us!


W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved


Validate How we converted to XHTML Validate

IISCart
ASP Ecommerce & Shopping Cart


Your own Web Site?

Read W3Schools
Hosting Tutorial



$15 Domain Name
Registration
Save $20 / year!



Advertise
at W3Schools

Only 0.5 CPM



SELECTED LINKS

University Online
Master Degree
Bachelor Degree


Web Software

The Future of
Web Development


Jobs and Careers

Web Security
Web Statistics
Web Standards


PARTNERS

W3Schools
TopXML
VisualBuilder
XMLPitstop
DevelopersDex
DevGuru
Programmers Heaven
The Code Project
Tek Tips Forum
ZVON.ORG
TopXML Search