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

[Dale Young]

I tried that, re-compiled, re-catalogued, and got different error messages:



Program "DLPROCESS": Line 306, Variable "X.BUILDING.DATA.VALUE" previously undefined.  Zero used.

Program "DLPROCESS": Line 308, Variable previously undefined.  Zero length string used.

Program "DLPROCESS": Line 308, Variable "X.BUILDING.DATA.SUBVALUE" previously undefined.  Zero used.

Program "DLPROCESS": Line 327, Variable previously undefined.  Zero length string used.

Program "DLPROCESS": Line 327, Variable "X.BUILDING.DATA.SUBVALUE" previously undefined.  Zero used.

Program "DLPROCESS": Line 330, Variable "X.BUILDING.DATA.VALUE" previously undefined.  Zero used.



Good luck with the surgery.



Dale Young

9225 Priority Way West Dr.

Suite 390

Indianapolis, IN 46240

(317) 569-7493  |  Fax (317) 569-7481

-----Original Message-----
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of David L. Rotman
Sent: Monday, February 15, 2010 3:19 PM
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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20100216/2a77afa3/attachment.html>