<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="http://schemas.microsoft.com/office/2004/12/omml">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<meta name=Generator content="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>arghh, the dreaded Record has been changed since you found it.</title>
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
p
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:r_ansi;
panose-1:2 11 6 9 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> 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><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Are you sure your
record complex is only retrieving ONE to ONE record complex or does your link
create a ONE to MANY relationship?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>You could always
move the reading of sf$INFO to an output phase read to be sure.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>OUTPUT Sf$INFO &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> ADD
&<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> UPDATE
&<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> NOITEMS
&<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> IF 1 EQ
2 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> VIAINDEX
SUBSCRIPTION &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> USING FUND_#,
INVESTMENT_#<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Ken<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> 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.<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I'm
getting this error in QTP. I could have sworn I've used this structure before
to dodge it.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>The
T_ variables are global temps.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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-size:10.0pt;font-family:Arial'>getting updated. Fund_#,
investment_# are unique in each file.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
cannot just put the if</span></font> <font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>condition</span></font> <font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>for
t_batch_ap_ad on the item statement for</span></font> <font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>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><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>8.40.E
on VMS.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Pseudo-code:</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>ACCESS
BATCH_DTL
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LINK
FUND_#
OF BATCH_DTL,
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_#
OF
BATCH_DTL
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
TO
FUND_#,
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_#
OF INVESTMENT
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LINK FUND_#
OF
INVESTMENT,
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_#
OF INVESTMENT
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
VIAIND
SUBSCRIPTION
TO
*SF$INFO
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>CHOOSE
BATCH_# SYSTEM SYM "T_BATCH_NBR"</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>OUTPUT
INVESTMENT
UPDATE
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
IF T_BATCH_AP_AD = "N"</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ITEM INVESTMENT_STATUS OF
INVESTMENT
=
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
"1"
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
IF T_DO_ESCROW =
"Y"
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ELSE "E"</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>OUTPUT
INVESTMENT
UPDATE
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ALIAS
INVEST_CUR_BOOK
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
VIA
FUND_# OF
INVEST_CUR_BOOK,
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_# OF
INVEST_CUR_BOOK
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
USING FUND_#
OF BATCH_DTL,
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_# OF BATCH_DTL
&</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
IF T_DO_ESCROW =
"Y"</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ITEM
CUR_BOOK_VALUE OF
INVEST_CUR_BOOK FINAL &</span></font><o:p></o:p></p>
<p><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
TOT_CAP_DTL
OF SF$INFO</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family: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.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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><o:p></o:p></p>
</div>
</body>
</html>
<BR>
<P><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></P>