To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103537 Issue #|103537 Summary|crash OO3.1 when creating simple Query - Design view v |s SQL editor Component|Database access Version|OOO310m9 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dstockman
------- Additional comments from dstock...@openoffice.org Tue Jul 14 12:38:11 +0000 2009 ------- I was just able to crash OO while playing with the SQL codes as above (lengthy explanation so not included, but available if needed). A strange behavior occurred while playing with the following code. The first time I tried, it gave an error msg as above. I tried again later and it ran the code. Then I tried pasting the following text into the SQL window and OO said it could not find the table “A1cTBL” in the database. SELECT “MRN”, MAX(“Date”) FROM “A1cTBL” GROUP BY “MRN” I shut the computer down and tried again. I tried to run the following code and got the error msg below. SELECT "MRN", MAX( "Date" ) FROM "A1cTBL" AS "A1cTBL" GROUP BY “MRN” Error MSG SQL Status: S0022 Error code: -28 Column not found: “MRN” in statement [SELECT "MRN", MAX( "Date" ) FROM "A1cTBL" AS "A1cTBL" GROUP BY "“MRN”"] I have to delete the GROUP BY "MRN” statement to do anything – i.e. it would not let me save the code or change to the graphical editor unless I deleted the GROUP BY "MRN” statement. Once I changed to the graphical editor, I could then use the editor to select a GROUP as a function and run the query. I could then switch to the SQL editor and the code looks as follows. SELECT "MRN", MAX( "Date" ) FROM "A1cTBL" AS "A1cTBL" GROUP BY "MRN" How do I attach the simple database? Doug --------------------------------------------------------------------- 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