Issue 43052 - open office crashes when execute delete query in the query design
Summary: open office crashes when execute delete query in the query design
Status: CLOSED DUPLICATE of issue 42459
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P2 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-02-18 09:52 UTC by tony_52
Modified: 2010-11-10 16:16 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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