Kbase P32856: How to conditionally list a parent table records only when a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/07/2003 |
|
Status: Unverified
GOAL:
How to conditionally list a parent table records only when a child table record is found to satisfy a given condition?
FIX:
The following FOR EACH statement will list only the orders where at least one orderline of that order has an ExtendedPrice that exceeds 100000 in value:
FOR EACH order NO-LOCK,
FIRST orderline OF order WHERE ExtendedPrice > 100000 NO-LOCK BY order.ordernum:
DISPLAY order.ordernum Orderline.Linenum Orderline.Itemnum Price Qty Orderline.ExtendedPrice.
END.