[Download-List] EVAL & in line Prompt
Brich, Richard W.
Richard.Brich at sdsmt.edu
Thu Jul 12 16:43:22 EDT 2007
Hello Download Users
having problems using Download with an EVAL & an in line prompt in the
File statement
in R18 (which we just converted to)
IF I remove the <<ENTER TERM>> from FILE XH.SDMT.FTP.DIR
XM.RWB.STU.ASD<<ENTER TERM>> COMMA.CHAR ^9 OVERWRITING
Query works fine - can we no longer use an in-line prompt in the File
statement with an EVAL in Download?
(if I remove the EVAL from the Query - then the in-line prompt in the
File statement works fine)
thanks
Dick Brich
if I do not remove it get:
(Query worked in R17)
GET.LIST XM.RWB.<<ENTER TERM>>
DOWNLOAD STUDENTS \
FILE XH.SDMT.FTP.DIR XM.RWB.STU.ASD<<ENTER TERM>> COMMA.CHAR ^9
OVERWRITING \
SECONDARY.FILE APPLICANTS KEY @ID ALIAS APP \
SECONDARY.FILE PERSON KEY @ID ALIAS PERS \
HEADING \
LITERAL "COLLID" \
LITERAL "HS NAME STATE" \
DETAIL \
@ID \
EVAL "IF XH.STU.HIGH.SCHOOL.STATE = '' THEN XH.STU.HS.NAME ELSE
XH.STU.HIGH.SCH
OOL.STATE:'-':XH.STU.HS.NAME" \
XU.STU.SAT.VERB
XM.RWB.TEMP
ENTER TERM 2007SU
488 records retrieved to list 0.
DOWNLOAD version 7.11
Creating temporary list DLMBRICHR55772
488 key(s) saved to 1 record(s).
488 records retrieved to list 1.
Overwriting existing select list.
488 records retrieved to list 1.
Using input file STUDENTS
Output to file XH.SDMT.FTP.DIR XM.RWB.STU.ASD
1 record processed.
The following records were not found on STUDENTS.
Possible causes include mistyping keywords,
mistyping record keys, or having an extraneous
continuation character in your DOWNLOAD statement.
"2007SU" not found.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20070712/e4a6f2c2/attachment.html>
More information about the download-list
mailing list