<html>
Dave,<br><br>
How does @ID get reset? I'm not sure I am following your logic.
<br>
At the suggestion of someone else I changed W04.CI.CR.PC to the following
(which still works at colon but not in download)<br><br>
Also, prior to having an idesc for W04.CI.CR.PC, I was just doing a
secondary file lookup in my DOWNLOAD paragraph, and it still did not
return the value (that is when I went to the idesc).. However, the other
secondary lookups to the CR.acyr file that I am using do work.
Below is a section of my paragraph.<br><br>
<tt>016: DOWNLOAD CI.<<ENTER FILE SUITE YEAR:, 4N>> FORMAT
QUOTE FILE USER.HOLD ISIRPRINT.DAT OVERWRITING \<br>
017: SECONDARY.FILE PERSON KEY CI.STUDENT.ID \<br>
018: SECONDARY.FILE CR.<<ENTER FILE SUITE YEAR:, 4N>> KEY
W04.CI.CR.EDE.KEY ALIAS CRFILE \<br>
019: CI.STUDENT.ID \<br>
020: W04.CI.CR.PC \ <font face="Andale Mono" color="#0000FF">-->
this doesn't<br>
</font>021: EVAL
"TRANS('CR.2004',CI.STUDENT.ID:'*EDE.FC.1','CR.FC.PC','X')"
\ <font face="Andale Mono" color="#0000FF">--> this
doesn't<br>
</font>022: CRFILE->CR.FC.SCA \
<font face="Andale Mono" color="#0000FF">---> this returns value<br>
</font>023: CRFILE->CR.FC.PC \
<font face="Andale Mono" color="#0000FF">--> this doesn't<br><br>
</font> Top of
"<font face="Andale Mono" color="#0000FF">W04.CI.CR.PC"</font>
in "DICT CI.2004", 9 lines, 215 characters.<br>
001: I CR.FC.PC field from CR.ACYR file 3-4-04 by moorea<br>
002:
TRANS('CR.2004',FIELD(@ID,"*",1):'*EDE.FC.1','CR.FC.PC','X')<br><br>
:AE DICT CI.2004
<font face="Andale Mono" color="#0000FF">W04.CI.AUTO.ZERO<br>
</font>Top of "W04.CI.AUTO.ZERO" in "DICT CI.2004", 9
lines, 295 characters.<br>
001: I Set Auto Zero EFC flag based on CR.FC.TYPE 3-9-2004 by
moorea<br>
002: TRANS('CR.2004',CI.STUDENT.ID:'*EDE.FC.1','CR.FC.TYPE','X'); IF @1
EQ 'A' THEN "YES" ELSE "NO"<br>
003:<br>
004: AZE<br>
005: 3L<br>
006: S<br>
007:<br><br>
<br>
</tt>At 11:52 AM 3/9/2004 -0500, you wrote:<br>
<blockquote type=cite class=cite cite>Alice--<br><br>
What is the dictionary definition of W04.CI.AUTO.ZERO?<br>
I'm guessing that @ID is getting reset within that<br>
i-descriptor...so that it is not available for the<br>
i-descriptor which is giving you problems.<br><br>
<br><br>
Dave Rotman<br>
Director of Computer Services<br>
Cedarville University<br>
251 N. Main Street<br>
Cedarville, OH 45314<br>
rotmand@cedarville.edu<br>
voice 937-766-7905<br>
fax 937-766-8819<br><br>
>>> moorea@wabash.edu 3/9/2004 9:14:41 AM >>><br>
Hello,<br><br>
I am really stumped. I have an idescriptor created in RDVF in
the<br>
CI.ACYR <br>
file that I have copied into the CI.2004 dictionary and I have
compiled<br><br>
it. When I list the field at the colon prompt it returns my value,
<br>
however, when I use it in a DOWNLOAD statement it does not return a
<br>
value. I have retyped it and recompiled it several times with no
<br>
luck. Any suggestions??<br><br>
AE DICT CI.2004 W04.CI.CR.PC<br>
Top of "W04.CI.CR.PC" in "DICT CI.2004", 9 lines, 214
characters.<br>
*--: P<br>
001: I CR.FC.PC field from CR.ACYR file 3-4-04 by moorea<br>
002: TRANS('CR.2004',CI.STUDENT.ID:'*EDE.FC.1','CR.FC.PC','X')<br>
003: MD0<br>
004: CR.FC.PC<br>
005: 10R<br>
006: S<br>
007:<br>
008: <br>
W04.CI.CR.PC^253^253TRANS('CR.2004',^128FIELD(@ID,"*",1)^129:'*EDE.FC.1','CR.FC.PC','X')<br>
009: CI.2004<br><br>
Works in LIST statement:<br><br>
LIST CI.2004 W04.CI.CR.PC 09:11:03 Mar 09 2004 1<br>
CI.ACYR........ CR.FC.PC..<br><br>
0195393*EDE
38531<br>
0205688*EDE
11255<br>
2 records listed<br><br>
Download statement:<br>
SELECT CI.2004 '0195393*EDE' '0205688*EDE'<br>
2 records selected to list 0.<br>
>DOWNLOAD CI.2004 FORMAT QUOTE FILE USER.HOLD TSTISR.TXT
OVERWRITING <br>
W04.CI.AUTO.ZERO W04.CI.CR.PC<br>
DOWNLOAD version 7.01<br>
Using input file CI.2004<br>
Output to file USER.HOLD TSTISR.TXT<br><br>
<br>
2 records processed.<br><br>
Download result:<br>
:AE USER.HOLD TSTISR.TXT<br>
Top of "TSTISR.TXT" in "USER.HOLD", 2 lines, 15
characters.<br>
001: "NO",""<br>
002: "NO",""<br>
Bottom.<br>
*--:<br><br>
What gives?<br><br>
Alice Moore<br>
Manager of Administrative Systems<br>
Wabash College<br>
765-361-6303<br>
moorea@wabash.edu <br><br>
"GOD PUT ME ON EARTH TO ACCOMPLISH A CERTAIN NUMBER OF THINGS,<br>
RIGHT NOW I AM SO FAR BEHIND, I WILL NEVER
DIE!"<br>
_______________________________________________<br>
download-list mailing list<br>
download-list@cedarville.edu<br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" eudora="autourl">http://mail.cedarville.edu/mailman/listinfo/download-list</a></blockquote>
<x-sigsep><p></x-sigsep>
Alice Moore<br>
Manager of Administrative Systems<br>
Wabash College<br>
765-361-6303<br>
moorea@wabash.edu<br><br>
"GOD PUT ME ON EARTH TO ACCOMPLISH A CERTAIN NUMBER OF THINGS,<br>
RIGHT NOW I AM SO FAR BEHIND, I WILL NEVER DIE!"<br>
</html>