Hello:
I have a test database made in MySQL (using MySQL Workbench). This is a simple data base consisting on a form and a subform. I was thinking to migrate an HSQLDB to a MySQL Server, so I was learning about connections between Libreoffice and MySQL using ODBC drivers. I connected LO Base to Mysql as follows: Connect to existing database-->MySQL
; and then Connect with ODBC
. Here I choose the DSN made with MySQL Connector ODBC 8.0.15.
Tables are related as shown below (the >> is suposed to show the relation).
tblMain ----------------------------| tblSubform
ID INT(10) (PK, NN, AI, UN)---------->> ID_Mainform INT(10) (FK, UN)
blah (VARCHAR)---------------------| IDSubform INT(10) (PK,NN,AI)
-------------------------------------| blah VARCHAR
Then I used the LO Base wizard to make a Form with a Subform. This form worked in Libreoffice v6.0.7. I could add data, the autonumbering worked OK, data was stored and retrieved correctly. But with Libreoffice 6.1.5.2 and 6.2.1 the form is broken. When I open the form it gives me this error:
The data could not be loaded: invalid description index.
What could be happening?
I’ve attached the ODB file, and made a dump fie of the Mysql database. The last one could not be loaded in this forum, so I converted to text and pasted to a Writer Document.
Other info:
-
MySQL Server 5.7.25-log (MySQL Community Server (GPL))
-
Windows 10: Win64 (x84_64)
-
Connector ODBC 8.0.15
-
jre-9.0.1 (is active in Tools->Options->Advanced)