Property object ¶
Built-in properties are those that are implemented in ADO and immediately available to any new object, using the MyObject.Property grammar. They will not act as Property object appears in the object’s `` Properties``collection, so although you can change their values, you cannot change their properties.
ADO Property objects represent the dynamic properties of ADO objects, which are defined by the provider defined.
Everyone who talks to ADO provider have different ways to interact with ADO. Therefore, ADO needs to store information about provider in some way. The solution is provider provide specific information (dynamic properties) for ADO. ADO put each provider property is stored in a Property object, while the Property object is also stored in the Properties in the assembly. This collection will be assigned to the Command object, Connection object, Field object or Recordset object.
For example, a property assigned to a provider might indicate Attribute Description Attributes Returns the properties of a Property object Name Sets or returns the name of a Property object Type Returns the type of Property Value Sets or returns the value of a Property object Recordset``object supports transactions or updates. These additional properties will be used as ``Property object appears in the Recordset object’s Properties in the assembly.ProgID ¶
set objProperty=Server.CreateObject("ADODB.property")
Attribute ¶