Bug 37599 - Implement UI entries or action buttons for update/drop query in Base
Summary: Implement UI entries or action buttons for update/drop query in Base
Status: CLOSED DUPLICATE of bug 31398
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-25 12:38 UTC by Hajnalka Horváth
Modified: 2017-09-11 07:34 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Hajnalka Horváth 2011-05-25 12:38:48 UTC 
Update and drop queries are not implemented in LibreOffice Base. It is not even possible to use the built-in SQL editor to create such queries as the query fails.

Update and drop queries are needed in Base so that Base could be an alternative to Microsoft Access in schools. The ECDL Advanced Database exam requires the use of these queries. There is no open source alternative that could create such queries, which may cause dependency on proprietary software in education.
Comment 1 Alex Thurgood 2011-05-26 01:10:14 UTC 
Yes, they are, but not via the Query manager user interface.

Try Tools > Options > SQL.
Enter your SQL statement there. If it runs you will be told it has been executed successfully. If not, you will get an error message. However, you will not get a graphical representation of what you are doing.

In order for the changes to be registered when using DROP TABLE "TableX", you need to quit the whole LibreOffice application (including quickstarter if launched) and reload the ODB file again.

So, the conditions of the ECDL can be met, if you know where to look.

That is not to say that it would be nice to have a feature, as in Access, where you could do such operations from a button, or a menu entry within the ODB container framework.

I will change the title of your request to reflect this. 

Alex
Comment 2 Alex Thurgood 2011-05-26 01:12:33 UTC 
(In reply to comment #1)
> Yes, they are, but not via the Query manager user interface.
> 
> Try Tools > Options > SQL.
> Enter your SQL statement there. If it runs you will be told it has been
> executed successfully. If not, you will get an error message. However, you will
> not get a graphical representation of what you are doing.
> 
> In order for the changes to be registered when using DROP TABLE "TableX", you
> need to quit the whole LibreOffice application (including quickstarter if
> launched) and reload the ODB file again.
> 
> So, the conditions of the ECDL can be met, if you know where to look.
> 
> That is not to say that it would be nice to have a feature, as in Access, where
> you could do such operations from a button, or a menu entry within the ODB
> container framework.
> 
> I will change the title of your request to reflect this. 
> 
> Alex



Sorry that should've been :

Try Tools > SQL from the main application window when the Base file is open.
Comment 3 Alex Thurgood 2011-05-26 01:52:25 UTC 

*** This bug has been marked as a duplicate of bug 31398 ***
Comment 4 Alex Thurgood 2017-09-11 07:34:43 UTC 
*** Bug 112272 has been marked as a duplicate of this bug. ***