QTP question.

[Joe Boyle]

No, not as it stands at the moment; you need to either recode to access a
table, or modify your syntax to use direct access.

Regards, Joe.



-----Original Message-----
From: Syed Shahul Hameed Mustaffa [mailto:sshahulgm at gmail.com] 
Sent: 27 August 2005 17:08
To: atla38 at dsl.pipex.com; Bob.Deskin at cognos.com
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.
> 
>