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

[David Morrison - Corporate]

Syed,

I don't know that environment, so this may not be applicable, but I've found that this type of QTP program runs much faster if you break it into 2 requests:

	Request step1
	
 	Access transfer-D
	
	Select transfer-D if ...

	Subfile include keyfields

	Request step2

	Access subfile link to other files

Thanks.

David Morrison
McBride Electric

-----Original Message-----
From: powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com
[mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com]
On Behalf Of Syed Shahul Hameed Mustaffa
Sent: Monday, August 08, 2005 6:51 AM
To: powerh-l at lists.sowder.com
Cc: Joe Boyle
Subject: Re: Displaying Reports on a screen, Scheduling - in AXIANT 4GL


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

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.