To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70792 Issue #|70792 Summary|Dialogue box when error occures in "Create View" is to |o small for the error description Component|Database access Version|OOo 2.0.4 Platform|Other URL| OS/Version|Solaris Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|benpintilie
------- Additional comments from [EMAIL PROTECTED] Tue Oct 24 05:09:34 -0700 2006 ------- Create a DB as follows: One table - called Stock In the table have the following fields country, building, region, floor, room, location, make, model, serial, part, face. When prompted all Base to add a primary key of sequential numbers and save the design. Go back to the main menu and click create view Add all the fields EXCEPT the ID field In any of the fields click Function choose "group" click save choose any name you want click ok You will now get an error Heading: OpenOffice.org Base Logo: Red Circle with a white cross Description: Not in aggregate function or group by clause: [EMAIL PROTECTED] in statement [ SELECT "country", "building", "floor", "location", "make", "model", "serial", "part", "face" FROM ((THIS BIT IS HIDDEN BY THE OK BUTTON)) GROUP BY "part"] If there are a lot of fields you are not able to see all of the error message. The box is not resizeable either. This appears more to be an error with the dialoge box rather than the data that is held in the tables etc. --------------------------------------------------------------------- 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]