<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<title>arghh, the dreaded Record has been changed since you found it.</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@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:2 11 6 9 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
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","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
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></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You could always move the reading of sf$INFO to an output phase
read to be sure.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>OUTPUT Sf$INFO &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> ADD &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> UPDATE &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> NOITEMS &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> IF 1 EQ 2 &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> VIAINDEX SUBSCRIPTION &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> USING FUND_#, INVESTMENT_#<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b>On
Behalf Of </b>Richard Witkopp<br>
<b>Sent:</b> January 21, 2010 9:35 PM<br>
<b>To:</b> 'powerh-l@lists.sowder.com'<br>
<b>Subject:</b> [Bulk] arghh, the dreaded Record has been changed since you
found it.<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I'm getting
this error in QTP. I could have sworn I've used this structure before to dodge
it.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>The T_
variables are global temps.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I'm getting
the error on invest_cur_book. I know that investment is getting updated because
investment_status is</span> <span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>getting
updated. Fund_#, investment_# are unique in each file.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I cannot
just put the if</span> <span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>condition</span>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>for
t_batch_ap_ad on the item statement for</span> <span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>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><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>8.40.E on
VMS.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Pseudo-code:</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>ACCESS
BATCH_DTL
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
LINK
FUND_#
OF BATCH_DTL,
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_#
OF
BATCH_DTL
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
TO
FUND_#,
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_#
OF INVESTMENT
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
LINK
FUND_#
OF INVESTMENT,
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_#
OF INVESTMENT
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
VIAIND
SUBSCRIPTION
TO
*SF$INFO
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>CHOOSE BATCH_#
SYSTEM SYM "T_BATCH_NBR"</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>OUTPUT
INVESTMENT
UPDATE
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
IF T_BATCH_AP_AD = "N"</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
ITEM INVESTMENT_STATUS OF
INVESTMENT
=
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
"1"
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
IF T_DO_ESCROW =
"Y"
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
ELSE "E"</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>OUTPUT
INVESTMENT
UPDATE
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
ALIAS
INVEST_CUR_BOOK
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
VIA
FUND_# OF
INVEST_CUR_BOOK,
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_# OF
INVEST_CUR_BOOK
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
USING FUND_#
OF BATCH_DTL,
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
INVESTMENT_# OF
BATCH_DTL
&</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
IF T_DO_ESCROW =
"Y"</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
ITEM
CUR_BOOK_VALUE OF
INVEST_CUR_BOOK FINAL &</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:r_ansi'>
TOT_CAP_DTL
OF SF$INFO</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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><o:p></o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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><o:p></o:p></p>
</div>
</body>
</html>