https://bugs.documentfoundation.org/show_bug.cgi?id=143656
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|1 |0 Status|NEW |UNCONFIRMED --- Comment #9 from Lionel Elie Mamane <[email protected]> --- (In reply to Robert Großkopf from comment #0) > Expected behavior: Query_direct_SQL should show the same content as Tools → > SQL and queries in a macro. No, that's not the documented behaviour. In the macro, to disable escape processing (that is, to do the query as "direct SQL"), insert a line oSQL_Statement.EscapeProcessing = False after oSQL_Statement = oConnection.createStatement() but before oResult = oSQL_Statement.executeQuery(stSql) 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. -- You are receiving this mail because: You are the assignee for the bug.
