[Download-List] multivalues when linking to COURSE.SEC.MEETING

[Dave Moderski]

First of all thanks for this great utility.  Its uses are wide ranging and
numerous.

I am a Datatel customer and am having an issue when trying to get more than
one value when linking from COURSE.SECTIONS to COURSE.SEC.MEETING through
the Q pointer SEC.MEETING in COURSE.SECTIONS.  I always only get the first
values from COURSE.SEC.MEETING even when I know there are more.

Running a query from query builder shows more than one value when using a
TRANS statement.  In my download query I have another file linked from
COURSE.SECTIONS, the COURSE.SEC.FACULTY file, via a Q pointer and in that
file I get multiple values fine.

I have tried different things such as creating a computed column in
COURSE.SECTIONS with the values from a field from COURSE.SEC.MEETING,
changing the format, removing references to all other secondary files in the
query, and adding MULTI.VALUE to the fields.

If anyone could provide insight I'd greatly appreciate it.


My query is:
SELECT COURSE.SECTIONS \
WITH SEC.TERM = '<<*Enter term for classes>>' \
BY SEC.NAME <http://sec.name/> \
BY SEC.NO <http://sec.no/>
IF @SYSTEM.RETURN.CODE LE 0 THEN GO FINISHABNORMAL:

SAVE.LIST TABLOIDLIST
GET.LIST TABLOIDLIST
*
DISPLAY Creating tabloid raw data
DOWNLOAD COURSE.SECTIONS \
SECONDARY.FILE COURSES KEY SEC.COURSE \
SECONDARY.FILE COURSE.SEC.MEETING KEY SEC.MEETING \
SECONDARY.FILE COURSE.SEC.FACULTY KEY SEC.FACULTY \
COURSES->CRS.SUBJECT \
COURSES->CRS.SHORT.TITLE \
SEC.NAME <http://sec.name/> \
SEC.NO <http://sec.no/> \
COURSE.SEC.MEETING->CSM.INSTR.METHOD \
SEC.MIN.CRED \
COURSE.SEC.MEETING->CSM.START.TIME \
COURSE.SEC.MEETING->CSM.END.TIME \
SEC.LOCATION \
COURSE.SEC.FACULTY->CSF.FACULTY.LAST.NAME <http://csf.faculty.last.name/> \
NUM.VALUES ALL \
MV.ORIENTATION VERTICAL \
FILE _HOLD_ TABLOIDFILE FORMAT FIXED OVERWRITING FIELD.GAP 1





-- 
Dave Moderski
Programmer/Analyst
Atlantic Cape Community College
609-625-1111 ext. 5298
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20100809/5e5ecccc/attachment.html>