Today, eventually, I managed to solve a critical problem with Mysql Direct Connector, but even though now I can see tables and queries in my odb, I still get an error message when I open a form with a subform. This is the error message: SQL Status: 42000 Error code: 1064 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_classe ) ORDER BY "ID_classe", "cognome"' at line 1 /build/libreoffice-muaG6z/libreoffice-7.0.4~rc2/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119 And the mysql syntax is this: The SQL command leading to this error is: SELECT "studenti"."ID" AS "ID", "studenti"."cognome" AS "cognome", "studenti"."nome" AS "nome", "studenti"."data_nascita" AS "data nascita", "studenti"."abitazione" AS "abitazione", "studenti"."via" AS "via", "studenti"."telefono" AS "telefono", "studenti"."origine" AS "origine", "studenti"."ID_classe" AS "ID_classe", "studenti"."dati_personali" AS "dati personali", "studenti"."situazione_scolastica" AS "situazione scolastica", "studenti"."voto_matu" AS "voto matu", "studenti"."significativita" AS "significativita" FROM "miei"."studenti" "studenti" WHERE ( "studenti"."ID_classe" = :link_from_ID_classe ) ORDER BY "ID_classe", "cognome", "cognome" ASC Therefore now I see, in my form, the main form (correctly), but the subform is empty. What should I do? LO: Version: 7.0.4.2 Build ID: 00(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5 Locale: it-IT (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.0.4~rc2-0ubuntu0.20.04.2 Calc: threaded
Could be it is a problem with parameter name settings: Try this: SUB FB_Parameter DIM oSettings AS OBJECT oSettings = ThisComponent.DataSource.Settings oSettings.ParameterNameSubstitution = True END SUB You must only run this procedure from the opened database one time. Or have a look at the content.xml in the *.odb-file (could be opened by a zip-program) Not working code: <db:driver-settings db:system-driver-settings="" db:base-dn="" db:parameter-name-substitution="false"/> Working code <db:driver-settings db:system-driver-settings="" db:base-dn=""/>
Perfect! It worked! Thank you very much!