To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116345 Issue #|116345 Summary|Query wizard creates not working query with summary qu |ery Component|Database access Version|OOO330m18 Platform|Unknown URL| OS/Version|Windows 7 Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|r4zoli
------- Additional comments from [email protected] Fri Jan 7 10:32:46 +0000 2011 ------- Open attached odb file. Run query wizard on Table1, select fields: datum, payment, azon. Next, next. In 3. point add condition field azon is equal to 'BF'. Next. Select summary, get sum of, payment field. Change payment alias to draw. Next, Finish. The query contain two record instead of sum. Open query for edit run query, get the correct result, close query. Run query, get two field again. Open query in SQL Mode: SELECT SUM( "Table1"."payment" ) AS "draw" FROM "Table1" "Table1" WHERE ( "Table1"."Azon" = 'BF' ) GROUP BY "Datum", "Azon" Run query, two fields. Change to design view, run query, correct result. Swithch back to SQL mode, the query changes, to: SELECT SUM( "payment" ) AS "draw" FROM "Table1" WHERE "Azon" = 'BF' GROUP BY "Azon" Close query. Run query, two fields again. If you save query in another name (Query_Table1_1 in example file), the saved query is : SELECT SUM( "payment" ) AS "draw" FROM "Table1" WHERE "Azon" = 'BF' GROUP BY "Azon" And works correctly. If you changes anything in original query, the script changes to second version and works correctly. --------------------------------------------------------------------- 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]
