QueryByProperty Method

Description

Returns an AttachedPropertyTables collection that consists of AttachedPropertyTable objects that match all of the query inputs.

Syntax

Visual Basic
Public Function QueryByProperty( _ ByVal QueryType As PropertyTableConstants, _ Optional ByVal TableName As Variant, _ Optional ByVal NumProps As Variant, _ Optional ByVal PropName As Variant, _ Optional ByVal PropType As Variant, _ Optional ByVal PropVal As Variant _ ) As Object

Visual Basic

Public Function QueryByProperty( _
   ByVal QueryType As PropertyTableConstants, _
   Optional ByVal TableName As Variant, _
   Optional ByVal NumProps As Variant, _
   Optional ByVal PropName As Variant, _
   Optional ByVal PropType As Variant, _
   Optional ByVal PropVal As Variant _
) As Object

Parameters

QueryType

Value	Description
seCustomPropertyQueryAllProperties	Property Table - Query All Properties
seCustomPropertyQueryByNameAndValue	Property Table - Query By Name and Value
seCustomPropertyQueryByTable	Property Table - Query By Table

Specifies the type of query to perform. Valid values are members of the PropertyTableConstants constant set. With seCustomPropertyQueryAllProperties, TableName is ignored. With seCustomPropertyQueryByTable, the TableName and any custom property name/value pairs specified are searched for exact matches. With seCustomPropertyQueryByNameAndValue, only custom property name/value pairs are searched, and matches with all name/value pairs are returned.

TableName

When the QueryType is seCustomPropertyQueryByTable, TableName specifies the AttachedPropertyTable.Name for which you are searching.

NumProps

When the QueryType is seCustomPropertyQueryByNameAndValue, NumProps specifies the number of PropName-PropType-PropValue sets for which you are searching.

PropName

When the QueryType is seCustomPropertyQueryByNameAndValue or seCustomPropertyQueryByTable, PropName specifies the array of AttachedProperty.Name strings for which you are searching.

PropType

When the QueryType is seCustomPropertyQueryByNameAndValue or seCustomPropertyQueryByTable, PropType specifies the array of AttachedProperty.Type constants for which you are searching.

PropVal

When the QueryType is seCustomPropertyQueryByNameAndValue, PropVal specifies the array of AttachedProperty.Value for which you are searching.