Problem updating last record written at sort break in QTP
Joe Boyle
atla38@dsl.pipex.com
Thu, 9 Dec 2004 19:41:57 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C4DE27.26307FE0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
It looks like the tran-key value will exist at the end of the request coz
you have written three rows containing it via the Oo-trx output buffer.
I think you will have to code something like that below to achieve what you
want, this will ensure that there is a record to retrieve just before the
inner sort break initialization is performed on item ITEM-NO,
Define d-outer-item-no = ITEM-NO
SORT ON d-outer-item-no , ITEM-NO
OUTPUT TRANSACTIONS ADD ALIAS INITOo AT start of d-outer-item-no &
VIA TRAN-KEY USING "Oo" + ITEM-NO + PR-PREFIX
Regards, Joe.
This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Tim Cummings
Sent: 09 December 2004 19:11
To: Cognos Powerhouse List (E-mail)
Subject: RE: Problem updating last record written at sort break in QTP
I'm not allowed to send out actual code, so I have to cut out some stuff
and change the names of other stuff. The code below is all I can share.
The problem I believe the problem is in the phases of QTP processing (I'm
guessing).
Tim
CAN CLE
ACCESS ORDER-ITEMS &
LINK XXX OF ORDER-ITEMS &
TO PR-XXX OF XXX-RATIO
DEFINE SPOILED-CREDITS INTEGER SIGNED SIZE 4 = BR-CREDITS of order-items
&
* QUANTITY-ON-HAND of
order-items &
* (PR-PERCENT of XXX-ratio /
100)
TEMPORARY CREDIT-TOTAL NUM*8
SORT ON ITEM-NO
ITEM CREDIT-TOTAL SUBTOTAL SPOILED-CREDITS RESET AT ITEM-NO
OUTPUT TRANSACTIONS ADD NOITEMS ALIAS Oo-TRX
ITEM UNIT OF Oo-TRX INITIAL "9999999999"
ITEM TRAN-KEY OF Oo-TRX INITIAL "Oo" + ITEM-NO + PR-PREFIX
ITEM CREDITS OF Oo-TRX FINAL SPOILED-CREDITS
OUTPUT TRANSACTIONS UPDATE ALIAS LASTOo AT ITEM-NO &
VIA TRAN-KEY USING "Oo" + ITEM-NO + PR-PREFIX &
IF 0 <> (BR-CREDITS * QUANTITY-ON-HAND - CREDIT-TOTAL)
ITEM CREDITS OF LASTOo = CREDITS OF LASTOo+ ((BR-CREDITS *
QUANTITY-ON-HAND - CREDIT-TOTAL * -1))
GO
Executing request 1 ...
----------------------------------------------------------------------------
---
Cannot find record with this key/index value.
[3]
File: LASTOO
Linkitem: UNIT
Linkitem: LINK-UNIT
Linkitem: TRAN-KEY Oo1000105920
Action Taken: Run terminated.
----------------------------------------------------------------------------
---
Records read:
ORDER-ITEMS 5,790
XXX-RATIO 3
Transactions processed: 3
Records processed: Added Updated Unchanged
Deleted
ORDER-ITEMS 0 0 0
0
OO-TRX 3 0 0
0
LASTOO 0 0 0
0
Finished.
>
-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison@mcbrideelectric.com]
Sent: Thursday, December 09, 2004 1:39 PM
To: Tim Cummings; Cognos Powerhouse List (E-mail)
Subject: RE: Problem updating last record written at sort break in QTP
Tim,
I'm not sure what's causing the QTP error; I think you need to include more
of the program (e.g., the reference to LastOq).
Side issues: Using " * .01 " may be faster and/or more accurate than " /
100", and there's no need to ever multiply by -1.
Thanks.
David Morrison
------=_NextPart_000_000C_01C4DE27.26307FE0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Problem updating last record written at sort break in QTP</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:r_ansi;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>It looks like the tran-key value =
will
exist at the end of the request coz you have written three rows =
containing it
via the Oo-trx output buffer.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I think you will have to code =
something like
that below to achieve what you want, this will ensure that there is a =
record to
retrieve just before the </span></font><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>inner sort break
initialization is performed on item ITEM-NO,</span></font><font size=3D2
color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Define =
</span></font><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'>d-outer-item-no =3D ITEM-NO<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>SORT ON =
d-outer-item-no
, ITEM-NO<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p>=
</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>OUTPUT
TRANSACTIONS ADD ALIAS INITOo AT start of d-outer-item-no =
&</span></font><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'> <br>
</span></font><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy'> VIA =
TRAN-KEY
USING "Oo" + ITEM-NO + PR-PREFIX <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy =
face=3DArial><span
style=3D'font-family:Arial;color:navy'> <o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>This e-mail and all information contained in it is
confidential and may be legally privileged. If you are not the intended
recipient, your access to this e-mail is unauthorized. Any use, =
dissemination,
distribution, publication or copying by you of this e-mail or any of the
information contained within it is prohibited and may be unlawful. Do =
not open
any attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. The content of this e-mail and =
any
attachments sent with it may have been altered without the consent or =
knowledge
of the author.</span></font><o:p></o:p></p>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Tim Cummings<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 09 December 2004 =
19:11<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Cognos Powerhouse =
List
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Problem =
updating last
record written at sort break in QTP</span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier New";color:blue'>I'm not =
allowed
to send out actual code, so I have to cut out some =
stuff</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier New";color:blue'>and =
change the
names of other stuff. The code below is all I can =
share.</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier New";color:blue'>The =
problem I
believe the problem is in the phases of QTP processing (I'm =
guessing).</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>Tim</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'>CAN CLE</span></font><font =
size=3D2
color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'> ACCESS ORDER-ITEMS =
&</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
LINK XXX OF ORDER-ITEMS &</span></font><font size=3D2 color=3Dblue =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
TO PR-XXX OF XXX-RATIO</span></font><font size=3D2 color=3Dblue =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'> </span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'><br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New";color:blue'> =
</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'><br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
DEFINE SPOILED-CREDITS INTEGER SIGNED SIZE 4 =3D BR-CREDITS of =
order-items &</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'> &n=
bsp; &nb=
sp; &nbs=
p;  =
;
* QUANTITY-ON-HAND of order-items &</span></font><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'> &n=
bsp; &nb=
sp; &nbs=
p;  =
;
* (PR-PERCENT of XXX-ratio / 100) </span></font><font face=3DArial><span
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'> TEMPORARY =
CREDIT-TOTAL NUM*8</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'> SORT ON =
ITEM-NO</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'> ITEM CREDIT-TOTAL =
SUBTOTAL
SPOILED-CREDITS RESET AT ITEM-NO</span></font><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> =
</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'> OUTPUT =
TRANSACTIONS
ADD NOITEMS ALIAS Oo-TRX</span></font><font size=3D2 color=3Dblue =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
ITEM UNIT OF =
Oo-TRX
INITIAL "9999999999"</span></font><font size=3D2 color=3Dblue =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
ITEM TRAN-KEY OF Oo-TRX INITIAL
"Oo" + ITEM-NO + PR-PREFIX</span></font><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
ITEM CREDITS OF Oo-TRX
FINAL SPOILED-CREDITS</span></font><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> =
</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New";color:blue'> OUTPUT =
TRANSACTIONS
UPDATE ALIAS LASTOo AT ITEM-NO &</span></font><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
VIA TRAN-KEY USING "Oo" + ITEM-NO + PR-PREFIX =
&</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'><br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
IF 0 <> (BR-CREDITS * QUANTITY-ON-HAND - =
CREDIT-TOTAL)</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>
ITEM CREDITS OF LASTOo =3D CREDITS OF LASTOo+ ((BR-CREDITS * =
QUANTITY-ON-HAND -
CREDIT-TOTAL * -1))</span></font><font size=3D2 color=3Dblue =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue'>GO</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi;color:blue'>Executing request 1 =
...</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'>-----------------------------------=
--------------------------------------------</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'>Cannot find record with this =
key/index
value. &=
nbsp; &n=
bsp;
[3] </span></font><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'><br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> File: =
LASTOO</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'><br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
Linkitem:
UNIT</span></font><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
Linkitem:
LINK-UNIT</span></font><font size=3D2 color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
Linkitem:
TRAN-KEY  =
; =
Oo1000105920</span></font><font size=3D2 color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> =
</span></font><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi;color:blue'>Action Taken: Run =
terminated.</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'>-----------------------------------=
--------------------------------------------</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi;color:blue'>Records read:</span></font><font size=3D2
color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
ORDER-ITEMS &n=
bsp; &nb=
sp;
5,790</span></font><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
XXX-RATIO &nbs=
p;  =
;
3</span></font><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:blue'> </span></font><font face=3DArial><span
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi;color:blue'>Transactions =
processed: &nb=
sp;
3</span></font><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:blue'> </span></font><font face=3DArial><span
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi;color:blue'>Records =
processed: &nb=
sp;
Added Updated Unchanged =
Deleted</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
ORDER-ITEMS &n=
bsp; &nb=
sp;
0 =
0
0 =
0</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
OO-TRX &=
nbsp; &n=
bsp;
3 =
0
0 =
0</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'> =
LASTOO &=
nbsp; &n=
bsp;
0 =
0
0 =
0</span></font><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;
font-family:r_ansi;color:blue'>Finished.</span></font><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> <br>
</span></font><font size=3D2 color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:
10.0pt;font-family:r_ansi;color:blue'>> </span></font><font =
face=3DArial><span
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3 =
face=3DArial><span
style=3D'font-size:12.0pt;font-family:Arial'><br>
<br>
<br>
<br>
</span></font><o:p></o:p></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> David Morrison - =
Corporate
[mailto:dmorrison@mcbrideelectric.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, December =
09, 2004
1:39 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Tim Cummings; Cognos
Powerhouse List (E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Problem =
updating last
record written at sort break in QTP</span></font><o:p></o:p></p>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;color:blue'>Tim,</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;color:blue'>I'm not sure what's causing the =
QTP error;
I think you need to include more of the program (e.g., the reference to
LastOq).</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;color:blue'>Side issues: Using =
" * .01
" may be faster and/or more accurate than " / 100", and =
there's
no need to ever multiply by -1.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;color:blue'>Thanks.</span></font><o:p></o:p></p=
>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;color:blue'>David =
Morrison</span></font><o:p></o:p></p>
</div>
<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</blockquote>
</blockquote>
</div>
</body>
</html>
------=_NextPart_000_000C_01C4DE27.26307FE0--