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

[David L. Rotman]

I believe the problem relates to the location of the multi-valued field.

The field SEC.FACULTY is multi-valued whereas the field CSF.FACULTY.LAST.NAME
is single valued.

Try adding NUM.VALUES ALL on the SECONDARY.FILE line for SEC.FACULTY
and omitting the NUM.VALUES ALL for CSF.FACULTY.LAST.NAME.




Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
 


>>> Dave Moderski <dmodersk at atlantic.edu> 8/9/2010 1:58 PM >>>
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