To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43052 Issue #:|43052 Summary:|When query returns no data to display, open office |crashes Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P1 Subcomponent:|none Assigned to:|msc Reported by:|tony_52
------- Additional comments from [EMAIL PROTECTED] Fri Feb 18 01:52:31 -0800 2005 ------- Although this issue was shown as fixed, when tried with the latest public snapshot m79 the following happened. I have a table called test in the embedded HSQLDB database with the following fields id int autoincrement primary key a varchar b varchar I write a query in SQL to delete a row, as shown below: delete from test where id=1 I save this query I then run the query A popup box is displayed informing me that 'The data content could not be loaded' 'Statement does not generate a result set' This information is largely irrelevant, as I neither expect or want a result set displayed, simply a row deleted from the table. However clicking OK then causes OpenOffice to crash, and then start the recovery process. As an aside to this I have already raised the issue regarding Query types, as they are available in MS Access, and until the same, or similar query types are available in OOBase, I will not be able to persuade our current MS Access users to change, which is a shame as the rest of the MS Office suite is largely surpassed by Open Office, and persuading people not requiring an Access alternative is proving far easier to do, but becuase my company wants a standard Office suite, then MS Access requirements have to be taken into consideration. Cheers --------------------------------------------------------------------- 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]