Kbase P19644: How to limit the number of RECORDS returned in a for each st
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2003 |
|
Status: Unverified
GOAL:
How to limit the number of RECORDS returned in a for each statement.
CAUSE:
FOR EACH returns all records.
FIX:
Change the for each to the following syntax;
Define Variable ctr as integer no-undo.
FOR EACH first customer where (Custnum > ctr) and (Custnum < ctr + 20) :
Display Custnum Name.
END.
Assign CTR = Custnum.
For subsequent it will start with the last displayed customer.