[Download-List] Multivalue Field Question

[George W Ohlandt]

Hans,
  Try adding NUM.VALUES ALL to your statement...
DOWNLOAD GL.CATEGORY @ID XML.ATTRIBUTE SUB.DESC MULTI.VALUE NUM.VALUES ALL FORMAT XML FILE &HOLD& 
DOWNLOAD.XML OVERWRITING

MULTI.VALUE is just used to cause a field that is DEFINED as a single value to be treated as a 
multi-value.  I don't know if SUB.DESC is defined as single valued or not, but if it is defined as 
multi-valued then you don't even need to use MULTI.VALUE

George


George W. Ohlandt
Director of Admissions
Office of Enrollment Services
Medical University of South Carolina
ohlandtg at musc.edu

--On Wednesday, June 09, 2004 11:04 AM +0800 "Morawa, Hans" <Hans.Morawa at boral.com.au> wrote:

>
> We are trying to use DOWNLOAD version 7.10 to download some multivalue data but when testing the
> generated file only contains the first line of the multivalue field. Example listed here of the data
> and download statement and output file,
>
> LIST GL.CATEGORY "OF" 10:56:37  09-06-04  PAGE 1
>
> GL.CATEGORY                      Sub Category.............
>
> OF                               Print & Stationary
>
>                                               Postage
>
>                                               Telephone Fixed
>
>                                               Telephone Calls
>
>                                               Telephone Mobile
>
>                                               Subscriptions
>
>                                               Bank Charges
>
>                                               Travel
>
>                                               Doubt Debts
>
>                                               Bad Debts W/O
>
>                                               Collection Fees
>
>                                               FBT
>
>                                               Cleaning
>
>                                               Courier
>
>                                               PC Software
>
>                                               Computer Services
>
>                                               Insurance
>
>                                               Entertain
>
>                                               Finance Interest
>
>                                               Staff Costs
>
> 02 SELECT GL.CATEGORY WITH @ID = 'OF'
>
> 01 DOWNLOAD GL.CATEGORY @ID XML.ATTRIBUTE SUB.DESC MULTI.VALUE FORMAT XML FILE &
>
> HOLD& DOWNLOAD.XML OVERWRITING
>
> DOWNLOAD version 7.10
>
> Using input file GL.CATEGORY
>
> Output to file &HOLD& DOWNLOAD.XML
>
> 1 record processed.
>
> LIST.ITEM &HOLD& DOWNLOAD.XML 10:59:03  09-06-04  PAGE 1
>
>     DOWNLOAD.XML
>
> 001 <?xml version="1.0"?>
>
> 002 <download>
>
> 003 <glcategory id="OF">
>
> 004   <subdesc>Print & Stationary</subdesc>
>
> 005 </glcategory>
>
> 006 </download>
>
> How do I get DOWNLOAD to include all multivalues. Thanks.
>
> Regards,
>
> Hans
>
>
> ---
> This email and any files transmitted with it are confidential to the intended recipient and may be
> privileged. If you have received this email inadvertently or you are not the intended recipient, you
> may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender
> immediately and delete the email from your computer. Whilst we have taken precautions to alert us to
> the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it
> are free from such viruses.