<div dir="ltr">I have heard about this kind of thing happening when i-descriptors make use of @1, @2, etc. My suspicion (unproven) is that the variables (especially @RECORD and @ID) get modified somewhere deep in the Envision code that gets included in the subroutine.<div><br></div><div>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">The original virtual field looks like this:<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">DICT PERSON “PERSON.ACTV.CUI.RELTN.CUI”<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.RELATION.TYPE,”X”);<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.START.DATE”,”X”);<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.END.DATE”,”X”);<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>SUBR(“CC.X.S.ACTIVE.REL.TPES.CUI”,@1,@2,@3);<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>@4<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span></p><p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span>Here is a workable suggestion (b</span><span style="font-size:11pt">ut hard to read in an actual dictionary entry):</span></p><p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span></span></p><p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">DICT PERSON “PERSON.ACTV.CUI.RELTN.CUI”<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>SUBR(“CC.X.S.ACTIVE.REL.TPES.CUI”,<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.RELATION.TYPE,”X”),<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.START.DATE”,”X”),<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.END.DATE”,”X”))<span></span></p>
<br><p></p>
<font face="Calibri, sans-serif"><span style="font-size:14.6667px">Error checking and readability might be improved by creating 3 new dictionary</span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:14.6667px">entries:<br></span></font>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">DICT PERSON “PAC.RELTN.TYPE”<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.RELATION.TYPE,”X”)<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">DICT PERSON “PAC.RELTN.START.DATE”<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.START.DATE”,”X”)<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">DICT PERSON “PAC.RELTN.END.DATE”<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>TRANS(“RELATIONSHIP”,PERSON.CUI.RELATIONSHIP.CUI,”RS.END.DATE”,”X”)<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">DICT PERSON “PERSON.ACTV.CUI.RELTN.CUI”<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span> </span>SUBR(“CC.X.S.ACTIVE.REL.TPES.CUI”,PAC.RELTN.TYPE,PAC.RELTN.START.DATE,PAC.RELTN.END.DATE)<span></span></p>
<p class="gmail-MsoNoSpacing" style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span> </span><span></span></p>
<br></div><div>Hope this helps...</div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr"><div dir="ltr" style="font-size:small"><div><div>David Rotman</div><div>15276 Nashua Circle</div><div>Westfield, IN 46074</div><div><a href="mailto:rotmand@cedarville.edu" style="color:rgb(17,85,204)" target="_blank">rotmand@cedarville.edu</a><br></div><div><a href="tel:(937)%20532-4739" value="+19375324739" style="color:rgb(17,85,204)" target="_blank">937-532-4739</a><br></div><div><br></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Apr 27, 2018 at 1:33 PM, Carol Van Weelden <span dir="ltr"><<a href="mailto:VANWEELDENC@central.edu" target="_blank">VANWEELDENC@central.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div class="m_-3784149430896809486WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Hi David,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Yes. Please see the attached file.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Sorry that took so long, but Colleague Studio is running very slowly for us today. (Argh!)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thank you,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Carol<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:download-list-bounces@cedarville.edu" target="_blank">download-list-bounces@<wbr>cedarville.edu</a> [mailto:<a href="mailto:download-list-bounces@cedarville.edu" target="_blank">download-list-bounces@<wbr>cedarville.edu</a>]
<b>On Behalf Of </b>Rotman, David<br>
<b>Sent:</b> Friday, April 27, 2018 11:19 AM<br>
<b>To:</b> Cedarville DOWNLOAD Users <<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a>><br>
<b>Subject:</b> Re: [Download-List] Perplexing Issue<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Carol--<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Would you be able to show us the definitions for the virtual fields and also the actual Download statement you are using?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">David Rotman<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">15276 Nashua Circle<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Westfield, IN 46074<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:rotmand@cedarville.edu" target="_blank"><span style="color:#1155cc">rotmand@cedarville.edu</span></a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="tel:(937)%20532-4739" target="_blank"><span style="color:#1155cc">937-532-4739</span></a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Fri, Apr 27, 2018 at 10:11 AM, Carol Van Weelden <<a href="mailto:VANWEELDENC@central.edu" target="_blank">VANWEELDENC@central.edu</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">We have 2 fields defined in our Colleague PERSON file that go through the Organization section of Relationships (PREL) and, after dividing them in Active and Inactive, list the
Role(s) of those relationships, eg. MBR (for Member). These lists are subsequently made into long strings where the entries are separated with semicolons. LISTing the data, the fields display correctly. However, using DOWNLOAD, the data from the inactive
field appears to get pulled into the active field and the inactive field appears empty. It doesn’t matter what order the fields appear in, in the DOWNLOAD command, they always behave the same way.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Any ideas are greatly appreciated.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Thank you,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;color:#c00000">CAROL</span></b><b><span style="font-size:14.0pt">
<span style="color:gray">VAN WEELDEN</span></span></b><u></u><u></u></p>
<p class="MsoNormal"><span style="color:gray">Senior Systems Analyst | Central College</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:gray">812 University Street | Campus Box 5500 | Pella, Iowa 50219</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f4e79"><a href="mailto:vanweeldenc@central.edu" target="_blank"><span style="color:#1f4e79">vanweeldenc@central.edu</span></a></span> |
<span style="color:#1f4e79"><a href="http://www.central.edu/" target="_blank"><span style="color:#1f4e79">www.central.edu</span></a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:gray">Office: 641.628.7619 | Fax: 641.628.5316</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:gray">Twitter : @CentralCollege; @CentralDutch</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:gray">Facebook: Central College; Central College Dutch</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><img border="0" width="170" height="106" id="m_-3784149430896809486m_-644089283115807755Picture_x0020_1" src="cid:image001.png@01D3DE23.E1841DF0" alt="cid:image001.png@01D051D5.56661940"><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><br>
______________________________<wbr>_________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/<wbr>mailman/listinfo/download-list</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
<br>______________________________<wbr>_________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" rel="noreferrer" target="_blank">http://mail.cedarville.edu/<wbr>mailman/listinfo/download-list</a><br></blockquote></div><br></div>