The connection type is MYSQL(native). In the wayback I vaguely remember
using the JDBC connection type. I believe I switched the oldest to
MYSQL(native) to solve a problem with complex querys. The newest
database affected started with MYSQL(native).
Perhaps the clue is in the error states verbatum:
The data content could not be loaded. 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 ':link_from_ID )'.
Data is displayed for the parent table. It does not display for the
subform.
I just checked the form properties for the subform. The link fields had
the slave in the masters position and visa versa. I flipped the order
and tested the form, and voila, it works.
The wierd thing is, it had been working fine for years. If the order
had always been reversed....
I checked the second table and got the exact same error message. Made
the identical changes on this form and ta da! Everything works.
Maybe everything working before was the bug? This is fixed for me, just
leaving me curious as to exactly which change led to the problem.
Thanks for your help.
On Thu, 2019-08-01 at 18:31 +0200, Rene Engelhard wrote:
> Hi again,
>
> On Thu, Aug 01, 2019 at 12:04:58AM +0200, Rene Engelhard wrote:
> > On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote:
> > > have linked sub-forms from two seperate tables for entering related
> > > data.
> > > One of the databases started out as a libreoffice base then was
> > > converted
> > > to a mariadb connection. The other started out as a connection to
> > > mariadb.
>
> Maybe it's not related at all but connection to mariadb how? MySQL ODBC?
> MySQL JDBC? (both of which are removed because being buggy), MariaDB
> JDBC? Or libreoffice-mysql-connector?
>
> If the latter, 5.2 removed the extension and need for libmysqlcppconn
> but integrated it properly into the "main" packages
> (libreoffice-sdbc-mysql), just using lib{mariadb,mysql}client/libmariadb
> properly.
>
> Maybe it's related to one of those?
>
> Regards,
>
> Rene
