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
