A Property object represents a dynamic characteristic of an ADO object that is defined by the provider.
Attributes, Name, Type, Value
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. However, these built-in properties do not appear as Property objects in an object’s Properties collection, so while you can change their values, you cannot modify their characteristics or delete them.
Many OLE DB providers will expose additional object properties to ADO. These dynamic properties provide information about additional functionality available from the provider. For example, a property specific to the provider may indicate if a Recordset object supports transactions or updating. These additional properties will appear as Property objects in that Recordset object’s Properties collection.
A dynamic Property object has four built-in properties of its own:
· The Name property is a string that identifies the property.
· The Type property is an integer that specifies the property data type.
· The Value property is a variant that contains the property setting.
· The Attributes property is a long value that indicates characteristics of the property specific to the provider.
To refer to a Property object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:
object.Properties.Item(0)
object.Properties.Item("name")
object.Properties(0)
object.Properties("name")
With the same syntax forms, you can also refer to the Value property of a Property object. The context of the reference will determine whether you are referring to the Property object itself or the Value property of the Property object.