QTP in AXIANT 4GL

[Joe Boyle]

both, and many apologies, I should have modified the subject line to reflect
this:)

Regards, Joe.


-----Original Message-----
From: Darren Reely [mailto:darren.reely at latticesemi.com] 
Sent: 08 August 2005 19:28
To: Joe Boyle
Subject: Re: QTP in AXIANT 4GL

Joe,

Which question are you answering. The original message for the subject 
line is at the bottom and does not mention Quiz, only QTP.  If you have 
another conversation going, I kindly suggest changing the subject line.

Or am I confused?

Darren


Joe Boyle wrote:
> Hi Syed,
> 
> the report viewer is simply the blue icon for quiz within Axiant, and you
> execute a compiled report for example by calling a designer proc from a
> command button as below ( there are many alternatives); also, if you
create
> a subfile in one of the report viewer quiz's, you can allow the user to
> print a copy by accessing the original subfile and creating a report file
on
> disk which you can then print,
> 
> PROCEDURE des dqz2
> BEGIN
> 
> run command "quiz auto=SKIP_PAGE_1.qzc"
> run command "quiz auto=SKIP_PAGE_3.qzc"
> run command "quiz auto=SKIP_PAGE_4.qzc"
> 
> END
> 
> As for the QTP problem, you will probably find that you have to specify
> which items link to which as below, otherwise you will get a cross product
> of all rows in all tables,
> 
> 
> can cle
> 
> run n1
> 
> req q1
> 
> ACCESS  Orders link Order_No to Order_No  of Order_Dets
> 
> output orders update
> item order_date final sysdate
> 
> output order_dets update
> item Prod_Price final Prod_Price + 1000
> 
> BUILD batch1
> 
> 
> Also, it's usually much faster to use cursors as in the example below,
> 
> can cle
> run n1
> 
> req q1
> 
> SQL IN example_4gl DECLARE dbquery CURSOR FOR     &
> SELECT order_no FROM Orders  where   not order_date &
> between '0001-01-01' and '2005-08-08'
> 
> access dbquery
> 
> output orders update
> item order_date final sysdate
> 
> BUILD do_order_dates
> 
> 
> 
> Regards, Joe.
> 
> 
> -----Original Message-----
> From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
> [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf
Of
> Syed Shahul Hameed Mustaffa
> Sent: 08 August 2005 14:53
> To: powerh-l at lists.sowder.com
> Cc: Joe Boyle
> Subject: QTP 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
>