Differences between Valentina 1 and 2

Robert Brenstein rjb at robelko.com
Tue Nov 7 23:17:56 CST 2006


>I tried many things but nothing worked. It seems that Boolean Values can no
>longer be added (I wanted to know how many records have Stat1 and Stat2 set
>to TRUE). I tried to use "sum(IF(Stat1, 1, 0))" but that always returns 1.
>I tried to use "sum(case Stat1 when True then 1 when False then 0 end)",
>but this also doesn't work.

Have you considered converting boolean to byte?


More information about the Valentina mailing list