I am currently successfully connecting to my remote mariadb 10.3 server, through LO Base 18.104.22.168 on Ubuntu 18.04. The odb file contains a number of vues, queries (some including variables), forms (some generating queries from code) and reports (using libreoffice-report-builder). The connection to the database is MySQL Native, with the MySQL Connector 1.0.2 extension.
I am now testing Ubuntu 20.04 (LO 7.1) before upgrading my system. I understand that the connector is now integrated into LO, but it doesn’t work just the same as the extension (which can no longer be installed).
I am now running into issues, when running my odb. Connection to the DB works, as I can see the tables and can run simple queries. Queries with variables (eg WHERE
PurchaseDate <= :Mois) return an error around the variable :Mois (I do get the dialog box from Base prompting me for the variable, then the following error:
The data content could not be loaded. /home/buildslave/-source/libo-core/connectivity/source/commontools/-dbtools.cxx:751
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:Mois GROUP BY “ClientID”) AS “qrycalcClientPackagesub1” WHERE "qrycalcClientPa’ at line 1 /home/buildslave/srouce/libo-core/-connectivity/source/drivers/mysqlc/mysclc_general.cxx:119
What is the new syntax to be used with variables to solve this issue?