https://bugs.documentfoundation.org/show_bug.cgi?id=116253
--- Comment #24 from ribotb <[email protected]> ---
I created the database "journal" with DDL of comment#9/
I created a database .odb and connect it to "journal" using MariaDB
Connector/J.
In Edit > Database > Connection Type :
Database type: MySQL (JDBC)
Connection Settings
Host name: localhost
Port number: 3306
MySQL JDBC driver class: org.mariadb.jdbc.Driver
I created a form with a control 'Table control' associated to the table
"journal.journal". I defined a combo box on the column "To" to display the
content of the table "journal.tos" (List content type : Sql and List Content :
SELECT `To` FROM `journal`.`tos` `tos`) and select an item.
With the form I inserted new records in the table "journal.journal".
I don't notice problem with the field "To" in the form : no "NULL" displayed in
the field even with an empty list in the combo box (table "journal.tos" empty).
Maybe I didn't understand the problem :-) but I didn't notice anything abnormal
with an empty combo box associated with a field where"NULL" is allowed.
Tested with :
- Win10(x64),
- LibreOffice 5.4.7 and LibreOffice 6.1.0,
- MariaDB 5.5.61,
- mariadb-java-client-2.3.0.jar,
- Java 1.8.0_181.
Bernard
--
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
