QTP in AXIANT 4GL

[Joe Boyle]

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

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.