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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Pierre Ledure <jp at ledure.be> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jp at ledure.be
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #2 from Jean-Pierre Ledure <jp at ledure.be> ---
The SQL statement should not contain
   SELECT TOP 1
but, if I'm not wrong,
   SELECT FIRST 1
instead.

The statement is built in module "Database" of the Access2Base library from
line 1145 on:
   Select Case UCase(MetaData.getDatabaseProductName())

In LO 6.1 the value returned by getDatabaseProductName() is an empty string.
This is clearly a bug.
What does LO 6.2 return ?

To test it, Drew, insert this simple code typically in the TEST module of the
provided database and run it:
   Sub TestType
        MsgBox Application.CurrentDb().MetaData.getDatabaseProductName()
   End Sub

With this answer I can easily complete the Select Case on lines 1145 etc and
make the DLookup run smoothly.

Thanks.
JPL

-- 
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/20180717/17a0ee08/attachment.html>