Обсуждение: default data sort

How can I change the default data sort for a table? When I view the data 
in the selected table, it always opens a spreadsheet view sorted by the 
primary key. In this case, the primary key is a one-up number and a more 
useful sort is the name column. How can I have it default to sort by 
name rather than primary key?

On 21/06/2009 18:57, Michael Fraley wrote:
> How can I change the default data sort for a table? When I view the data
> in the selected table, it always opens a spreadsheet view sorted by the
> primary key. In this case, the primary key is a one-up number and a more
> useful sort is the name column. How can I have it default to sort by
> name rather than primary key?

When you open the data view window, go to Tools -> Sort/Filter, and
select the column by which you want to sort.

Also, you could open a query window and do
 select * from my_table order by desired_sort_column;

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------