https://bugs.freedesktop.org/show_bug.cgi?id=77897
--- Comment #4 from Gerard Bekking <[email protected]> --- I think the GUI recognized the code all right and it execute it properly, only when saved or when switched to SQL (and switched back) the code is changed in the GUI and can't be executed. While designing and testing everything works fine. The manual state that tekst with spaces should always be in quotes, that is why I found this. My workaround is replacing all spaces with underscore so quotes are avoided. On Fri, 25 Apr 2014 19:14:57 +0000 [email protected] wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=77897 > > [email protected] changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > CC| > |[email protected] > > --- Comment #3 from [email protected] --- > (In reply to comment #2) > > > I modified your database to include date-fields. > > Problem returned. After saving the design the query wil not function > > anymore in edit mode. It will function corectly in sql-mode > > After opening in edit-mode you can't save anymore due to a > > syntax-error. In SQL-mode there is no problem. > > It seems to be the subquery in Criterion which couldn't be > interpreted by the GUI. I have tried to remove the quotes in the > SQL-view. Works with square brackets instead. > > The difference between square brackets and quotes is not the problem > for the GUI, as you could see in my example. > > The problem I see: The GUI doesn't recognize the code, but will > accept it when the query will be executed without switching to direct > SQL. > > We need more examples and should change the title of this bug - or > create a new which show, when a query isn't executed in > GUI-design-mode, but with switched off design. > -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
