Gary,
Tks. Learning more every day!
>Jumping in here,
>I use listboxes exclusively instead of grids now in the client server framework I use. I put it in a container that has textboxes over the listbox for editing. As a user up and down arrows, the textbox values change to reflect this and it allows row by row record adding, delete and updating of the back end. Code in the textbox class allows me to resort the listbox by the active column and resizing the columns should be easy, thought I've never tried. There is a fair amount of code in the background, but it's extremely fast, so the users don't notice anything.
>
>Gary
>
>
>>><snip>
>>>
>>>>Terry,
>>>>Typically, the control source for the grid (or listbox) would be a cursor.
>>>>So, I would have to loop through the cursor and add the rows to the listbox, correct? That could introduce a delay in the object appearing with data, correct?
>>>>The idea of sorting without indexing is definately attractive.
>>>
>>>Hi Allan
>>>
>>>It's been my experience that I often have to grab columns from multiple tables for the user to sort on. That is not necessarily easy without using SQL.
>>>
>>>You should compare using SQL to create a cursor, and then populating the listview, versus indexing the cursor and binding a grid to that cursor. I'd guess a few index commands will be faster than the looping code that populates the listview.
>>
>>Mike,
>>Tks for the tip.
>>I will have to try the listview with some different business scenarios.