This is as a follow up for the previous question…. It looks like I made a wrong assumption that ‘accumulate’ can work on multiple columns:

                        Integer ( intValue > 0) from accumulate (

                                    Record ( f1 == $f1, f2 < 10, $value1 : value )

                                    Record ( f1 == $f1, f2 >= 10, $value2 : value )

                                    Init ( int sum = 0; ),

                                    Action ( sum += $value1 - $value2 ),

                                    Result ( new Integer (sum) )

                        )

I’m getting an error (‘then’ is expected or smth like that at the point where the second ‘Record’ is defined) and the only way to remove the error is to declare one and only one Column constraint… So, it is not possible then to use multiple columns in ‘accumulate’? If not, then it would be even more interesting to get some idea on how to approach the kind of problem I mentioned in the previous post…..

Thanks,

Vlad