Re: [libreoffice-users] Sorting a MySQL Database

Hi Ian,

There is another way -

1.  After opening your Form in design mode, click on View | Toolbars | and
make sure Form Design is ticked
2.  On that toolbar, click on Form Navigator (5th from left on my toolbar -
it's the one with the 4 point star on it)
3.  Right click on your Form name (probably the 2nd item from the top)
4.  Choose Properties
5.  Continue from point 3 on my first reply

If that doesn't work, then someone who uses Forms with MySQL may be able to
help you.

Noel
--
Noel Lodge
lodgemn@gmail.com


On 29 August 2013 17:55, Ian Whitfield <whitfield@telkomsa.net> wrote:

> Hi Noel
>
> On 29/08/13 06:12, Marion & Noel Lodge wrote:
>
> > Hi Ian,
> >
> > With a Form, I have found the following is the way to lock in the Form's
> > sort order -
> >
> > 1.  Open the Form in Edit mode
> > 2.  Right click on the form and from the dropdown choose Form...
> > 3.  Click on the Data Tab
> > 4.  The contents field should be pointing to your Table
> > 5.  Click on the box to the right of the Sort field
> > 6.  Then you can choose your sort fields, (LastName and FirstName)
> > 7.  Click OK
> > 8.  Close Form Properties
> > 9.  Save the Form
> >
> > This works with my H2 database.  Hopefully it is the same for your MySQL.
>
> Just checked on my OLD Base / HSQL Database and there is NO "Form" option
> there either - so I guess this is an option only with your H2 engine (??)
>
> IanW
> Pretoria RSA

-- 
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