Collect.IXVals function [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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 ====
 
[[btree.extract|Btree.Extract]]
 
==== Example ====
 
<code>
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)
</code>