[progress Communities] [progress Openedge Abl] Forum Post: Re: Calculate No.of Records

  • Thread starter Thread starter pliscki
  • Start date Start date
Status
Not open for further replies.
P

pliscki

Guest
DEFINE VARIABLE iTotalRec AS INTEGER NO-UNDO. DEFINE VARIABLE iTotalRecFiltered AS INTEGER NO-UNDO. FOR EACH uwm100 NO-LOCK WHERE uwm100.trndat >= 12/29/14 AND uwm100.trndat 0 THEN iTotalRecFiltered = iTotalRecFiltered + (ACCUM COUNT BY uwm100.poltyp uwm100.prem_t). END. /* gets the total number of records from the whole table */ iTotalRec = (ACCUM COUNT uwm100.prem_t).

Continue reading...
 
Status
Not open for further replies.
Back
Top