Issue 124348 - sorting order setting dosn't save in queries when creating with wizard
Summary: sorting order setting dosn't save in queries when creating with wizard
Status: CLOSED DUPLICATE of issue 121096
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.0.1
Hardware: PC Windows XP
: P3 Major with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-02 18:37 UTC by antonio1
Modified: 2017-05-20 09:36 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
base file (694.91 KB, application/octet-stream)
2014-03-02 18:37 UTC, antonio1 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description antonio1 2014-03-02 18:37:12 UTC 
Created attachment 82766 [details]
base file

i create query, with wizard, and choose sorting order, click, next, then choose criterios, click next, then finish.
when start query, nothing sorting, all records are choose.
but i can open this query, and manually choose all sorting & criterios, then all works! 
I mean, tht wizard dont properly worked. 

if it help, i can create video
Comment 1 Lars Jødal 2014-07-09 12:10:08 UTC 
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
Comment 2 damjan 2015-11-09 18:06:08 UTC 
Duplicate of 121096, which I will fix shortly.

*** This issue has been marked as a duplicate of issue 121096 ***