QTP in AXIANT 4GL

[Darren Reely]

Syed,

Powerhouse has no 'magic' engine to move from the select statement what 
  it could to the SQL query that gets generated. So you have to figure 
it out for your self and code appropriately.

Try changing your SELECT to a CHOOSE statement. Such as;

#Assumming all of these columns are in the TRANSFER-D table.
Choose TRNFR-DATE parm range prompt "Enter Date Range: " t time &
	,TRNFR-NEW-NO parm range prompt "Enter Unit No.: " 1 time &
	,TRNFR-TYPE "U" &  ;;on solaris boxes constants must be last!
	,TRNFR-SUB-TYPE "U"

I doubt SQL Server uses minus signs, so those should be underscores.

As someone else mentioned. SQL cursors can do wonders.

Darren


Syed Shahul Hameed Mustaffa wrote:
> 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
>