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

[Bill Pizer]

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!"