[Download-List] idesc not returning value in download but does at colon prompt

[Alice Moore]

Bill,

No such luck.  It works at colon prompt but not in Download.

Alice

At 09:39 AM 3/9/2004 -0500, you wrote:
>You might try replacing "CI.STUDENT.ID" with 'FIELD(@ID,"*",1)'. It looks 
>like CI.STUDENT.ID is a virtual field.
>
>--------------------------------
>Bill Pizer
>Assistant Director of MIS and Benefactor System Administrator
>The Sage Colleges
>45 Ferry St
>Troy, NY 12180
>518-244-2087
>518-244-2085 (fax)
>
>Forgot your SageNet/CampusCruiser/Blackboard password?
>You can now visit <a 
>href="http://www.sage.edu/password/" >http://www.sage.edu/password/</a>
>
>
>---------------------------------------
>Original Email
>From: Alice Moore <moorea at wabash.edu>
>Sent: Mar 09, 2004 09:14 AM
>To: download-list at cedarville.edu
>Subject: [Download-List] idesc not returning value in download but does at 
>colon prompt
>
>Hello,
>
>I am really stumped.  I have an idescriptor created in RDVF in the CI.ACYR
>file that I have copied into the CI.2004 dictionary and I have compiled
>it.  When I list the field at the colon prompt it returns my value,
>however, when I use it in a DOWNLOAD statement it does not return a
>value.  I have retyped it and recompiled it several times with no
>luck.  Any suggestions??
>
>AE DICT CI.2004 W04.CI.CR.PC
>Top of "W04.CI.CR.PC" in "DICT CI.2004", 9 lines, 214 characters.
>*--: P
>001: I CR.FC.PC field from CR.ACYR file 3-4-04 by moorea
>002: TRANS('CR.2004',CI.STUDENT.ID:'*EDE.FC.1','CR.FC.PC','X')
>003: MD0
>004: CR.FC.PC
>005: 10R
>006: S
>007:
>008:
>W04.CI.CR.PC^253^253TRANS('CR.2004',^128FIELD(@ID,"*",1)^129:'*EDE.FC.1','CR.FC.PC','X')
>009: CI.2004
>
>Works in LIST statement:
>
>LIST CI.2004 W04.CI.CR.PC 09:11:03 Mar 09 2004 1
>CI.ACYR........ CR.FC.PC..
>
>0195393*EDE          38531
>0205688*EDE          11255
>2 records listed
>
>Download statement:
>SELECT CI.2004 '0195393*EDE' '0205688*EDE'
>2 records selected to list 0.
>  >DOWNLOAD CI.2004 FORMAT QUOTE FILE USER.HOLD TSTISR.TXT OVERWRITING
>W04.CI.AUTO.ZERO W04.CI.CR.PC
>DOWNLOAD version 7.01
>Using input file CI.2004
>Output to file USER.HOLD TSTISR.TXT
>
>
>2 records processed.
>
>Download result:
>:AE USER.HOLD TSTISR.TXT
>Top of "TSTISR.TXT" in "USER.HOLD", 2 lines, 15 characters.
>001: "NO",""
>002: "NO",""
>Bottom.
>*--:
>
>What gives?
>
>Alice Moore
>Manager of Administrative Systems
>Wabash College
>765-361-6303
>moorea at wabash.edu
>
>"GOD PUT ME ON EARTH TO ACCOMPLISH A CERTAIN NUMBER OF THINGS,
>     RIGHT NOW I AM SO FAR BEHIND, I WILL NEVER DIE!"
>
>
>_______________________________________________
>download-list mailing list
>download-list at cedarville.edu
>http://mail.cedarville.edu/mailman/listinfo/download-list

Alice Moore
Manager of Administrative Systems
Wabash College
765-361-6303
moorea at wabash.edu

"GOD PUT ME ON EARTH TO ACCOMPLISH A CERTAIN NUMBER OF THINGS,
    RIGHT NOW I AM SO FAR BEHIND, I WILL NEVER DIE!"