First of all thanks for this great utility. Its uses are wide ranging and numerous.<br><br>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. <br>
<br>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.<br>
<br>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.<br><br>If anyone could provide insight I'd greatly appreciate it.<br><br>
<br>My query is:<br>SELECT COURSE.SECTIONS \<br>WITH SEC.TERM = '<<*Enter term for classes>>' \<br>BY <a href="http://sec.name/" target="_blank">SEC.NAME</a> \<br>BY <a href="http://sec.no/" target="_blank">SEC.NO</a><br>
IF @SYSTEM.RETURN.CODE LE 0 THEN GO FINISHABNORMAL: <div id=":1x7"> <br>
SAVE.LIST TABLOIDLIST <br>GET.LIST TABLOIDLIST<br>*<br>DISPLAY Creating tabloid raw data<br>DOWNLOAD COURSE.SECTIONS \<br>SECONDARY.FILE COURSES KEY SEC.COURSE \<br>SECONDARY.FILE COURSE.SEC.MEETING KEY SEC.MEETING \<br>
SECONDARY.FILE COURSE.SEC.FACULTY KEY SEC.FACULTY \<br>COURSES->CRS.SUBJECT \<br>COURSES->CRS.SHORT.TITLE \<br><a href="http://sec.name/" target="_blank">SEC.NAME</a> \<br><a href="http://sec.no/" target="_blank">SEC.NO</a> \<br>
COURSE.SEC.MEETING->CSM.INSTR.METHOD \<br>
SEC.MIN.CRED \<br>COURSE.SEC.MEETING->CSM.START.TIME \<br>COURSE.SEC.MEETING->CSM.END.TIME \<br>SEC.LOCATION \<br>COURSE.SEC.FACULTY-><a href="http://csf.faculty.last.name/" target="_blank">CSF.FACULTY.LAST.NAME</a> \<br>
NUM.VALUES ALL \<br>
MV.ORIENTATION VERTICAL \<br>FILE _HOLD_ TABLOIDFILE FORMAT FIXED OVERWRITING FIELD.GAP 1<br><br><br><font color="#888888"><br></font></div><br clear="all"><br>-- <br>Dave Moderski <br>Programmer/Analyst<br>Atlantic Cape Community College <br>
609-625-1111 ext. 5298<br><br>