https://bugs.documentfoundation.org/show_bug.cgi?id=143656
--- Comment #4 from Robert Großkopf <rob...@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.