To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100867 Issue #|100867 Summary|aggregates out of Base and into Writer table controls |are zero Component|framework Version|OOO310m8 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|code Assigned to|tm Reported by|hisdad
------- Additional comments from his...@openoffice.org Mon Apr 6 05:13:33 +0000 2009 ------- It is possible to create a query in base which SELECTS MAX(sometextfield) GROUP BY Someintfield. This works perfectly in base. If you were to then create text document and a Table Object by using this query, or by entering it as SQL into the Form. The Aggregate field will show as Zero, if the value is not a representation of an integer. Or to put it another way, the table object is attempting to perform a cast to Numeric on that column. Failure results in a Zero. This issue is with version 3.0.1 as well as the current 3.1 snap. I shall attach a simple text doc and DB that shows this behaviour. Priority is 4 because this renders my current project utterly impossible. Maybe you can fix before 3.1 goes gold. --------------------------------------------------------------------- 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...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org