ADO Property Object
- Previous Page ADO Parameter
- Next Page ADO Record
Property object
ADO objects have two types of properties: built-in properties and dynamic properties.
Built-in properties are implemented in ADO and are immediately available for any new object, using the MyObject.Property syntax. They do not appear as Property objects in the object's Properties collection, so although their values can be changed, their characteristics cannot be changed.
The ADO Property object represents the dynamic characteristics of the ADO object, which are defined by the provider.
Each provider that interacts with ADO has its own way of communicating with ADO. Therefore, ADO needs to store information about the provider in some way. The solution is for the provider to supply specific information (dynamic properties) to ADO. ADO stores each provider property in a Property object, and the Property objects are correspondingly stored in the Properties collection. This collection is assigned to the Command object, Connection object, Field object, or Recordset object.
For example, properties specified to the provider may indicate whether the Recordset object supports transactions or updates. These additional properties will appear as Property objects in the Properties collection of the Recordset object.
ProgID
set objProperty=Server.CreateObject("ADODB.property")
Properties
| Properties | Description |
|---|---|
| Attributes | Return the attributes of a Property object |
| Name | Set or return the name of a Property object |
| Type | Return the type of Property |
| Value | Set or return the value of a Property object |
- Previous Page ADO Parameter
- Next Page ADO Record
