<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:st1 = "urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Verdana" bgColor=#ffffff>
<DIV><FONT face=Arial>This is definitely not a fix, but if you created a virtual
field to do that EVAL, you could rule out that DOWNLOAD has an issue with those
quotes, perhaps it will reveal an underlying issue?</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=mfromm@exeter.edu href="mailto:mfromm@exeter.edu">Bessler-Fromm,
Marc</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=download-list@cedarville.edu
href="mailto:download-list@cedarville.edu">Cedarville DOWNLOAD Users</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, November 03, 2005 5:00
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Download-List] segmentation
fault</DIV>
<DIV><BR></DIV>
<DIV dir=ltr align=left><SPAN class=296105921-03112005>I think I encountered a
similar problem a couple of months ago. Try switching the single and double
quotes in your d/l statement.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=296105921-03112005></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=296105921-03112005><FONT
face="Courier New">DOWNLOAD STUDENTS EVAL
"SUBR('DELTA.MU.DELTA.CREDITS',STUDENTS.ID)"</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=296105921-03112005><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=296105921-03112005><FONT
face="Courier New">If this fixes it for you, then it a the same bug Dave hopes
to address in the next release. If not, maybe something
else.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left>
<DIV class=Section1>
<P class=MsoNormal align=left><st1:place w:st="on"><st1:PlaceName
w:st="on"><SPAN
style="FONT-SIZE: 10pt; COLOR: #990000; FONT-FAMILY: Arial"><FONT
face=Verdana>Marc</FONT></SPAN></st1:PlaceName><SPAN
style="FONT-SIZE: 10pt; COLOR: #990000; FONT-FAMILY: Arial"><FONT
face=Verdana> <st1:PlaceName
w:st="on">Bessler-Fromm</st1:PlaceName><BR><st1:PlaceName
w:st="on">Data</st1:PlaceName> <st1:PlaceName
w:st="on">Support</st1:PlaceName> <st1:PlaceName
w:st="on">Specialist</st1:PlaceName><BR><st1:PlaceName
w:st="on">Phillips</st1:PlaceName> <st1:PlaceName
w:st="on">Exeter</st1:PlaceName> <st1:PlaceType
w:st="on">Academy</st1:PlaceType></FONT></SPAN></st1:place><BR><SPAN
style="FONT-SIZE: 10pt; COLOR: #990000; FONT-FAMILY: Arial"><FONT
face=Verdana>20 </FONT><st1:address
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
tabIndex=0 w:st="on"><FONT face=Verdana><st1:Street w:st="on">Main
Street</st1:Street><BR><st1:City w:st="on">Exeter</st1:City>, <st1:State
w:st="on">NH</st1:State> <st1:PostalCode
w:st="on">03833</st1:PostalCode></FONT></st1:address></SPAN></P>
<P class=MsoNormal align=left><SPAN
style="FONT-SIZE: 10pt; COLOR: #990000; FONT-FAMILY: Arial"><st1:address
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
tabIndex=0 w:st="on"><st1:PostalCode
w:st="on"></st1:PostalCode></st1:address></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><FONT face=Verdana>Telephone:
603-777-3367<BR>Fax: 603-777-4382<BR>Email: </FONT><A
href="mailto:mfromm@exeter.edu"><FONT
face=Verdana>mfromm@exeter.edu</FONT></A><BR><FONT face=Verdana>Website:
</FONT><A href="http://phillips.exeter.edu/"><FONT
face=Verdana>http://phillips.exeter.edu</FONT></A></SPAN></P></DIV></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <B>On Behalf Of </B>Don
Prezioso<BR><B>Sent:</B> Thursday, November 03, 2005 11:34 AM<BR><B>To:</B>
download-list@cedarville.edu<BR><B>Subject:</B> [Download-List] segmentation
fault<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>O.K., I'm really puzzled on this one. </DIV>
<DIV> </DIV>
<DIV>I have a virtual field that calls a subroutine. In LIST statements it
works fine, but DOWNLOAD gives a segmentation fault.</DIV>
<DIV> </DIV>
<DIV>First the error:</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">:GET.LIST TEST.DVP<BR>10 records retrieved to
list 0.<BR>>DOWNLOAD STUDENTS STU.DMD.CREDITS FORMAT FIXED<BR>DOWNLOAD
version 7.12<BR>Using input file STUDENTS<BR>Output to screen</FONT></DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">Segmentation
fault<BR>ibmp630:/datatel/live/collive $</FONT></DIV>
<DIV> </DIV>
<DIV>The virtual field code is:</DIV>
<DIV> </DIV>
<DIV><FONT
face="Courier New">SUBR("DELTA.MU.DELTA.CREDITS",STUDENTS.ID)</FONT></DIV>
<DIV> </DIV>
<DIV>And the DELTA.MU.DELTA.CREDITS subroutine code is:</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">SUBROUTINE
DELTA.MU.DELTA.CREDITS(RESULT,ID.NO)<BR>* TAKES AN ID NUMBER AND RETURNS
A TOTAL NUMBER CREDITS EARNED FOR<BR>* DELTA MU DELTA REPORT<BR>COMMON
/DMDCRED/ OPENED, F.TRANS.GROUP, F.STUD.ACAD.CRED, F.STU.ACAD.LEVEL,
ACAD.LEVELS<BR>IF NOT(OPENED) THEN<BR> OPEN '','TRANSCRIPT.GROUPINGS' TO
F.TRANS.GROUP<BR> ELSE STOP "UNABLE TO OPEN TRANSCRIPT
GROUPING FILE"<BR> OPEN '','STUDENT.ACAD.CRED' TO
F.STUD.ACAD.CRED<BR> ELSE STOP "UNABLE TO OPEN
STUDENT.ACAD.CRED FILE"<BR> OPEN '','STUDENT.ACAD.LEVELS' TO
F.STU.ACAD.LEVEL<BR> ELSE STOP "UNABLE TO OPEN
STUDENT.ACAD.LEVELS FILE"<BR> READ TG.REC FROM F.TRANS.GROUP,
'MB'<BR> ELSE TG.REC = ''<BR> ACAD.LEVELS =
TG.REC<2><BR> OPENED = 1<BR>END<BR>*<BR>X.TOTAL = 0<BR>RESULT =
0<BR>ACAD.LEVEL.COUNT = DCOUNT(ACAD.LEVELS,@VM)<BR>FOR LEVEL = 1 TO
ACAD.LEVEL.COUNT<BR> READ STA.REC FROM
F.STU.ACAD.LEVEL,ID.NO:'*':ACAD.LEVELS<1,LEVEL>
THEN<BR> STUDENT.ACAD.CRED =
STA.REC<10><BR> CRED.COUNT =
DCOUNT(STUDENT.ACAD.CRED,@VM)<BR> FOR I = 1 TO
CRED.COUNT<BR> READ STC.REC FROM
F.STUD.ACAD.CRED,STUDENT.ACAD.CRED<1,I> THEN
<BR> IF STC.REC<13> GT 0
THEN<BR> X.TOTAL +=
STC.REC<13><BR>
END<BR> END<BR> NEXT
I<BR> END<BR>NEXT LEVEL<BR>*<BR>IF X.TOTAL THEN <BR> RESULT =
OCONV(X.TOTAL,"MD05") <BR>END<BR>*<BR>RETURN RESULT<BR>END</FONT></DIV>
<DIV> </DIV>
<DIV>If I try to do a DOWNLOAD using an EVAL, instead of the virtual field, I
get:</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">:GET.LIST TEST.DVP<BR>10 records retrieved to
list 0.<BR>>DOWNLOAD STUDENTS EVAL
'SUBR("DELTA.MU.DELTA.CREDITS",STUDENTS.ID)'<BR>DOWNLOAD version
7.12<BR>Creating temporary list DLDPREZ40567<BR>10 key(s) saved to 1
record(s).<BR>10 records retrieved to list 1.<BR>Overwriting existing select
list.<BR>10 records retrieved to list 1.<BR>Using input file
STUDENTS<BR>Output to screen</FONT></DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">""<BR>""<BR>""<BR>""<BR>""</FONT></DIV>
<DIV><FONT face="Courier New">""<BR>""<BR>""<BR>""<BR>""</FONT></DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">10 records processed.<BR>Deleting temporary list
DLDPREZ40567<BR>'DLDPREZ40567' deleted.<BR>:</FONT></DIV>
<DIV> </DIV>
<DIV>It should be returning some number (if only 0) instead of the null
strings. If I do a LIST statement I get:</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">:GET.LIST TEST.DVP<BR>10 records retrieved to
list 0.<BR>>LIST STUDENTS STU.DMD.CREDITS</FONT></DIV>
<DIV><BR><FONT face="Courier New">LIST STUDENTS STU.DMD.CREDITS 11:31:21 Nov
03 2005 1<BR>STUDENTS.. STU.D</FONT></DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">0936711
27<BR>0816629
16<BR>0896532
18<BR>0936713
12<BR>0936719
18<BR>0736451
18<BR>0976714
6<BR>0616439
28<BR>0896540
17<BR>0556488 12<BR>10 records
listed</FONT></DIV>
<DIV> </DIV>
<DIV>I have messed around with the subroutine code (there didn't used to be
common, and it didn't used to verify the presence of data) to no avail. Any
ideas?</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV> </DIV>
<DIV>Don<BR></DIV>
<DIV> </DIV>
<DIV>--<BR>Don Prezioso<BR>Director of Administrative Systems<BR>Ashland
University<BR>Ashland, Ohio</DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>download-list
mailing
list<BR>download-list@cedarville.edu<BR>http://mail.cedarville.edu/mailman/listinfo/download-list<BR></BLOCKQUOTE></BODY></HTML>