Re: [libreoffice-users] Sorting a MySQL Database

Ian,

Is there an id key field? If there is the default sorting is by the id key  
(usually numerical order).

In SQL you can add the line:

ORDER BY Last-Name, First-Name

The default order is ascending (ASC) if descending is needed

ORDER BY Last-Name DESC, First-Name DESC


On Mon, 26 Aug 2013 08:00:24 -0400, Ian Whitfield <whitfield@telkomsa.net>  
wrote:

> Hi All
>
> I now have my new MySQL/LO Base Database up, running and fully edited  
> from the old one. And what a pleasure it is to work with!! This IS the  
> way to go,
>
> One question - It seems to have a strange way of sorting the Data as  
> displayed in the Form I designed and I have to select 'Sort' in the  
> bottom Bar and then pick 'Last Name', Ascending and 'First Name'  
> Ascending to get it the way I want it.
>
> Unfortunately it does not seem to keep this Sort!! Is there a way to  
> "lock' this sort or to make it automatically do it when you start the  
> program??
>
> PClinuxOS 2013
> LO Version 3.6.5.2 (Build ID: 5b93205)
>
> Thanks for any help.
>
> IanW
> Pretoria RSA


--
Jay Lozier
jslozier@gmail.com

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted