Unfortunately I have a sneaking suspicion that over 37,000 rows of an up to 55 character name might just break the limit <g>.
But there are other ways and, in reality, I don't think I'd like to scroll though a list that long although there are some advantages - especially when you get different spellings of names. That's a neat trick to remember, though, thanks. Regards, Alastair. ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 6:39 PM Subject: [RBG7-L] - Re: Sorting ListOf > > > > > 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 >
