https://bugs.documentfoundation.org/show_bug.cgi?id=112272
[email protected] changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #3 from [email protected] ---
> 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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
