ASP in a Nutshell, 2nd Edition

Property Object

A Property object represents a custom or unique property that is specific to ADO objects instantiated using a specific data provider. For example, if a Recordset object was instantiated using records from an Oracle database, that recordset may have special properties not supported by "typical" ADO. You would retrieve/set the values for these properties using an ADO Property object. This advanced feature of ADO allows you to take full command of your underlying data provider.

Each Command, Connection, Field, and Recordset object you instantiate maintains its own Properties collection. This way, you have access to custom properties of your data provider for all three object types. Table 12.16 lists the Property object's properties.

Table 12.16. Property Object Properties

Property	Description
Attributes	Allows you to determine whether a given property is supported, required, or optional, and whether the Property is read-only or read/write.
Name	The underlying name assigned by the data provider's name to a given property that's being manipulated through the use of a Property object.
Type	An integer that represents the data type of the property's contents. For the Property object, this is a read-only property.
Value	The actual value of the property.