accum total by, in a dynamic query

[jmac13]

Hi I'm using open edge 10.2b,

I've got a dynamic query that has break bys in and im wonder if there is any way to use accum total by with a dymanic query? just trying to convert some code from a for each break by to a dynamic query?

if hanQuery:last-of(5)  then           
      assign  w-intQty             = accum total by tt-report.manutype ttreport.intQty

 

[Arnaud_]

Hi,

From Progress help : "Note : You can use the ACCUMULATE statement only in blocks with the implicit looping property."

You can't use it with dynamic query, use variables.

 

[jmac13]

Oh must of missed that in the help. Thought it was the case... I did it the rubbish way in the end, it was horrible. I'll have to think how to do it dynmically when i next get to one cause really dont want lots of variables just makes its rubbish

 

[Arnaud_]

You may can use a temp-table, or an extent variable to don't have to define a lots of variables.