[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from o...@openoffice.org Thu Oct 21 11:16:54 + 2010 --- case when is implemented in 3.3 only. -

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 11:13:07 + 2010 --- I verified your workaround does indeed work in OOo 3.3.0, but not OOo 3.2

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 11:01:40 + 2010 --- Are you sure this works? I copied your workaround into the database, and

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from o...@openoffice.org Thu Oct 21 10:50:56 + 2010 --- I found a work around which you could use. You have to replace the casewhen() fu

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from f...@openoffice.org Thu Oct 21 09:52:09 + 2010 --- Okay, I withdraw my statement 'bout the workaround :( -

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:47:46 + 2010 --- Created an attachment (id=72129) Incorrect.pgn - results from query when

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:46:29 + 2010 --- Here is screenshot of query results when NULL is replaced by 0.

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:43:27 + 2010 --- Created an attachment (id=72128) Correct.pgn screenshot of good results f

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:41:19 + 2010 --- I am attaching a screenshot of what the query "NEW Averages By Month" sho

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from f...@openoffice.org Thu Oct 21 09:25:21 + 2010 --- oh, sorry - I just noticed that even in 3.2, NULL effectively delivers "0", and

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 09:13:06 + 2010 --- Just for the record, replacing NULL with 0 in my queries allows the queri

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 User fs changed the following: What|Old value |New value

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 07:43:17 + 2010 --- It seems that my queries that are failing are due to NULL not being valid

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 07:16:29 + 2010 --- I eill attach my database Blood Sugars. There are a lot of queries, most

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from jgsylves...@openoffice.org Thu Oct 21 07:18:14 + 2010 --- Created an attachment (id=72125) Blood Sugars.odb -

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 --- Additional comments from f...@openoffice.org Thu Oct 21 06:46:53 + 2010 --- cannot reproduce using something like SELECT "n", casewhen( mod( "n", 2 ) = 1,

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 User r4zoli changed the following: What|Old value |New value ==

[dba-issues] [Issue 115165] Base in 3.3 release candi date no longer handles casewhen construct in s ql queries

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165 Issue #|115165 Summary|Base in 3.3 release candidate no longer handles casewh |en construct in sql queries