<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - firebird_sdbc error: when opening a form with Libre base 7.2.1"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144949">144949</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>firebird_sdbc error: when opening a form with Libre base 7.2.1
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>Other
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>zmds@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>