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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
