ADO Property Object

Some ADO objects have a Properties collection made up of the Property objects. Each Property object corresponds to a that characteristic of the ActiveX Data Object specific to the provider.

There are two types of ADO objects properties:

1 Built-in properties.

2 Dynamic properties.

1. Built-in properties.

Built-in properties are those properties that is implement in ADO and immediately available to any other new object, using the MyObject.Property syntax. They do not appear as Property objects in an object's Properties collection, so although we can change their values, we cannot modify their characteristics.

A dynamic Property object have four built-in properties of its own:

Property	Description
Attributes	One or more characteristics of a property.
Name	The name of the property.
Type	The operational or data type of the property.
Value	The value assigned to the property.

Attributes Property

Use the Attributes property to set or return the characteristics of the ADO Property objects.

When you set multiple attributes, you can sum the appropriate constants. If you set the property value to a sum including incompatible constants, an error occurs.

Name Property

Sets or returns a String value. The value is read-only on a Property object.

Use the Name property to assign a name to or retrieve the name of a Property object.

2. Dynamic properties.

Dynamic properties are defined by the underlying data provider, and appears in the Properties collection for the appropriate ActiveX Data Object.

For example:

A property specific to the provider may indicate if a Recordset object supports updating or transactions. These additional properties will appear as Property objects in that Recordset object�s Properties collection. The Dynamic properties can be referenced only through the collection by using the following Syntex as given bellow.

Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.