Property Object
A Property object represents a dynamic characteristic of an ADO object
that is defined by the provider.
Properties
Attributes, Name, Type,
Value
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. 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.
See Also
Command, Connection,
Field, Item, Properties,
Recordset
| 
