https://bugs.documentfoundation.org/show_bug.cgi?id=144949
Bug ID: 144949 Summary: firebird_sdbc error: when opening a form with Libre base 7.2.1 Product: LibreOffice Version: 7.2.1.2 release Hardware: Other OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: z...@gmx.de Description: Opening a form getting error: Der Inhalt eines Kombinations- oder Listenfeldes konnte nicht ermittelt werden. firebird_sdbc error: *Unrecognized C++ exception caused by 'SELECT DISTINCT "Lagerort" FROM "Lagerort"' For one field a list should be shown out of an other table Field Properties: Daten: Lagerort Art des Listeninhalts: Tabelle Tabelle: Lagerort (This table contains the items to be shown in the list Now changing "Art des Listeninhalts" to: SQL and Listeninhalt to: select Lagerort from Lagerort Now the form works fine again. I have the impression the the "DISTINCT" is causing the error above database content as well as forms where done with former Libre Base versions about three years ago. Form works just fine with Libre Base 7.1.6 Steps to Reproduce: 1.start base 2.open form 3. Actual Results: see description Expected Results: List to be shown in form field respectively form should open without error Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.