[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 bugzilla-daemon at bugs.documentfoundation.org
Wed Aug 4 05:55:52 UTC 2021


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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=14
                   |                            |0298

--- Comment #11 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Lionel Elie Mamane from comment #9)
> 
> 	oSQL_Statement.EscapeProcessing = False
> 
You are right, works well in the attached database. Don't know why it has
something to do with escaping, because there is changed a '*' for a '%' …

> As to "Tools/SQL", it would be useful to have in this dialog a checkbox to
> enable/disable escape processing, too. The UI can present it as "Run SQL
> command directly" to be consistent with the Query Design UI.

TOOLS → SQL should be improved a little bit. See  bug 140298. So it would be
good to add such a checkbox.

-- 
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/20210804/ed206d37/attachment.htm>


More information about the Libreoffice-bugs mailing list