<div dir="ltr">Thanks, Marc, for sending me a description of the situation. He has an EVAL expression that returns more than 128 characters.<div><br></div><div>The problem here is that Download can process EVAL two different ways:</div>
<div><br></div><div>* if "COMPILE.EVAL=TRUE" is in the DOWNLOAD.CONFIG record in the VOC file</div>
<div>== A temporary virtual field is created, compiled, used, and then deleted.</div><div>* otherwise</div><div>== A SELECT statement is issued for each EVAL for each record. Unidata limits the size of text returned to 128 characters.</div>
<div><br></div><div>Some people (like Mark) do not have rights to modify dictionaries, so the first approach is not workable.</div><div><br></div><div>I've done some experimenting with using a LIST statement instead of SELECT to work around this problem. My concern is the somewhat unpredictable nature of the output from LIST (depending on the user's terminal settings and other system defaults).</div>
<div><br></div><div>Perhaps members of the list could try a brief experiment and let me know (offline) the results. Try this statement (replacing "PERSON" with the name of any Unidata file of your choice):</div>
<div> LIST PERSON EVAL "'ABCD'" COL.HDG 'ZZ' HDR.SUPP ID.SUP VERTICAL SAMPLE 1<br></div><div>You should see output like this:</div><div><div> ZZ ABCD</div><div> </div><div> 1 record listed</div>
</div><div>On my system, there are 3 spaces between the ZZ column heading and the ABCD data. Is that consistent?</div><div><br></div><div>Changing COL.HDG 'ZZ' to COL.HDG '' produces output with 3 leading spaces.</div>
<div><br></div><div>I know I could capture the output and do a TRIM or FIELD to avoid counting spaces and get the data value, but that might prove problematic if there were leading spaces in the data value.</div><div><br>
</div><div>Your comments are welcome.</div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div>David Rotman, Ph.D.<br>Associate Vice President for Technology<br>
Chief Information Officer<br>Cedarville University<br>251 N. Main Street<br>Cedarville, OH 45314<br><a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a><br>voice 937-766-7905<br>fax 937-766-8819<div>
<img src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><br></div></div>
<br><br><div class="gmail_quote">On Thu, Dec 12, 2013 at 11:47 AM, Bessler, Marc <span dir="ltr"><<a href="mailto:mbessler@exeter.edu" target="_blank">mbessler@exeter.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><p class="MsoNormal">I keep hitting a 128 character limit when using an EVAL and DOWNLOAD together. This includes the quote and delimiter characters. Is there a way to overcome this or did I miss something?<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p>
<span class="HOEnZb"><font color="#888888"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d">Marc Bessler</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#990000"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d">Technology Support Specialist<br>Advancement Operations</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#990000"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d">Office of Institutional Advancement</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#990000"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d">Phillips Exeter Academy | 20 Main Street | Exeter, NH 03833<br><a href="tel:603-777-3367" value="+16037773367" target="_blank">603-777-3367</a> | fax: <a href="tel:603-777-4382" value="+16037774382" target="_blank">603-777-4382</a></span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#365f91"><br>
<a href="mailto:mbessler@exeter.edu" title="mailto:mbessler@exeter.edu" target="_blank"><span style="color:blue">mbessler@exeter.edu</span></a><br><a href="http://phillips.exeter.edu/" title="http://phillips.exeter.edu/" target="_blank"><span style="color:blue">http://www.exeter.edu/alumni</span></a></span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p></font></span></div></div><br>_______________________________________________<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" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
<br></blockquote></div><br></div>