Maybe it works better in 7.1.9.
I can remember getting odd results before with MV's and with's.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett
Sent: Wednesday, December 19, 2007 17:13
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] selec
It's been a super long time since I used WHEN, but now that you mention it,
I remember doing that a long long time ago in a galaxy far far away :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock
Sent: Wednesday, December 19, 2007 16:42
To: u2-us
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-D
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 WHEN QTY GT 10
Assuming ITEM, QTY and PRICE are associated, the result will only show those
lines w
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
[EMAI
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
Universe
RELLEVEL
001 X
002 10.1.4
003 PICK
004 PICK.FORMAT
005 10.1.4
Russ
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 3:48 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] selection o
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
I chased this problem for quite awhile and never found the answer. IBM
wanted to install a debug version but the problem was happening on the
production server. It has to do with UV thinking there is a UID problem and
the -2 seems to be a default. The biggest impact I saw was the loss of
being a
Thanks to all who replied.
The quandary was how to *select* the appropriate records without having
to change the ensuing basic report.
I was hoping for something like BETWEEN. But between does not work on
multi-valued fields.
By-exp would have required additional programming changes.
In the
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
We have a power supply failing. Redundant, so hot-swappable. Cool.
The kudos come as a result of my service call this morning. I had 2
issues: power supply, and a redundant gateway causing connection
time-outs.
I placed a call to hardware support (800-IBM-SERV) and got the power
supply issue unde
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
Hello List,
Has anyone come across a situation a where user has a -2 user id?
uid User No User Name Terminal No Login Time
-2 4076 SAGEPUB\DEVadmin telnet:4076 Dec 19 06:12
It seems to affect their permissions.
IBM is checking into, but so
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/
I want to select records to report if *one* of the multivalues falls
within a range.
For example: select with qty >= 1000 and =< 2000
If I use the example I get records where none of the values satisfies
the range condition.
@ID qty
--- --
21 matches
Mail list logo