LAST-OF function

LAST-OF function

Returns a TRUE value if the current iteration of a DO, FOR EACH, or REPEAT . . . BREAK block is the last iteration for a particular value of a break group.

Syntax
LAST-OF ( break-group ) 
break-group

The name of a field or expression you named in the block header with the BREAK BY option.

Example

This procedure uses LAST-OF to display a single line of information on each Item.CatPage group in the Item file, without displaying any individual item data. It produces a report that shows the aggregate value OnHand for each catalog page.
r-lastof.p
FOR EACH Item NO-LOCK BREAK BY Item.CatPage: 
  ACCUMULATE Item.OnHand * Item.Price (TOTAL BY Item.CatPage). 
  IF LAST-OF(Item.CatPage) THEN  
    DISPLAY Item.CatPage (ACCUM TOTAL BY Item.CatPage  
      Item.OnHand * Item.Price) LABEL "Value-oh". 
END. 
See also

FIRST function, FIRST-OF function, LAST function

LAST-OF ( `break-group` )

r-lastof.p
FOR EACH Item NO-LOCK BREAK BY Item.CatPage: ACCUMULATE Item.OnHand * Item.Price (TOTAL BY Item.CatPage). IF LAST-OF(Item.CatPage) THEN DISPLAY Item.CatPage (ACCUM TOTAL BY Item.CatPage Item.OnHand * Item.Price) LABEL "Value-oh". END.

OpenEdge Release 10.2B