QTP question.

[Deskin, Bob]

A non-indexed subfile can be linked using the record number. However, in practise this is typically used only for a single record file. An alternative is to put enough data in the subfile so that it can be used as the driver for the linkage, i.e. the primary file in the ACCESS.

Bob

-----Original Message-----
From: Syed Shahul Hameed Mustaffa [mailto:sshahulgm at gmail.com]
Sent: August 27, 2005 12:08 PM
To: atla38 at dsl.pipex.com; Deskin, Bob
Cc: powerh-l at lists.sowder.com
Subject: Re: QTP question.


Dear Joe, Bob,

If I remove the index keyword, then, I could not use the subfile in
the subsequent requests to link with other tables. Am I correct?

Regards,
SYED

On 8/26/05, Joe Boyle <atla38 at dsl.pipex.com> wrote:
> I can see that Bob's option is the easiest to implement, but you could
> always implement the direct access method to subfiles; the disadvantage is
> that this will only work for single segment numeric indexes.
> 
> The access syntax for this approach would be as follows,
> 
> 'link to record COMPUTER_NO of *$UEV_SUBFILE_PATH\CW877SF1'
> 
> but there would be no pre-sorting capabilities as is the case when accessing
> subfiles via indexes.
> 
> To use the option above you would have to create a subfile with at least as
> many records as you have COMPUTER_NO's, and instead of writing the subfile
> from qtp, you would process a 'output update' run against the subfile etc...
> 
> 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: 25 August 2005 17:33
> To: powerh-l at lists.sowder.com
> Cc: Joe Boyle
> Subject: QTP question.
> 
> Dear Gurus,
> 
> Quick Intro: I'm migrating PH/MPEIX application to AXIANT-4GL/WINDOWS.
> 
> Please look at the following excerpt of code.
> ;---------------------------------------------------------------------------
> ------------
> request Extract-Rexam-Record
> 
> access REEXAM_D IN CWDB &
>       link COMPUTER_NO to COMPUTER_NO of EVENT_D IN CWDB
> 
> choose EPISODE_TYPE "EXAM"
> 
> select if CW_DATE of REEXAM_D ge RX-DATE-FR and &
>          CW_DATE of REEXAM_D le RX-DATE-TO and &
>          EVENT_ACRONYM of REEXAM_D eq EVENT_ACRONYM of EVENT_D
> 
> subfile $UEV_SUBFILE_PATH\CW877SF1  KEEP include     &
>        COMPUTER_NO of EVENT_D,           &
>        EVENT_ACRONYM of EVENT_D,         &
>        COMMENTS of EVENT_D,              &
>        ED_DATE of EVENT_D,               &
>        CW_DATE    &
>       index COMPUTER_NO ;segment COMPUTER_NO  ;<---- THIS LINE
> 
> request Create-Final-Subfile
> 
> access   COW_LOC_D  IN CWDB                          &
>   link UNIT_NO to UNIT_NO of UNIT_M  IN CWDB  &
>   link CLD_COMPUTER_NO to CLD_COMPUTER_NO of COW_D IN CWDB &
>  link CLD_COMPUTER_NO to COMPUTER_NO of *$UEV_SUBFILE_PATH\CW877SF1
> ;<---- THIS LINE
> ;---------------------------------------------------------------------------
> ----------
> 
> The lines I have marked as THIS LINE cannot execute without a DISAM license.
> How can I rewrite this code to execute without a DISAM license.
> 
> I'd appreciate every effort to help me out in this issue.
> 
> 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 &lt;password&gt;" 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.
> 
> 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.