[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