[Download-List] FW: Download question regarding the use of EVAL with a multi-valued field.

[Maggie Steyn]

I didn't receive any feedback from anyone when I sent this earlier, so
am re-broadcasting this. I would appreciate 
any suggestions.

> I am trying to 'sort' the order of the values in a multi-valued field
> so that all of the 'APPLES' values will be in one column, all of the
> 'ORANGES' values in the next etc. (The Fruit values, of which I can
> have up to 5, could have been loaded into the STUDENTS file in the
> multi-valued field in any sequence.)
> 
> DOWNLOAD STUDENTS @ID N12.FRUIT NUM.VALUES 5 EVAL "IF N12.FRUIT LIKE
> '...APPLES...' THEN 'APPLES' ELSE ' '" EVAL "IF N12.FRUIT LIKE
> '...ORANGES...' THEN 'ORANGES' ELSE ' '"      ....etc
> 
> I am not getting any values returned in my EVAL fields. (I've tried
> exchanging LIKE for EQ & removing the ' ...'s but the results are the
> same.)
> Is EVAL on a multi-valued field supported in DOWNLOAD ?
> 
> Thank you for your help.
> 
> 
> (We are using Download Version 7.11.)
> 
> Maggie Steyn
> Application Analyst
> Information Technology Department
> Niagara University
> msteyn at niagara.edu
> Phone: (716) 286-8651
> Fax: (716) 286-8045 
> 
>  
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20050916/2a728672/attachment.html>