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