Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DataListxf_DataListDataList Base Class
Public Function FindValue (
ParamArray FieldAndValList()
) As Long
Return the index of the first row where the column values match the passed list, or -1 if the values are not found
ParamArray FieldAndValList() as Variant
The list of paired values, column name or index then value.
Call Template:
Dim obj As New xf_DataList
Dim i As Long
i = obj.FindValue(FieldAndValList)
See Also:
Example 1:
Debug.Print FindValue("CategoryID", 2, "UnitPrice", 10) -> 3
Debug.Print FindValue("CategoryID", 25) -> -1