QTP question...

[Oran Shapitka]

More than likely POST-DATE exists in both the subfile and in the TRANS file.
Try to fully qualify your fields and then try again.  POST-DATE OF TRANS or
POST-DATE OF HIST2

Oran Shapitka, I.S.P.
Intertech Business Systems, Inc.
1564, 10303 Jasper Ave	Email:	oran@intertechsystems.com
Edmonton, AB  T5J 3N6  Canada	Voice:	(780) 413-0400	Fax:	(780) 413-0398

<http://www.intertechsystems.com/>


-----Original Message-----
From: owner-powerh-l@sphere.swau.edu
[mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Art Bahrs
Sent: Monday, December 04, 2000 3:07 PM
To: Power House ListServ
Subject: QTP question...


Hi All :)
   Ok.... Newbie question:  Why can't QTP find my fields referenced in the
IF clause of a OUTPUT statement?

Source Code:
   17     RUN HIST5
   18
   19     REQUEST HIST5 ON CALCULATION ERRORS REPORT ON EDIT ERRORS REPORT
   20
   21     SET PROCESS LIMIT 9999999 LOCK FILE UPDATE
   22
   23     ACCESS *HIST2.SUBFILE
   24
   28     DEFINE D-DATE-START CHAR*8 = GETSYSTEMVAL("HSTSTRDT")
   29
   30     DEFINE D-DATE-END   CHAR*8 = GETSYSTEMVAL("HSTENDDT")
   30.1
   37     OUTPUT TRANS DELETE ON ERRORS REPORT &
   37.1                VIA ACCOUNT USING ACCOUNT OF HIST2 &
   38                  IF ((POST-DATE >= D-DATE-START) AND &
   39                      (POST-DATE <= D-DATE-END) AND &
   40                      (TRANS-TYPE[2:1] = "1") AND &
   41                      (SERV <> "H-BAL"))
   43
   44     BUILD HIST5TST.OBJQ

Compile Try in QTP:
> RUN HIST5
>
> REQUEST HIST5 ON CALCULATION ERRORS REPORT ON EDIT ERRORS REPORT
>
> SET PROCESS LIMIT 9999999 LOCK FILE UPDATE
>
> ACCESS *HIST2.SUBFILE
*W* PowerHouse name for HIST2.SUBFILE is HIST2.
>
> DEFINE D-DATE-START CHAR*8 = GETSYSTEMVAL("HSTSTRDT")
>
> DEFINE D-DATE-END   CHAR*8 = GETSYSTEMVAL("HSTENDDT")
>
> OUTPUT TRANS DELETE ON ERRORS REPORT &
>              VIA ACCOUNT USING ACCOUNT OF HIST2 &
>              IF ((POST-DATE >= D-DATE-START) AND &
*E* Can't find item named POST-DATE.
>                  (POST-DATE <= D-DATE-END) AND &
*E* Can't find item named POST-DATE.
>                  (TRANS-TYPE[2:1] = "1") AND &
*E* Can't find item named TRANS-TYPE.
>                  (SERV <> "H-BAL"))
*E* Can't find item named SERV.
*W* Linkage should be via a unique key/index if the file is output only.
>
> BUILD HIST5TST.OBJQ
*E* There were errors in the source code. BUILD wasn't performed.

The Trans file is defined in the dictionary and the fields POST-DATE,
TRANS-TYPE & SERV exist in Trans.  The HIST2.SUBFILE file exists in the
current account.
 I have a file equation set for the database holding TRANS and for the
Dictionary....

Art "Confused again! hehe" Bahrs

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.