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
Created attachment 175548 [details] properties of the form field with produces the error
Created attachment 175549 [details] Formfiled definition which works after manuel change
Created attachment 175550 [details] definition of table "Lagerort"
Would it be possible you attach the odb file? Indeed, on a brand new Firebird odb file, I created the table and tried to reproduce the form but don't have the same entries in Data tab.
Created attachment 175563 [details] DB to show the error condition odb which shows the error condition. Some filed got updated so that there are no sensitive data show. But even with this update the error condition is shown when opening up the form "Inventory". While update process I recognized that possibly the firebird error shown is related to the "unreadable" characters in table "Lagerort" - see bug #144950 I also filed yesterday
remark to "unreadable" characters in table "Lagerort" -- these DO NOT show up in Libre Base 7.1.6.
I read your private emails, indeed you must be careful when uploading files since anyone can download them. This page https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission helps about this but it seems you've already dealt with this problem. You talked about unreadable characters but I opened all the forms I don't see any pb (or perhaps missed it?). It reminds me tdf#144230 even if we're talking about a form here not a query the patch may have an impact here and so it could be already fixed in next LO release 7.2.2.
thanks Julien for the info to tdf#144230. Right - it looks similar to me. I just installed 7.2.2.1 for a trial and it looks like that it solved the problem I have seen. The one with the form to display the list of "Lagerort" as well as the appearance of this "unreadable (Garbage)" characters. Thanks a lot for checking on this
*** This bug has been marked as a duplicate of bug 144230 ***
Thank you for the feedback! Great to see it was indeed a dup so it's already fixed.