powerh-l Digest, Vol 49, Issue 3

[Alan and Vicki]

Hey Peter - long time no see!

Assuming the DUPCHK subfile contains the original check number, could you 
not eliminate the ALIAS altogther and use the subfile item as the reference?

eg.

>ACCESS *DUPCHK &
>OUTPUT IA_DIST_CHECK UPDATE  &
>   VIA CHECK_# of DUPCHK
>    ON ERRORSREPORT                         ; just in case a check is 
> missing
>  ITEM CHECK_# OF IA_DIST_CHECK_UPD FINAL &
>   "9" + CHECK_# OF DUPCHK[2:8]
>
Regards,

Vicki Robertson

>
>
> Today's Topics:
>
>   1. losing my pointer in a QTP update? (Richard Witkopp)
>   2. RE:losing my pointer in a QTP update? (Peter Bateman)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 12 Jun 2009 14:28:02 -0700
> From: "Richard Witkopp" <RWitkopp at phxa.com>
> Subject: losing my pointer in a QTP update?
> To: powerh-l at lists.sowder.com
> Message-ID:
> <FF5DC4E9EF39AB489EC56BBC4962CA820129E226 at p28exch1.phxa.com>
> Content-Type: text/plain; charset=utf-8
>
> ------------------------------
>
> Message: 2
> Date: Sat, 13 Jun 2009 12:15:27 -0300
> From: Peter Bateman <peterbateman808 at hotmail.com>
> Subject: RE: losing my pointer in a QTP update?
> To: Richard Witkopp <rwitkopp at phxa.com>, PowerHouse List
> <powerh-l at lists.sowder.com>
> Message-ID: <BAY133-W11183574CD05AA3A57CF17F9400 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> Hi Richard:
>
>
>
> ; I would try to get IA_DIST_CHECK out of the ACCESS statement
>
> ; My guess is you have duplicate check numbers. Thus your scratch file
>
> ; will contain the cross product of duplicate check numbers in DUPCHK
>
> ; and IA_DIST_CHECK.
>
> ;
>
>  ACCESS *DUPCHK
>  OUTPUT IA_DIST_CHECK UPDATE ALIAS IA_DIST_CHECK_UPD &
>   VIA CHECK_# &
>
>   USING CHECK_# OF IA_DIST_CHECK &
>
>  ON ERRORSREPORT                         ; just in case a check is missing
>  ITEM CHECK_# OF IA_DIST_CHECK_UPD FINAL &
>   "9" + CHECK_# OF IA_DIST_CHECK[2:8]
>
>
>
> Regards,
>
> Peter Bateman
>
>
>
>
> _________________________________________________________________
> Internet explorer 8 lets you browse the web faster.
> http://go.microsoft.com/?linkid=9655582
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> http://lists.sowder.com/pipermail/powerh-l/attachments/20090613/8712159d/attachment.html
>
> ------------------------------
>
> -- 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: &quot;subscribe&quot; in message body to 
> powerh-l-request at lists.sowder.com
> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
> list archive at Google.
>
> End of powerh-l Digest, Vol 49, Issue 3
> ***************************************
>