https://issues.apache.org/ooo/show_bug.cgi?id=124348
Lars Jødal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Lars Jødal <[email protected]> --- I can confirm this problem, using AAO 4.1.0. The problem does not seem to relate to the wizard, but to the graphical user interface. It seems that the query interface "forgets" the sorting order, when the query is opened for edit. Example (which should be easy to reproduce): For the example, I have made a database containing a table "Persons" with the fields "ID", "firstname", "lastname", "address". I now make a query to show just "firstname" and "lastname", sorted in order by "lastname". I do this using design view and save. Opening the query as SQL view, it has this code: SELECT "firstname", "lastname" FROM "Persons" ORDER BY "lastname" ASC No problems so far. I now open my query for editing in graphical mode. Here the problem shows: The screen shows the two field, BUT NO SORTING ORDER. If I do some editing, e.g. adding the "address" field, and save, the SQL version no longer contains sorting: SELECT "firstname", "lastname", "address" FROM "Persons" (End of example) So, the problem seems to be that the graphical editing erroneously "forgets" the sorting when the query is opened. Saving is correct: If I have specified sorting order, it is saved - but since it is forgotten on opening, I have to specify it again each time I edit the query. As specified, the test was done using the newest version (4.1.0) of Base/AAO. Best regards, Lars -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue. You are watching all issue changes.
