Link 2 subfiles in QTP?
Pickering, John (NORBORD)
PICKERIJ@norbord.com
Thu, 13 Apr 2000 17:01:22 -0400
You can link 2 direct files (e.g. non-indexed subfiles) by record number as
in:
> access *a link to record(xxx) of *b
but you need to know the value of xxx or have it in subfile a.
Probably what you want to do your example is end up with a subfile such as:
order number
product
vendor name
You can easily do this by writing out the first subfile with a blank vendor
name and then appending the second subfile to the first with a blank product
code. Then sort the resulting file on order number and write a new subfile
at order number. Use the maximum function to get both product and vendor
name in the final subfile.
Regards,
JWP
> -----Original Message-----
> From: Scott, Valerie [SMTP:vscott@solanocounty.com]
> Sent: Thursday, April 13, 2000 4:54 PM
> To: powerh-l@lists.swau.edu
> Subject: Link 2 subfiles in QTP?
>
>
> Is it possible to link 2 direct access (non indexed) subfiles in QTP ver
> 8.09?
> How would I make the explicit linkage?
> Is it possible to do this? I am still learning Powerhouse, if you
> couldn't
> tell.
>
> simple example:
> subfile a
> item 1 order number
> item 2 product
>
> subfile b
> item 1 order number
> item 2 vendor name
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.