To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107104
User r4zoli changed the following: What |Old value |New value ================================================================================ CC|'' |'r4zoli' -------------------------------------------------------------------------------- Keywords| |oooqa -------------------------------------------------------------------------------- ------- Additional comments from r4z...@openoffice.org Sun Nov 22 07:58:32 +0000 2009 ------- This is possibly problem around query. I found problems with Query1: Query1, open in SQL view: SELECT "a1"."Stamp", SUM( "a2"."Value" ) AS "Running_Total" FROM "Stamps" AS "a1", "Stamps" AS "a2" WHERE "a1"."Stamp" >= "a2"."Stamp" GROUP BY "a1"."Stamp" ORDER BY "a1"."Stamp" ASC Run Query without problem. Switch design view on run Query, it fails with: The data content can not be loaded. Switch design view off, the Query1 changes, to: SELECT "a1"."Stamp", SUM( "a2"."Value" ) AS "Running_Total" FROM "Stamps" AS "a1", "Stamps" AS "a2" GROUP BY "a1"."Stamp" HAVING ( ( "a1"."Stamp" >= "a2"."Stamp" ) ) ORDER BY "a1"."Stamp" ASC Run Query1, it fails with: The data content can not be loaded. Query 2, open for edit in SQL view: SELECT "a1"."ID", SUM( "a2"."Value" ) AS "Running_Total" FROM "Stamps" AS "a1", "Stamps" AS "a2" WHERE "a1"."ID" >= "a2"."ID" GROUP BY "a1"."ID" ORDER BY "a1"."ID" ASC It runs without problem. Switch design view on, the query2 runs, shows only last calculation results. Switch design view off the Query2 changes, to: SELECT "a1"."ID", SUM( "a2"."Value" ) AS "Running_Total" FROM "Stamps" AS "a1", "Stamps" AS "a2" GROUP BY "a1"."ID" HAVING ( ( "a1"."ID" >= "a2"."ID" ) ) ORDER BY "a1"."ID" ASC It runs, shows only last calculation results. Same results in OOO320_m5, on winXP. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org