davidvilla
Member
Hi,
I am trying to break a query by a return value from a function. The results are good, except that i am not able to use a last-of or first-of. It gives me a error -** BREAK keyword or BY phrase missing for aggregate expression. (574).
for each mytable where mytable.field1 = true break by myfunction(input mytable.field2):
if last-of(myfunction(input mytable.field2)) then display mytable.
end.
If i display mytable without the last-of - iam getting the records in the desired order. But I am not able to a last-of operation with it.
Please help. I am using Progress 11.2 in a chui unix box.
Thanks.
I am trying to break a query by a return value from a function. The results are good, except that i am not able to use a last-of or first-of. It gives me a error -** BREAK keyword or BY phrase missing for aggregate expression. (574).
for each mytable where mytable.field1 = true break by myfunction(input mytable.field2):
if last-of(myfunction(input mytable.field2)) then display mytable.
end.
If i display mytable without the last-of - iam getting the records in the desired order. But I am not able to a last-of operation with it.
Please help. I am using Progress 11.2 in a chui unix box.
Thanks.