> > Your approach of projecting a table or creating a VIEW with > > required pre-sorted data should be ideal for LISTOF values. > > > > Also, keep in mind that the LISTOF function returns a NOTE > > type and notes are limited to 4K, unless pre-defined as > > TEXT otherwise.
If your "ListOf" doesn't exceed 4K and you need it sorted, you can use a hidden listbox as intermediary. You can set your Listbox to Sorted like: Property lbListOf SORTED 'TRUE' then: select ListOf(vehmodel) into vList ind Vin0 from vehicle *( this puts the ListOf from the select into the Listbox and the Listbox is already set to sorted) property lbListOf ListItems .vList *(Then just reverse the process for the sorted listOf) GetProperty lbListOf ListItems 'vList' -- vList now contains the sorted ListOf items Or you could just use the Listbox items iterating through them by referencing each item by its' ItemIndex
