Issue 43052

Summary: open office crashes when execute delete query in the query design
Product: Base Reporter: tony_52 <tony.smith>
Component: codeAssignee: ocke.janssen
Status: CLOSED DUPLICATE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P2 CC: issues
Version: OOo 2.0   
Target Milestone: OOo 2.0   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description tony_52 2005-02-18 09:52:31 UTC
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
Comment 1 marc.neumann 2005-02-18 10:36:40 UTC
confirm, set target and reassign to the right developer
Comment 2 marc.neumann 2005-02-18 10:37:25 UTC
correct summary
Comment 3 ocke.janssen 2005-02-18 11:07:53 UTC
Duplicate

*** This issue has been marked as a duplicate of 42459 ***
Comment 4 ocke.janssen 2005-02-18 11:08:32 UTC
Closing
Comment 5 lymwaydurchting 2010-11-10 16:16:11 UTC
Created attachment 73130