<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>BODY {
MARGIN: 10px
}
</STYLE>
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY marginbottom="10" margintop="10" marginright="10" marginleft="10">
<DIV dir=ltr align=left><SPAN class=595093514-26092008>Lorna,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008>I _think_ DownLoad will
not produce without an active select list. You could try to Download from some
small file.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008>However, there is an
alternative. Immediately after your Select or Get.List, insert an "If
@System.Return.Code LE 0 then go somewhere" statement. Insert a "somewhere:" tag
lower in the paragraph, immediately preceded by a Go to get around the error
message statements. Here's a bit of one of our paragraphs:</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008><<</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008>027: SELECT ...<BR>032:
IF @SYSTEM.RETURN.CODE LE 0 THEN GO NODATA<BR>033: ***<BR>034: DISPLAY Step 4:
Extract ...</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008>035: DOWNLOAD
...<BR>...<BR>056: GO FINISHED<BR>057: ***<BR>058: NODATA:<BR>059:
DISPLAY<BR>060: DISPLAY ...<BR>061: ***<BR>062: FINISHED:</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008>>></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=595093514-26092008>HTH<BR></SPAN><SPAN
class=595093514-26092008><FONT size=2>Eric Spitzner, CDP
(eric.spitzner@quinnipiac.edu)<BR>Senior Programmer/Analyst<BR>Quinnipiac
University; Hamden, Connecticut<BR>Sun V490; Solaris 10; UniData
7.1.0<BR>Colleague 18 and Benefactor 5.1</FONT> </DIV></SPAN><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<BR></DIV>
<DIV></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>Hi there,</FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>I'm interested in the DOWNLOAD equivalent to the REQUIRE.SELECT command.
If a DOWNLOAD is used in a paragraph and a select comes up empty I'd like
to make sure the DOWNLOAD doesn't bring back every record in the
file.</FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>THANKS!!</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>Lorna</FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial size=+0>.
. . . . . . . . . . . . . . . . . . . . . . . . . . .</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>Lorna Hunt</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>Programmer</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>Antioch University</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>900 Dayton St. </FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
size=+0>Yellow Springs, OH 45387</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
color=#000000 size=+0><A
href="mailto:lhunt@antioch.edu">lhunt@antioch.edu</A></FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
color=#000000 size=+0>937-769-1356</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-SIZE: 11pt; COLOR: #000000; FONT-FAMILY: Arial" face=Arial
color=#000000 size=+0>. . . . . . . . . . . . . . . . . . . . . . . . . . .
.</FONT></DIV><BR></BODY></HTML>