Collect.IXVals function
Description
Returns the list of index values for the specified indexed field in the specified file.
Syntax
list = Collect.IXVals(filename, fieldname)
Parameters
The Collect.IXVals function has the following parameters:
| Parameter | Description |
|---|---|
| Filename | Name of the OpenInsight table containing the index |
| Fieldname | Name of the indexed field. If the field is a cross reference, suffix with _XREF. |
Returns
An @fm delimited list of index values.
See Also
Example
declare function Collect.IXVals
declare subroutine Set_Property
* get a list of cities that our customers are in CITY has a BTREE index
List = Collect.IXVals ("CUSTOMER", "CITY")
* put the list into the COMBO_CITY combo box
Set_Property (@window: ".COMBO_CITY", "LIST", List)