https://bugs.documentfoundation.org/show_bug.cgi?id=96686
Bug ID: 96686
Summary: Insert data in temporary MySQL/MariaDB-Table through
GUI impossible
Product: LibreOffice
Version: 4.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
For filtering data shown in reports I'm using a table named "Filter". I could
use such a table without problems in a standalone-DB like the internal HSQLDB.
With external server-databases I have to use a temporary table, which is only
editable for the special connected user.
So I'm doing the following, here shown without macro:
Tools → SQL
CREATE TEMPORARY TABLE IF NOT EXISTS `Filter` (`ID` TINYINT(1) PRIMARY KEY,
`Name` VARCHAR(50));
INSERT INTO `Filter` (`ID`) VALUES(1);
Through GUI I only want to update the content of `Name` and read out this for
reports.
There is no possibility to update the content through GUI.
1. Form doesn't know anything about the table `Filter`
2. Query-Editor shows the content of `Filter`: SELECT * FROM `Filter` - but it
isn't writable, so also unusable as datasource for the form.
There are only two ways to get an update for the temporary table:
Tools → SQL or a command started with a macro.
Tested this with OpenSUSE 42.1 LEAP 64bit rpm Linux, LO 4.4.7.2 and LO 5.0.4.2,
native connection to MySQL and also connection through JDBC-driver.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
