Kbase P130240: LAST-OF(Function(AggregateField)) will raise error 574
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/9/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
LAST-OF(Function(AggregateField)) will raise error 574
** BREAK keyword or BY phrase missing for aggregate expression. (574)
CAUSE:
This is expected behavior.
FIX:
In way to be able to use a function with the LAST-OF you need to reference the Function in the Aggregate field of the BREAK BY.
For example:
FOR EACH customer USE-INDEX NAME BREAK BY substring(NAME,1,1):
IF LAST-OF(SUBSTRING(NAME,1,1)) THEN.
END.