[Libreoffice-bugs] [Bug 112272] Allow delete and update queries

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112272

robert at familiegrosskopf.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |robert at familiegrosskopf.de

--- Comment #3 from robert at familiegrosskopf.de ---
> 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170907/7dbf8321/attachment.html>