https://bugs.documentfoundation.org/show_bug.cgi?id=132377
Bug ID: 132377
Summary: Base - native MySQL - linked subforms do not work
Product: LibreOffice
Version: 6.4.3.1 rc
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When opening forms with subforms the following error is produced:
SELECT * FROM "projekte"."nationalisierungen" WHERE (
"projekte"."nationalisierungen"."pID" = :link_from_str_ID ) ORDER BY "Land" ASC
nationalisierungen is a table included in the form as subform by linking its
field pID to the field str_ID of the main table/form.
"pID" = :link_from_str_ID does not seem to be standard SQL and throws the
error.
Base is connected to a MariaDB (10.1.44 Ubuntu 18.04.1) via
libreoffice-mysql-connector (6.4.3-1)
Steps to Reproduce:
1. Open form with subforms.
2.
3.
Actual Results:
Error shown.
Subform fields are not populated with data.
Expected Results:
Subform fields/tables should be populated with data
Reproducible: Always
User Profile Reset: No
Additional Info:
-
--
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