RE: Sorting ListBox Columns

One of the great features RB provides is the In-Memory databases (SQLite) and you can use it for this kind of situation. Create an In-Memory database to store the result recorset and then perform the selects and sorts from this database. You can also create indexes for the columns that are sortabl

Re: Sorting ListBox Columns

On Aug 1, 2006, at 7:55 AM, Chuck Pelto wrote: This information should help me in doing that. Thanks. I have a working demo. I'd be happy to email it to you if that would be helpful. Jack ___ Unsubscribe or switch delivery mode:

Re: Sorting ListBox Columns

On Aug 1, 2006, at 8:22 AM, Charles Yeomans wrote: Perhaps you should LOOK HERE -- . That looks interesting. Thanks Regards, Chuck ___ Unsubscribe or switch delivery mode:

Re: Sorting ListBox Columns

On Aug 1, 2006, at 8:17 AM, CV wrote: Create a new class, say SortData, and give it two properties: ColumnSorted as integer, SortDirection as string. Add a method called Constructor with parameters: Column as integer, Direction as integer. Ah yes. I still have to master that business of

Re: Sorting ListBox Columns

Hi John, On Aug 1, 2006, at 5:53 AM, John Kubie wrote: I don't know if this fits, but perhaps an alternative is not to sort in the listbox, but to sort using "sortwith". Each column would be a one-dimensional array. When the header is pressed, the press would be captured and that dimension

Re: Sorting ListBox Columns

On Aug 1, 2006, at 3:02 AM, Chuck Pelto wrote: On Jul 31, 2006, at 7:34 PM, CV wrote: I'd suggest loading your array from the Action event handler of a Timer(mode 1) enabled from HeaderPressed. You can experiment with the Period, but regardless, the Timer is designed to wait until othe

Re: Sorting ListBox Columns

On Aug 1, 2006, at 6:02 AM, Chuck Pelto wrote: On Jul 31, 2006, at 7:34 PM, CV wrote: I'd suggest loading your array from the Action event handler of a Timer(mode 1) enabled from HeaderPressed. You can experiment with the Period, but regardless, the Timer is designed to wait until other

Re: Sorting ListBox Columns

I don't know if this fits, but perhaps an alternative is not to sort in the listbox, but to sort using "sortwith". Each column would be a one-dimensional array. When the header is pressed, the press would be captured and that dimension would become the 'sort' column of the sort and all othe

Re: Sorting ListBox Columns

On Jul 31, 2006, at 7:34 PM, CV wrote: I'd suggest loading your array from the Action event handler of a Timer(mode 1) enabled from HeaderPressed. You can experiment with the Period, but regardless, the Timer is designed to wait until other processes are completed, so it should readily cap

Re: Sorting ListBox Columns

On Jul 31, 2006, at 9:34 PM, CV wrote: On Jul 31, 2006, at 2:51 PM, Chuck Pelto wrote: Which comes first? Which comes last? When is the sorting finished? If one clicks on the header of a listbox and the sorting takes place, at what point in the process is the sorting done? Is it with th

Re: Sorting ListBox Columns

On Jul 31, 2006, at 2:51 PM, Chuck Pelto wrote: Which comes first? Which comes last? When is the sorting finished? If one clicks on the header of a listbox and the sorting takes place, at what point in the process is the sorting done? Is it with the HeaderPressed? Is it with the SortColumn