Now if the dbcombobox worked that quick, no, let's be positive, _when_ the dbcombobox works that quick...
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 > > > > > >
