Posted by RickW on 03/09/06 00:48

Doug wrote: Another solution is to go back to SQL Server 2000.

Not merited by this little hiccup.

Doug wrote: In Access, can you ask "Access" to return your result sets
in order?

Absolutely. We already have hundreds of queries in Access, and about 60
places in code where we are setting SQL up for lists. Dumping the Order
By spec in 31 views was a minor nuisance, not much more. Because Access
is sufficiently object oriented to use it on itself, I wrote some code
to look through query SQL, form recordsources, and list control
rowsources to find any reference to one of the affected views without an
accompanying Order By.

Not so terribly painful, just hacked me off that something I know is
used, documented or not, would be dropped without more noise.



Science is organized common sense where many a beautiful theory was
killed by an ugly fact. -- Thomas Huxley

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: need help to take the variables associated with the 1st occurrence of a date variable
• Prev in forum: Re: Can a stored procedure parameter be optional
• Thread view: Re: ORDER BY in VIEW not working

[Reply to this message]