----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 3:15 PM Subject: [RBG7-L] - Re: Sorting ListOf
> Unfortunately I have a sneaking suspicion that over 37,000 rows of an up to > 55 character name might just break the limit <g>. 42,000 rows of about 30 chars loaded into a listbox via a Cursor in about 9 seconds, sorted via the OrderBy. 42,000 rows of about 30 chars loaded into a listbox via a Select to a File and then LoadFromFile to ListBoxia in about 5-6 seconds, sorted via the OrderBy. 42,000 rows of about 30 chars loaded into a listbox via a Select to a File and then LoadFromFile to ListBoxia in about 5 seconds, sorted via setting the ListBox Property SORTED 'TRUE'. 42,000 rows of about 30 chars loaded into a Temp Table 5 seconds, sorted via the OrderBy. > 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 > > >
