Post a Comment On: Programming Solution

/*Sample Query to fetch data with date range*/

Define variable m_date  as Date no-undo.
Define variable m_date1 as Date no-undo.

Repeat:
    Assign
      m_date  = ?
      m_date1 = ?.

      update m_date m_date1 with frame a side-label.
     
      IF m_date  = ? THEN m_date1 = low_date.
      IF m_date1 = ? THEN m_date1 = hi_date.
     


     FOR EACH tr_hist where tr_domain = global_domain and tr_effdate >= m_date and tr_effdate <= m_date1 no-lock :
     
     END.

     

End.