Latest web development tutorials

ADO Property objects

Property Objects

Built-in properties are realized side by side can be used for any of the properties of the new object in ADO, this time using MyObject.Property syntax. They do not appear as Property objects in the Properties collection of objects, and therefore, although you can change their values, but can not change their characteristics.

ADO Property object represents the dynamic characteristics of the ADO object, which is defined dynamic characteristics of the provider.

Each provider has a dialogue with the ADO and ADO different ways to interact. Therefore, ADO need a way to store information about provider information. The solution is to provide specific information provider (dynamic properties) to ADO. ADO each provider attributes are stored in a Property object, and the object corresponding to the Property is also stored in the Properties collection. This collection will be assigned to the Command object, Connection objects, Field objects or Recordset object.

For example, specify the properties to the provider may indicate whether a Recordset object supports transaction or updates. These additional attributes will appear as Property objects in the Recordset Properties collection object.

ProgID

set objProperty=Server.CreateObject("ADODB.property")


Attributes

Attributes description
Attributes Property Returns an object's properties
Name Sets or returns a Property object name
Type The return type of Property
Value Sets or returns the value of a Property object