FilterKeys

concerns

The FilterKeys attribute function determines all values of the key column depending on the contents of a value column.

 

Syntax

FilterKeys(ByVal ColumnName As String, ByVal IsExpression As String)

Return value

Variant ()

Parameter

Use

Name

Type

Passing

Description

Required

ColumnName

Variant

ByVal

Name of the value column

Required

ValueName

String

ByVal

Check expression.

The expression to be checked is represented by the variable “Is”

 

Example:

The following dictionary with the name RAL has been defined:

The call of the following codes

 

Dim Res1() As Variant, Res2() As Variant

 

Res1 := RAL.FilterKeys("Car", "Is = True")

Res2 := RAL.FilterKeys("Bike", "Is = True")

 

returns in the variable Res1 the result

1010, 2001, 2002, 4018, 5000, 9001, 9006

and in the variable Res2

1010, 1025, 2002, 3017, 5000, 9001