Displaying Reports on a screen, Scheduling - in AXIANT 4GL

[Syed Shahul Hameed Mustaffa]

Dear Gurus,

Quick Intro: I'm migrating PH/MPEIX application to AXIANT-4GL/WINDOWS.

The following QTP statement, 

access TRANSFER-D  in cwdb                        &                     
          link to COW-D   in cwdb                 &                     
          link to COW-LOC-D    in cwdb            &                     
          link UNIT-NO of COW-LOC-D to UNIT-M  in cwdb   
      
select TRANSFER-D if                              &                     
          TRNFR-DATE ge TRAN-DT-FR      and       &                     
          TRNFR-DATE le TRAN-DT-TO      and       &                     
          TRNFR-TYPE eq "U"             and       &                     
          TRNFR-SUB-TYPE eq "U"         and       &                     
          TRNFR-NEW-NO ge UNIT-NO-FR    and       &                     
          TRNFR-NEW-NO le UNIT-NO-TO                                    
        
  is retrieving all the records of all the tables linked first and
then select specific records out of the entire set. I am have a
relational db (SQL SERVER). Is there any way stop this sequential
access of all records and only select those records I need.

Thanks & Best Regards,
SYED