[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2016-04-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 Jean-Baptiste Faure changed: What|Removed |Added CC||jbfa...@libreoffice.org

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 --- Comment #8 from Dave --- (In reply to robert from comment #6) > (In reply to Dave from comment #4) > > > > This query has worked fine in all libre base versions up to and including > > ver 3.7 In ver 4.0 it did not work at all Ver 4

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 Lionel Elie Mamane changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 --- Comment #6 from rob...@familiegrosskopf.de --- (In reply to Dave from comment #4) > > This query has worked fine in all libre base versions up to and including > ver 3.7 In ver 4.0 it did not work at all Ver 4.4 and above it runs but

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 --- Comment #5 from Dave --- I forgot this The query can only be edited in sql Mode -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 --- Comment #4 from Dave --- Hi Thx for all the responses! The reports have nothing to do with the problem sorry I left them in. If you run the query it should ask you for 2 dates a begining and and ending date. The DateFrom and Date

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 --- Comment #3 from rob...@familiegrosskopf.de --- Hi Dave, you are using parameters like :DateFrom = '' There had been a difference between using parameters for a query and in a subform. This behaviour hat been changed. A date could neve

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 --- Comment #2 from Alex Thurgood --- CC'ing other db people. Maybe others can make more sense of this. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice

[Libreoffice-bugs] [Bug 95679] CASE WHEN does not work with the BETWEEN function in Base versions greater than 3.7

2015-11-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 Alex Thurgood changed: What|Removed |Added Summary|Case when does not work |CASE WHEN does not work

[Libreoffice-bugs] [Bug 95679] Case when does not work with the between function in base versions greater than 3.7

2015-11-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=95679 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0