[Libreoffice-bugs] [Bug 143656] Direct SQL: Queries in Tools → SQL and macro give wrong results - direct SQL works well

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to m.a.riosv from comment #5)
> I didn't find exactly, but should be possible to run the sql as direct in a
> macro.
> In https://wiki.documentfoundation.org/images/b/b0/BH5009-Macros.pdf, page
> 71 shows how to enable direct sql for mail-merge.

It's only mail merge and I haven't tested it works not the same way as SQL in
macros will work. Mail merge needs to know here, if it should use a table
directly (by tablename), a query directly (by name of the query) or SQL-code,
which should be written separately instead of the name of a query, as I have
written in the Base Handbook.

Note: I have written most of the content of Base Handbook. Base Handbook is
translated to English from the German Base Handbuch. When I have written all
these I haven't detected there is a difference between direct SQL in a query
(which is real direct) and SQL in macros and Tools → SQL. I thought all this
will be the same - but it isn't. If there is a real good argument for the
difference between real direct SQL in a query and SQL in macros and Tools → SQL
I have to change the content of the (German) Handbook here. My opinion: The
difference, which appears here, isn't intended. It is a buggy behavior.

-- 
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/20210802/1c476829/attachment.htm>