Kbase P85531: How to implement a SELECT DISTINCT In Progress 4GL.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/23/2004 |
|
Status: Unverified
GOAL:
How to implement a SELECT DISTINCT In Progress 4GL.
FIX:
Use the FIRST-OF function. For example if you want to display each distinct order (according to the field cust-num) you may write:
FOR EACH order BREAK BY cust-num.
IF FIRST-OF(cust-num)
THEN DISPLAY order. /* here your OUTPUT */
END.