Derek J. Kalweit wrote:
>>Very true. In many cases I will bring data local, then add any needed
>>indexes or maybe even use that long lost command SORT <s>
>
>
> How about adding an ORDER BY to the SQL(either direct SELECT, or the SQL the view is based on)?
That would merely assume that you only want that predefined order. In
my case, I had various sort options and an index to represent those.
Keeping in mind that in dealing with parm'd views (i.e., datasets with
very few records), the time spent on this was not even noticable.
--
Michael J. Babcock, MCP
President/CSA, MB Software Solutions, LLC
http://mbsoftwaresolutions.com
"Bettering your bottom line by helping you work smarter, not harder,
with custom software solutions."
©2004 Michael J. Babcock |
