<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Direct SQL: Queries in Tools → SQL and macro give wrong results - direct SQL works well"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143656#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Direct SQL: Queries in Tools → SQL and macro give wrong results - direct SQL works well"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143656">bug 143656</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span></b>
<pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=143656#c5">comment #5</a>)
<span class="quote">> I didn't find exactly, but should be possible to run the sql as direct in a
> macro.
> In <a href="https://wiki.documentfoundation.org/images/b/b0/BH5009-Macros.pdf">https://wiki.documentfoundation.org/images/b/b0/BH5009-Macros.pdf</a>, page
> 71 shows how to enable direct sql for mail-merge.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>