----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, July 24, 2004 2:31 PM Subject: [RBG7-L] - Re: Sorting ListOf
> Mike > > VERY interesting posting. I follow everything you're saying except the last > statement: > > "Or you could just use the Listbox items iterating through them by > referencing each item by its' ItemIndex" I was thinking in terms of Items in a ListOf being accessed by SSUB. The first item is at (SSUB(.vLisOF, .vIndexNumber)) And by Comparison, you can also just access the ListOf items while they are still in the Sorted ListBox by using the ItemIndex like: Property SomeSortedListBox ItemIndex .vIndex -- this sets the position in the listbox GetProperty SomeSortedListBox SELECTION 'vItem' -- this puts the data at the ItemIndex in the variable vItem So, instead of putting everything from the Sorted Listbox back in a ListOf by using GetProperty lbListOf ListItems 'vListOf' Then using the SSUB as shown above, just iterate through them directly while they still are in the ListBox.... > I read the words, understand each one, but can't translate this into a > command, set of commands, or a check mark on a form.... > > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "MikeB" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Thursday, July 22, 2004 1: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 > > > > >
