[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 #4 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to m.a.riosv from comment #3)
> So you are asking for a change of behavior. I think it works as implemented,
> even we don't like it.

Yes, the behavior should be changed. 
We had a discussion in a German forum. Someone asks for a code of such a query
and I tested this in the query editor. So I answered: This code will work well
in direct SQL, wouldn't work through GUI. 

Answer: No problem - I will use the code in a macro. 

And then: It doesn't work in a macro, it doesn't work in Tools → SQL. This
doesn't make sense, because you couldn't use the features of the GUI, special
direct input of data in a query, with Tools → SQL or macro. You have to send an
INSERT then (or UPDATE for changing content).

We should see if someone knew why it has been implemented in this way. And also
should see how it could be removed, if there couldn't be found any reason for.

-- 
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/20210801/bde0b1fe/attachment.htm>