----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 5:49 PM Subject: [RBG7-L] - Re: Sorting ListOf
> Now if the dbcombobox worked that quick, no, let's be positive, _when_ the > dbcombobox works that quick... Bingo! > Regards, > Alastair. > > ----- Original Message ----- > From: "MikeB" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Thursday, July 22, 2004 10:19 PM > Subject: [RBG7-L] - Re: Sorting ListOf > > > > > > ----- 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 > > > > > > > > > >
