ADO Property Object

The ADO Property object represents a dynamic characteristic of an ADO object that is defined by the provider. This object is not currently supported on UNIX.

ADO Property Object Properties

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

ADO Property Object Remarks

ADO objects have two types of properties: built-in and dynamic. Built-in properties are those properties implemented in ADO and immediately available to any new object, using the familiar MyObject.Property syntax.

Built-in properties do not appear as Property objects in an object's ADO Properties Collection, so while you can change their values, you cannot modify their characteristics or delete them.

Dynamic properties are defined by the underlying data provider, and appear in the Properties collection for the appropriate ADO object. For example, a property specific to the provider may indicate if an ADO Recordset Object supports transactions or updating. These additional properties will appear as Property objects in that Recordset object's Properties collection. Dynamic properties can be referenced only through the collection, using the MyObject.Properties(0) or MyObject.Properties("Name") syntax.

A dynamic Property object has four built-in properties:

· The ADO Property Object Name Property is a string that identifies the property.

· The ADO Property Object Type Property is an integer that specifies the property data type.

· The ADO Property Object Value Property is a variant that contains the property setting.

· The ADO Property Object Attributes Property is a long value that indicates characteristics of the property specific to the provider.