<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi All:<BR>
<BR>
I believe 8.40 has the QTP Trace facility I would fire that up to see what is going on.<BR>
<BR>
Regards,<BR>
Peter<BR> <BR>
<HR id=stopSpelling>
From: RWitkopp@phxa.com<BR>To: Ken@Langendock.com; powerh-l@lists.sowder.com<BR>Subject: RE: [Bulk] arghh, the dreaded Record has been changed since you f ound it.<BR>Date: Fri, 22 Jan 2010 10:24:47 -0800<BR><BR>
<STYLE>
.ExternalClass .ecxshape
{;}
</STYLE>
<STYLE>
.ExternalClass a:link
{;}
.ExternalClass span.ecxMSOHYPERLINK
{;}
.ExternalClass a:visited
{;}
.ExternalClass span.ecxMSOHYPERLINKFOLLOWED
{;}
.ExternalClass p
{;}
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:'Times New Roman';}
.ExternalClass span.ecxEmailStyle18
{font-family:Calibri;color:#1F497D;}
.ExternalClass span.ecxEmailStyle19
{font-family:Arial;color:navy;}
@page Section1
{size:8.5in 11.0in;}
.ExternalClass div.ecxSection1
{page:Section1;}
</STYLE>
<DIV class=ecxSection1>
<P class=ecxMsoNormal><FONT color=navy size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">Yes, it’s one to one. It updated one INVESTMENT record and the error message occurred on the INVEST_CUR_BOOK record. Transaction processed was 1.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=navy size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </SPAN></FONT></P>
<DIV>
<DIV style="TEXT-ALIGN: center" class=ecxMsoNormal align=center><FONT size=3 face="Times New Roman"><SPAN style="FONT-SIZE: 12pt">
<HR align=center SIZE=2 width="100%">
</SPAN></FONT></DIV>
<P class=ecxMsoNormal><B><FONT size=2 face=Tahoma><SPAN style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From:</SPAN></FONT></B><FONT size=2 face=Tahoma><SPAN style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> Ken Langendock [mailto:ken.langendock@rogers.com] <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Friday, January 22, 2010 5:34 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Richard Witkopp; powerh-l@lists.sowder.com<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [Bulk] arghh, the dreaded Record has been changed since you found it.</SPAN></FONT></P></DIV>
<P class=ecxMsoNormal><FONT size=3 face="Times New Roman"><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt">Are you sure your record complex is only retrieving ONE to ONE record complex or does your link create a ONE to MANY relationship?</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt">You could always move the reading of sf$INFO to an output phase read to be sure.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt">OUTPUT Sf$INFO &</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> ADD &</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> UPDATE &</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> NOITEMS &</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> IF 1 EQ 2 &</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> VIAINDEX SUBSCRIPTION &</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> USING FUND_#, INVESTMENT_#</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt">Ken</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT color=#1f497d size=2 face=Calibri><SPAN style="FONT-FAMILY: Calibri; COLOR: #1f497d; FONT-SIZE: 11pt"> </SPAN></FONT></P>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=ecxMsoNormal><B><FONT size=2 face=Tahoma><SPAN style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From:</SPAN></FONT></B><FONT size=2 face=Tahoma><SPAN style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com [mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Richard Witkopp<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> January 21, 2010 9:35 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 'powerh-l@lists.sowder.com'<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Bulk] arghh, the dreaded Record has been changed since you found it.</SPAN></FONT></P></DIV></DIV>
<P class=ecxMsoNormal><FONT size=3 face="Times New Roman"><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">I'm getting this error in QTP. I could have sworn I've used this structure before to dodge it.</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">The T_ variables are global temps.</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">I'm getting the error on invest_cur_book. I know that investment is getting updated because investment_status is</SPAN></FONT> <FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">getting updated. Fund_#, investment_# are unique in each file.</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">I cannot just put the if</SPAN></FONT> <FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">condition</SPAN></FONT> <FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">for t_batch_ap_ad on the item statement for</SPAN></FONT> <FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">invest_cur_book because it's actually a lot more complex than this and I've cut it down for brevity. I pretty much need two separate outputs for the investment file.</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">8.40.E on VMS.</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Pseudo-code:</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">ACCESS BATCH_DTL &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> LINK FUND_# OF BATCH_DTL, &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> INVESTMENT_# OF BATCH_DTL &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> TO FUND_#, &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> INVESTMENT_# OF INVESTMENT &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> LINK FUND_# OF INVESTMENT, &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> INVESTMENT_# OF INVESTMENT &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> VIAIND SUBSCRIPTION TO *SF$INFO &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">CHOOSE BATCH_# SYSTEM SYM "T_BATCH_NBR"</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">OUTPUT INVESTMENT UPDATE &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> IF T_BATCH_AP_AD = "N"</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> ITEM INVESTMENT_STATUS OF INVESTMENT = &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> "1" &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> IF T_DO_ESCROW = "Y" &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> ELSE "E"</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">OUTPUT INVESTMENT UPDATE &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> ALIAS INVEST_CUR_BOOK &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> VIA FUND_# OF INVEST_CUR_BOOK, &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> INVESTMENT_# OF INVEST_CUR_BOOK &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> USING FUND_# OF BATCH_DTL, &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> INVESTMENT_# OF BATCH_DTL &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> IF T_DO_ESCROW = "Y"</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> ITEM CUR_BOOK_VALUE OF INVEST_CUR_BOOK FINAL &</SPAN></FONT><BR>
<FONT size=2 face=r_ansi><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"> TOT_CAP_DTL OF SF$INFO</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">NOTICE: The information contained in this e-mail and any attachments is confidential and may be privileged or otherwise protected from disclosure. This e-mail is intended solely for the use of the named addressee. Any other use, printing, copying, disclosure or dissemination may be subject to legal restriction. If you are not the intended recipient, please contact the sender and delete all copies including any attachments.</SPAN></FONT><BR>
<FONT size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">No virus found in this incoming message.<BR>Checked by AVG - www.avg.com<BR>Version: 9.0.730 / Virus Database: 271.1.1/2637 - Release Date: 01/21/10 14:34:00</SPAN></FONT><BR></DIV><BR>
<FONT size=2 face=Arial>NOTICE: The information contained in this e-mail and any attachments is confidential and may be privileged or otherwise protected from disclosure. This e-mail is intended solely for the use of the named addressee. Any other use, printing, copying, disclosure or dissemination may be subject to legal restriction. If you are not the intended recipient, please contact the sender and delete all copies including any attachments.</FONT><BR> <br /><hr />Spread the cheer with Messenger for mobile. <a href='http://go.microsoft.com/?linkid=9706115' target='_new'>Learn more.</a></body>
</html>