[Download-List] Virtual Field doesn't display data

[Debbie Smith]

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.

Subroutine:
X.NDX = ""
A.RESULT = ""
X.NUM.OF.COURSES = DCOUNT(AL.COURSES, at VM)
FOR X.NDX = 1 TO X.NUM.OF.COURSES
IF AL.COURSES<1,X.NDX> EQ "490" OR AL.COURSES<1,X.NDX> EQ "493" THEN
    IF AL.STATUSES<1,X.NDX> EQ "A" OR AL.STATUSES<1,X.NDX> EQ "N" THEN
       A.RESULT = AL.SUBJECTS<1,X.NDX>
    END
END
NEXT X.NDX

That looks for the subject that our students complete their senior paper.

Virtual Fields:
SUBR("S.L53.GET.SRPAPER.SUBJ",X.STU.STC.COURSE,X.STU.STC.SUBJECT,X.STU.STC.STATUS)

The details of the virtual fields above are listed.
X.STU.STC.COURSE - 
SUBR("S.MIO.TRANS","STUDENT.ACAD.CRED",PST.STUDENT.ACAD.CRED, 
"STC.CRS.NUMBER","X")
X.STU.STC.SUBJECT - 
SUBR("S.MIO.TRANS","STUDENT.ACAD.CRED",PST.STUDENT.ACAD.CRED, 
"STC.SUBJECT","X")
X.STU.STC.STATUS - 
SUBR("S.MIO.TRANS","STUDENT.ACAD.CRED",PST.STUDENT.ACAD.CRED, 
"STC.CURRENT.STATUS","X")

Thanks,
Debbie


Debbie Smith
Software Specialist
Luther College
700 College Drive
Decorah, IA  52101
(563) 387-1520 or (563) 387-1699 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20041026/1a3e88ee/attachment.html>