[dba-SQLServer] Views don't sort

Robert Robert at WeBeDb.com
Wed May 25 09:30:59 CDT 2011


John,

The minute you raid uneditable, you should be using a stored 
procedure and a pass through query.

For editable, your choices are views with the PK included or the 
tables, the first being the preference.

BTW...The non-sort behavior started with 2005.

Robert

At 05:31 AM 5/24/2011, you wrote:
>From: jwcolby <jwcolby at colbyconsulting.com>
>To: Discussion concerning MS SQL Server
>         <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] Views don't sort
>Message-ID: <4DDA39F5.5070408 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Mark,
>
>AFAICT pass through queries are not editable.  I am trying to build 
>three specific types of queries.
>
>1) Editable (bound) form queries
>2) Uneditable combo queries
>3) Uneditable report queries.
>
>I am using Access 2K3 for dev and Access 2K7 (runtime) someday soon 
>to be 2K10 (runtime) for general
>usage.
>
>It seems that the top(very large number) works for the moment for 
>returning sorted recordsets.  OTOH
>doing the pass-through trick for doing filtered uneditable queries 
>would work great.
>
>John W. Colby
>www.ColbyConsulting.com



More information about the dba-SQLServer mailing list