Bug 112272 - Provide a graphical way of generating delete and update queries
Summary: Provide a graphical way of generating delete and update queries
Status: RESOLVED 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: 2017-09-07 10:23 UTC by Peter Toye
Modified: 2017-10-28 18:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Toye 2017-09-07 10:23:51 UTC
Title says it all really.

I've found that occasionally I want to run a query which either deletes or updates records according to certain criteria. Typing the SQL is always possible but is error-prone. A graphical (and storable) way is greatly preferable. This has been available in Access for ages (I last used that program in about 2000); surely it's time that LO had this feature?
Comment 1 Alex Thurgood 2017-09-07 10:38:53 UTC

*** This bug has been marked as a duplicate of bug 31398 ***
Comment 2 Peter Toye 2017-09-07 11:16:30 UTC
I don't think it's the same. I'm asking for a graphical way of inputting update/delete queries. RFE 31398 is asking for LO to allow such queries to be input in SQL and use the HSQLDB permissions for access control (as I read it).
Comment 3 Robert Großkopf 2017-09-07 16:52:15 UTC
> I don't think it's the same. I'm asking for a graphical way of inputting
> update/delete queries. RFE 31398 is asking for LO to allow such queries to
> be input in SQL and use the HSQLDB permissions for access control (as I read
> it).

Bug 31398 is about a possibility to save SQL-Code for update/insert/drop. The title of the bug is misleading: sql-editor is used in bug 31398 for both: The GUI for queries and the possibility to put code to tools > SQL.

Look at this, copied from the original report:
---------
when run as query fails: 

UPDATE "Table1" set "Table1"."fld-flag" = False where "Table1"."fld-flag" = True;

(error was: "LibraOffice Base: The data content could not be loaded.  Statement does not generate a result set.")

when run same sql code as tools-sql-execute_command it succeeds ("Command successfully executed."):

UPDATE "Table1" set "Table1"."fld-flag" = False where "Table1"."fld-flag" = True;
---------

So I think this is a duplicate.
Comment 4 Peter Toye 2017-09-07 17:38:32 UTC
Robert, I disagree. Your clips from the bug 31398 are both for SQL that's been typed in. I'm asking for a graphical way of generating the query.

I've changed the title to make it clearer.
Comment 5 Alex Thurgood 2017-09-11 07:34:43 UTC

*** This bug has been marked as a duplicate of bug 37599 ***
Comment 6 Xisco Faulí 2017-10-28 18:21:46 UTC

*** This bug has been marked as a duplicate of bug 31398 ***