<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: Access2Base: Dlookup function generates SQL error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118767">118767</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FIREBIRD: Access2Base: Dlookup function generates SQL error
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.1 rc
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>drewjensen.inbox@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
The DLookup function generates an SQL select statement not suitable for the
Firebird engine.
Full Access2Base error message is:
Error #1510 (DFunction execution failed, SQL=SELECT TOP 1 "SupplierID" AS
"TEMP83032" FROM "Suppliers" WHERE "CompanyName"='Escargots Nouveaux') occurred
in DLookup
The use of TOP 1 will need to be changed for Firebird.
Steps to Reproduce:
1. Download the example file at
<a href="https://nextcloud.documentfoundation.org/s/ePAmqMj3N2Ywms4">https://nextcloud.documentfoundation.org/s/ePAmqMj3N2Ywms4</a>
2. Open the form 'Products_ListBoxFilter'
3. Clear the initial error box
4. All controls should load with data
5. Click on any item in either of the two top list boxes on the left side of
the form. (see screen shot)
Actual Results:
Error triggered from Dlookup function.
Expected Results:
Select statement executes and updates UI.
Reproducible: Always
User Profile Reset: No
Additional Info:</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>