<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>DOWNLOAD and BY.EXP Question</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">I am having difficulty using the BY.EXP / WHEN syntax with DOWNLOAD.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I am trying to develop a file of specific "ABC" Awards from our SA.2005 file.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">My paragraph statements look like this:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">SELECT SA.2005 BY.EXP SA.AWARD WHEN SA.AWARD EQ "ABC"</FONT>
<BR><FONT SIZE=2 FACE="Arial">DOWNLOAD SA.2005 @ID SA.AWARD SA.AMOUNT BY.EXP SA.AWARD WHEN SA.AWARD EQ "ABC" etc</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">The results are:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">0111111,"",""</FONT>
<BR><FONT SIZE=2 FACE="Arial">0222222,"",""</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">My @ID field is getting output, but not so the SA.AWARD or the SA.AMOUNT.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">If I take out the BY.EXP and the WHEN in the DOWNLOAD phrase, I DO get the Award and the Amount data, but only for the 'first' Award, which is not necessarily "ABC", of course.)</FONT></P>
<P><FONT SIZE=2 FACE="Arial">e.g.</FONT>
<BR><FONT SIZE=2 FACE="Arial">0111111,"DEF",1000.00</FONT>
<BR><FONT SIZE=2 FACE="Arial">0222222."ABC","250.00"</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Can anyone see where my error lies ?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thank you,</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Maggie Steyn</FONT>
<BR><FONT SIZE=2 FACE="Arial">Application Analyst</FONT>
<BR><FONT SIZE=2 FACE="Arial">Information Technology Department</FONT>
<BR><FONT SIZE=2 FACE="Arial">Niagara University</FONT>
<BR><FONT SIZE=2 FACE="Arial">msteyn@niagara.edu</FONT>
<BR><FONT SIZE=2 FACE="Arial">Phone: (716) 286-8651</FONT>
<BR><FONT SIZE=2 FACE="Arial">Fax: (716) 286-8045 </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"> </FONT>
</P>
</BODY>
</HTML>