[Libreoffice-bugs] [Bug 118767] New: FIREBIRD: Access2Base: Dlookup function generates SQL error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118767

            Bug ID: 118767
           Summary: FIREBIRD: Access2Base:  Dlookup function generates SQL
                    error
           Product: LibreOffice
           Version: 6.1.0.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: drewjensen.inbox at gmail.com

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 
 https://nextcloud.documentfoundation.org/s/ePAmqMj3N2Ywms4
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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180714/0785b9db/attachment-0001.html>