Description: I use LO 6.3.3.2.0+ (Build 2). When I try to execute a query, i receive the error message below: Error: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -206 *Column unknown *LINK_FROM_EMPLOYEEID *At line 1, column 240 caused by 'isc_dsql_prepare' The Query: SELECT "Contatti"."Cognome" FROM "Contatti" WHERE "Cognome" LIKE '%' || :Cerca || '%' Steps to Reproduce: 1. Open Database 2. Execute Query 3. Insert criteria Actual Results: I receive the reported error message. Expected Results: I expect to read the query output. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Versione: 6.3.3.2.0+ Build ID: 30(Build:2) Thread CPU: 2; SO: Linux 5.3; Resa interfaccia: predefinito; VCL: gtk3; Versione locale: it-IT (it_IT.UTF-8); Lingua interfaccia: it-IT Calc: threaded
A similar bug was reported for forms: https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c12
pTux : if you created your ODB file with an earlier version of LibreOffice, then your report is probably a DUP of bug 117503, in which case you should either create a new one in 6.3, and drag and drop your tables, forms, queries, reports, etc from the old to the new and save, or else run the macro within your ODB document that is to be found in comment 15 of bug 117503. *** This bug has been marked as a duplicate of bug 117503 ***