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 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 > >
