Hi Mark,
<i><font color="#663300">>Is there some snazzy alternative to presenting a screen of data and being able to scroll up and down the list, and find clients? Hmm, does that sound disbelieving? It's not meant to, I'm genuinely asking.</font></i>
There are numerous alternatives, some snazzy, some not. This is actually a design issue rather than a framework issue. One of the databases my users work with has 1.5 millions records in it. If they were forced to scroll through to find the one they wanted, they would kill me. I provide them with a dialog in which to enter search criteria and present them with a subset to scroll through. That subset has no need of an index because the view is ordered. I generally only put an index on a view I am going to do a Seek on.
If the table contains so few clients that scrolling through all of them is practical, then perhaps giving them read-only access to the table in a grid is the solution. But if the index for ordering the records is not needed for optimization, then I might use a simple SQL statement to populate a cursor with the field I need order it.
Pamela
pamela (AT) eagle-crest .DOT com
©2002 Pamela Thalacker |
