[Libreoffice-bugs] [Bug 139207] New: subform bug

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139207

            Bug ID: 139207
           Summary: subform bug
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: fbertoldi at tiscali.it

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201224/d0070f8e/attachment.htm>