Allen:
In UniDate v7.1.9 on Windows 2K3, in "ECLTYPE P" mode (using UniData mode), I
do the
following:
3 Dev (0)-> list APOPEN WHEN AMTS BETWEEN "7500""8000" INVDATE COMMENT ACCTS
AMTS
list APOPEN WHEN AMTS BETWEEN "7500""8000" INVDATE COMMENT ACCTS AMTS 17:04:23
Dec 19
2007 1
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
830*38953 02-21-07 WTR/SWR, 108942-515683 3070 76.01
3 Dev (0)-> list APOPEN WITH AMTS BETWEEN "7500""8000" INVDATE COMMENT ACCTS
AMTS
list APOPEN WITH AMTS BETWEEN "7500""8000" INVDATE COMMENT ACCTS AMTS 16:52:49
Dec 19
2007 1
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
830*38953 02-21-07 WTR/SWR, 108942-515683 3060 90.98
3070 76.01
...which indicates I don't need the "BY.EXP" keyword (note the "list" command).
However, in Pick mode I can:
3 Dev (0)>> LIST APOPEN BY-EXP AMTS > "7500" AND < "8000" INVDATE COMMENT ACCTS
AMTS
LIST APOPEN BY-EXP AMTS > "7500" AND < "8000" INVDATE COMMENT ACCTS AMTS
17:07:16 Dec
19 2007 1
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
830*38953 02-21-07 WTR/SWR, 108942-515683 3070 76.01
...which does the same thing.
Bill
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Allen
>E. Elwood
>Sent: Wednesday, December 19, 2007 3:47 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] selection of multivalued field based on range
>
>WHEN only works with BY.EXP and is not associated with WITH . You can have
>bunches of WITH's, but only the first WHEN gets evaluated. At least with
>the versions I've worked with.
>
>And that's on Unidata!
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of
>[EMAIL PROTECTED]
>Sent: Wednesday, December 19, 2007 12:39
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] selection of multivalued field based on range
>
>
>Allen,
>
>I am from a Unidata background. I am guessing that you work
>in Universe?
>I am curious about how Universe works.
>
>>> as only one WHEN per statement works.
>
>Does that mean you can only use one WHEN verb in a SELECT statement?
>
>In Unidata you can use multiple WITH (OR WHEN) verbs in a statement.
>Example.
>
>SELECT WIP-BATCH-DETAIL-HIST_MA WITH WORK.DATE >= "10/1/07" AND WITH
>WORK.DATE <= "10/31/07"
>
>I believe it was the same in the old PICK days. Anyone
>remember Ultimate
>PICK? It was OK, but it didn't live up to its name.
>
>Charles Shaffer
>Senior Analyst
>NTN-Bower Corporation
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
