<html>
<body>
I am unable to get the virtual field to return any data via
Download. I can get the correct data using Query Builder or the
Colon prompt, but not download. The virtual field returns one value
- the subject. I can't figure out what I'm doing wrong. I've
listed the Subroutine and Virtual Field information below. I would
welcome any suggestions.<br><br>
Subroutine:<br>
<font face="MS Sans Serif, Geneva" size=2>X.NDX = ""<br>
A.RESULT = ""<br>
X.NUM.OF.COURSES = DCOUNT(AL.COURSES,@VM)<br>
FOR X.NDX = 1 TO X.NUM.OF.COURSES<br>
IF AL.COURSES<1,X.NDX> EQ "490" OR
AL.COURSES<1,X.NDX> EQ "493" THEN<br>
IF AL.STATUSES<1,X.NDX> EQ "A" OR
AL.STATUSES<1,X.NDX> EQ "N" THEN <br>
A.RESULT =
AL.SUBJECTS<1,X.NDX><br>
END<br>
END<br>
NEXT X.NDX<br><br>
</font>That looks for the subject that our students complete their senior
paper. <br><br>
Virtual Fields:<br>
<font face="MS Sans Serif, Geneva" size=2>SUBR("S.L53.GET.SRPAPER.SUBJ",X.STU.STC.COURSE,X.STU.STC.SUBJECT,X.STU.STC.STATUS)<br><br>
</font>The details of the virtual fields above are listed.<br>
<font face="MS Sans Serif, Geneva" size=2>X.STU.STC.COURSE -
SUBR("S.MIO.TRANS","STUDENT.ACAD.CRED",PST.STUDENT.ACAD.CRED,
"STC.CRS.NUMBER","X")
<br>
X.STU.STC.SUBJECT -
SUBR("S.MIO.TRANS","STUDENT.ACAD.CRED",PST.STUDENT.ACAD.CRED,
"STC.SUBJECT","X") <br>
X.STU.STC.STATUS -
SUBR("S.MIO.TRANS","STUDENT.ACAD.CRED",PST.STUDENT.ACAD.CRED,
"STC.CURRENT.STATUS","X") <br><br>
</font>Thanks, <br>
Debbie<br><br>
<x-sigsep><p></x-sigsep>
Debbie Smith <br>
Software Specialist<br>
Luther College<br>
700 College Drive<br>
Decorah, IA 52101<br>
(563) 387-1520 or (563) 387-1699</body>
</html>