https://bugs.documentfoundation.org/show_bug.cgi?id=118767
Jean-Pierre Ledure <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
--- Comment #2 from Jean-Pierre Ledure <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
