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]