Kbase P19884: What is the behavior of the ACCUMULATE statement with no records ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/18/2009 |
|
Status: Verified
GOAL:
What is the behavior of the ACCUMULATE statement with no records ?
GOAL:
What does the ACCUM function return when there are no records in the ACCUMULATE iteration block?
GOAL:
Behavior of ACCUMULATE TOTAL AVERAGE COUNT MAXIMUM MINIMUM, when there are no records during the iterations of the block.
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Progress ACCUMULATE statement behaves in this way when there are no records to evaluate:
ACCUM AVERAGE is 0
ACCUM TOTAL is 0
ACCUM COUNT is 0
ACCUM MAXIMUM is ?
ACCUM MINIMUM is ?
Be aware that ? returned by ACCUM MINIMUM and ACCUM MAXIMUM is not your 'standard' 4GL/ABL UNKNOWN value. Consequently, comparing ? returned from these two functions with ? returns NO. and comparing UNKNOWN returned from ACCOUNT MINIMUM and ACCOUNT MAXIMUM returns also NO.