[Progress Communities] [Progress OpenEdge ABL] Forum Post: for each break by skip

  • Thread starter Thread starter rayherring
  • Start date Start date
Status
Not open for further replies.
R

rayherring

Guest
Using OpenEdge 11.2 on Linux, is there a way when doing a "FOR EACH" with a "BREAK BY" to skip a block of records? I have the following: inv-blk: FOR EACH InvHeader_DT NO-LOCK WHERE InvHeader_DT.Store_ID = 1 AND InvHeader_DT.Invoice_Date >= 11/01/2017 AND InvHeader_DT.Invoice_Date <= 11/30/2017 BREAK BY InvHeader_DT.Customer_ID: FIND Customer NO-LOCK WHERE Customer.Customer_ID = InvHeader_DT.Customer_ID NO-ERROR. IF Customer.Hide_From_GST_Report THEN DO: MESSAGE "Hide Customer " Customer.Customer_ID. NEXT inv-blk. END. DISPLAY InvHeader.Customer_ID. END. The problem is that I need it to just skip over every single invoice for that customer who has that flag set. I tried by putting the flag check in with the 'FOR EACH' by having 'FOR EACH ..., FIRST CUSTOMER' but that just made it take a little bit longer. The current method takes about 2secs, having a 'first' in with the 'for each' made it take about 4secs.

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