I had a working base application using MySQL (JDBC) connection type. I tried switching to a JDBC connection type to add SSL security as described here .
The connection is ok, all tables, views and Base queries work fine as well as the Forms without sub forms.
When opening any of my forms containing a sub form, I get the following error message:
SQL Status: S1009
Parameter index out of range (1 > number of parameters, which is 0).
It seems to match the problem described in this Stack Overflow post . It is the basic error that happens in every code language I played around with when you have a string with placeholders, and do not pass it a matching number of parameters.
My forms are linked to their sub forms using the LO Base Link Master/Slave fields GUI settings, no macro is involved in that process.
My question is : Is there something I can do to fix it, Is it a Lo Base JDBC limitation/bug?
Basically should I give up on ssl encryption?