QTP: OUTPUT AT
Kesterson, Roger
Roger.Kesterson@mtdsw.com
Tue, 18 Sep 2001 07:49:15 -0700
Yes, of course. Thanks!
Just one of those days, I guess...
> -----Original Message-----
> From: nicholas.arniakos@bnpparibas.com
> [mailto:nicholas.arniakos@bnpparibas.com]
> Sent: Tuesday, September 18, 2001 7:36 AM
> To: Roger.Kesterson@mtdsw.com
> Subject: Re: QTP: OUTPUT AT
>
>
>
> QTP updates at the end of a control break (unless you have AT START OF
> statement), but initializes the fields of the record at the
> start of the
> control break. Since you have INITIAL statement, you should
> expect this.
> Change it to FINAL and will be fine.
>
>
>
>
> Internet
> Roger.Kesterson@mtdsw.com@cube.swau.edu - 18/09/2001 16:18
>
>
> Sent by: powerh-l-admin@cube.swau.edu
>
> To: powerh-l
>
> cc:
>
> bcc:
>
>
> Subject: QTP: OUTPUT AT
>
>
> PH 7.10.G2, OpenVMS 7.1
> -----------------------
>
> In the QTP manual, it says that without the START OF option,
> an OUTPUT AT
> action is performed at the end of a transaction group. I have a QTP
> program
> similar to the following:
>
> ACCESS BOM1
>
> SORT ON PARENT_PART ON COMPONENT_PART ON EFFECTIVE_START_DATE
>
> OUTPUT BOM2 ADD AT COMPONENT_PART
> ITEM EFFECTIVE_START_DATE OF BOM2 INITIAL EFFECTIVE_START_DATE OF BOM1
>
> I would have expected the file BOM2 to get the record with the latest
> effective start date, but it actually gets the earliest. The
> effective
> start date is a VMSDATE. I tried converting it to a CHAR*8
> (YYYYMMDD), and
> sorting on that, but got the same results. I didn't get the desired
> results
> until I changed the sort to:
>
> SORT ON PARENT_PART ON COMPONENT_PART ON EFFECTIVE_START_DATE D
>
> This seems to contradict the manual, or is my brain just not
> functioning
> correctly today?
>
> Thanks,
>
> Roger Kesterson
> Senior Programming Analyst
> MTD Southwest, Inc.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
> subscriber.
>
>
>
>
>
> ___________________________________________________________
>
> This message and any attachments (the "message") is intended
> solely for
> the addressees and is confidential. If you receive this
> message in error,
> please delete it and immediately notify the sender.
>
> Any use not in accord with its purpose, any dissemination or
> disclosure,
> either whole or partial, is prohibited except formal approval.
>
> The internet can not guarantee the integrity of this message.
> BNP PARIBAS
> (and its subsidiaries) shall (will) not therefore be liable
> for the message
> if modified.
>
> --------------------------------------------------
> Ce message et toutes les pieces jointes (ci-apres le "message") sont
> etablis a l'intention exclusive de ses destinataires et sint
> confidentiels.
> Si vous recevez ce message par erreur, merci de le detruire
> et d'en avertir
> immediatement l'expediteur.
>
> Toute utilisation de ce message non conforme a sa destination, toute
> diffusion ou toute publication, totale ou partielle, est
> interdite, sauf
> autorisation expresse.
>
> L'internet ne permettant pas d'assurer l'integrite de ce message, BNP
> PARIBAS (et ses filiales) decline(nt) toute responsabilite au
> titre de ce
> message, dans l'hypothese ou il aurait ete modifie.
> ___________________________________________________________
>