xf_DataList
xf_DataListPublic Function FormatMultiRowPK(ParamArray ValList() As Variant) As String
Build a lookup cache for unique values in the specified column(s)
Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataListDataList Base Class
Caching of primary key/unique value lookup
Public Function GetRowIndexFromPKVal(PkVal As String) As Long
Get the row index matching a (possibly multi column) unique value
Public Sub RefreshPKCache()
Rebuild the unique value lookup cache after values have changed
Public Sub SetupPKCache(ColNameOrNumberList As String)
Build a lookup cache for unique values in the specified column(s) The unique value can then be specified as a row parameter for the Item() method