This selection is based on a higher file in the ACCESS list

[Maloney, Charlie]

Hello Charles:

Just some background info about QUIZ/QTP.  This is just an overview, but
it'll do for now...

In QUIZ/QTP:

The SELECT FILE IF statement accepts/rejects records from input buffers
BEFORE the records subsequent to it in the ACCESS statement are read.

In your case this means that we test the TRANSACTION-DATA record before we
read the SARTYPE-DATA records to which the TRANSACTION-DATA record will be
linked.

To perform a test which includes the named record buffer and one SUBSEQUENT
to it in the ACCESS statement, your three simplest options may be:

   (1) change the order of the files in the ACCESS statement and try a
SELECT FILE IF again
   (2) do some subfile work 
   (3) use the SELECT IF statement

You should test each method to determine which works best with your data
values and your data volumes.

SELECT FILE IF may reference data in the named record and any records
PRECEEDING the named record in the ACCESS statement.  It just can't
reference data from records SUBSEQUENT to it in the ACCESS statement.

You may use one SELECT FILE IF statement for each record named in the ACCESS
statements.

You may think of the SELECT IF statement as referencing the entire record
complex, after all SELECT FILE IF statements have taken place. 

In QTP you may also use one SELECT FILE IF statment for each "OUTPUT
<file/record> UPDATE" and each "OUTPUT <file/record> DELETE".  In QDESIGN
you may use one SELECT FILE IF statement for each of the files/records in
the data section.

Hope this helps,

Charlie Maloney
Cognos Corporation
Partner Operations Technical Acct Mgr


-----Original Message-----
From: Charles Lewis [mailto:lewisc@swau.edu]
Sent: Thursday, January 28, 1999 10:22 AM
To: powerh-l@lists.swau.edu
Subject: This selection is based on a higher file in the ACCESS list


Why can't you select a record structure given criteria in it is linked to?

Example:

Access *IDNUMS link to TRANSACTION-DATA link to SARTYPE-DATA
Select TRANSACTION-DATA if AID of SARTYPE-DATA = "Y"

I need to be able to report every record from IDNUMS and include any aid
transactions (if they exist). What is the workaround? Do I have to create
yet
another subfile?

====================================
Charles Lewis
Director of Administrative Computer Services
Southwestern Adventist University
PO Box 567
Keene, TX 76059

Phone: (817) 645-3921 #220
Fax: (817) 556-4744
Email: lewisc@swau.edu
====================================


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
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
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.