To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66146
                  Issue #:|66146
                  Summary:|Query Wizard, Sort, JDBC and mysql not working
                Component:|Database access
                  Version:|OOo 2.0.3
                 Platform:|Macintosh
                      URL:|
               OS/Version:|Mac OS X
                   Status:|NEW
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P3
             Subcomponent:|none
              Assigned to:|dbaneedsconfirm
              Reported by:|wurzel





------- Additional comments from [EMAIL PROTECTED] Tue Jun  6 00:55:18 -0700 
2006 -------
Hi,

Using latest JDBC connector from MySQL, remote mysql database server (4.1.12),
and OOo 2.0.3rc5 French on MacOSX 10.3.9

I have created an ODB document that connects to a remote mysql database. If I
click on the Query button, then select Use Query Creation Wizard (or whatever it
is called in English, I only have the French, it is the second in the list of
possibilities), then the Query wizard is started.

If I select a SORT criteria in step 2 of the wizard, no matter what the type of
field, I systematically get an error message when it comes to pressing the
CREATE button, and the wizard will not let me go any further.

The message is :

Field "blah blah" (the field that has been chosen for the SORT) must be visible.

If I leave the query with no sort option, then it will execute fine and can be
saved. It doesn't seem to matter which field is selected for sorting, they all
throw an error - I've tested date, alphanumeric, and integer field types.

Alex

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to