[Download-List] DOWNLOAD using BY.EXP with two WHEN clauses

[Norman, David (Health)]

Dave,
In version 7.20, would that be line 178 ??

Thanks,

========================
David Norman
Senior Software Engineer - SA Ambulance Service

ICT Services
SA Health
Government of South Australia

Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* david.norman at health.sa.gov.au

This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. 

-----Original Message-----
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of David L. Rotman
Sent: Tuesday, 16 February 2010 06:49
To: download-list at cedarville.edu
Subject: Re: [Download-List] DOWNLOAD using BY.EXP with two WHEN clauses

I have done some additional research on this problem and believe 
that I have identified a related bug in producing output
using BY.EXP (for comma-quote output and xml output).  I would
like to work on this for a few days before releasing a patched
version.  (This work will likely be delayed pending some minor
surgery and recovery.)

In the meantime, you might try this modification:  In the routine
DLPROCESS (DOWNLOAD.PROCESS on Unidata)
, at line 168 you should find:
0168:                      GOSUB BUILD.COMMA.QUOTE.DATA.VALUE
Try changing that line to 
0168:                      GOSUB BUILD.COMMA.QUOTE.DATA.SUBVALUE

You will need to recompile (and perhaps recatalog) the program.

Let me know how the change works.







Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
 
>>> Dale Young <youngd at auctor.com> 2/11/2010 2:51 PM >>>
I have a UniVerse process that has a file with multi-values with 3 fields associated (field 7 of dictionary contains the same association for all 3 fields; AP.76, AP.92, and AP.93). I'm trying to use the BY.EXP with using the WHEN for one field and the WHEN for another field:

SELECT AP.FLE BY.EXP AP.76 WHEN AP.76 = '678' AND WHEN AP.92 GE '09-01-04'
DOWNLOAD AP.FLE BY.EXP AP.76 WHEN AP.76 = '678' AND WHEN AP.92 GE '09-01-04'

Of course I'm using the AP.76 and AP.92 fields to return the data along with some other fields. I keep getting an error message from DLPROCES:

Program "DLPROCESS": Line 236, Variable "VALUE.CTR" previously undefined.  Zero used.

I do get the right record count, but most of my AP.76 and AP.92 values are null, the ones that are not null do have the 678 with a date GE 09-01-04.

I have a bunch of requests for this information using different values and report criteria, but all using the same select basics. Any ideas what I'm doing wrong?


Dale Young
9225 Priority Way West Dr.
Suite 390
Indianapolis, IN 46240
(317) 569-7493  |  Fax (317) 569-7481



_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list