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/