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.