https://bugs.documentfoundation.org/show_bug.cgi?id=95679
Lionel Elie Mamane <lio...@mamane.lu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |NOTABUG
--- Comment #7 from Lionel Elie Mamane <lio...@mamane.lu> ---
(In reply to robert from comment #6)
> Wrote this in comment 3: A date could not be an empty string. This was wrong
> in all versions up to LO 4.4. Forms worked in an other (right) way than the
> query. This bug has been solved. Please change your code:
> WHERE "TransDate,D" BETWEEN CASE WHEN :DateFrom IS NULL THEN (
> "TLOOKUP"."StartDate" ) ELSE TO_DATE( :DateFrom, 'MM/DD/YY' ) END AND CASE
> WHEN :DateTo IS NULL THEN CURRENT_DATE ELSE TO_DATE( :DateTo, 'MM/DD/YY' )
> END
That rings a bell. I may have changed "empty parameter" to mean NULL rather
than "empty string" (which is coherent with how text boxes behave by default).
I'd consider the previous behaviour as a bug, actually.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
