>>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!
Thanks Allen. I have always thought that WHEN was a synonym for WITH and
used WI
Guys
To return to my earlier post:
WHEN is an output limiter. It limits the output of values, so it will work
if you want to LIST those records by suppressing the output of the
individual values that don't match. But it won't work in a SELECT in this
case, unless you are already exploding, since
t: RE: [U2] selection of multivalued field based on range
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 BETW
o: u2-users@listserver.u2ug.org
Subject: RE: [U2] selection of multivalued field based on range
Actually, WHEN works for a normal list as well. If you have multiple
associated multi-valued fields, you can restrict which multivalues display
using WHEN. For example:
LIST ORDERS ITEM QTY PRICE WHE
g.
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
>
>W
: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
CTED] 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.
>>
How about:
select myfile with every qty ge "1000" and le "2000"
works for me on UV 10.1.4.
Note that in D3, I think your original query would work as you had hoped.
/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
On Dec 19, 2007 7:37 AM, Russ Watson <[EMAIL PROTECTED]> wrote:
You wouldn't get all records, just those that contained one or more
quantity >= 1000 and also one or more quantity <= 2000.
If the phase "with qty >= 1000 and =< 2000" is actually interpreted as
"with qty >= 1000 OR =< 2000" when a multi-valued field is evaluated,
then I would have expected to
of multivalued field based on range
Are we talking UV or UD here?
Bruce M Neylon
Health Care Management Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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 state
- which does not happen.
Russ
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Wednesday, December 19, 2007 2:01 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] selection of multivalued field based on range
Hi Russ,
To ge
Are we talking UV or UD here?
Bruce M Neylon
Health Care Management Group
"Russ Watson" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/19/2007 10:37 AM
Please respond to
u2-users@listserver.u2ug.org
To
cc
Subject
[U2] selection of multivalued field based on range
I want to sele
How about SELECT WITH QTY >= 1000 AND WITH QTY <= 2000?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
"Russ Watson" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/19/2007 09:37 AM
Please respond to u2-users
To:
cc:
Subject:[U2] selection of mu
Hi Russ,
To get a listing of just the data you want you'll probably need to use the
BETWEEN key word along with BY.EXP and WHEN
Something along the lines of:
LIST filename BY.EXP fieldname WHEN fieldname BETWEEN "1000" "2000"
I'm not sure of the BETWEEN syntax so you'll need to look that up. B
Russ,
I use this form:
>select file by-exp qty >= "1000" and <= "2000"
Antonio Carlos
Departamento TC)cnico
Integral Sistemas
Telefone 11 3205-6000 - Fax 11 3205-6001
www.integral.com.br
__
GPG signed/encrypte
Because there are some that match the first criteria and some that match
the second.
You can LIST these out, like this:
list filename WHEN ASD(QTY >= "1000" AND QTY <= "2000")
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Russ Watson
Sent: Wednesday,
Russ
RetrieVe doesn't have BETWEEN but SQL does, so for clarity you can use this
form:
SELECT @ID TO SLIST 0 FROM yourfile WHERE (qty BETWEEN 1000 AND 2000);
One of those rare times SQL is more helpful...
If you're listing, rather than selecting, you can use RetrieVe substituting the
WHEN cla
If UV, then try WHEN instead of WITH
Mark
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
19 matches
Mail list logo
