Re: [U2] BETWEEN operator

2012-04-18 Thread Kebbon Irwin
In Unidata, ECLTYPE determines inclusive/exclusive (U=inclusive, P=exclusive). From: aelw...@socal.rr.com To: u2-users@listserver.u2ug.org Date: Wed, 18 Apr 2012 07:01:50 -0700 Subject: Re: [U2] BETWEEN operator is between inclusive or exclusive? in other words wouldn't

Re: [U2] BETWEEN operator

2012-04-18 Thread Bill Haskett
:* 4/18/2012 7:01 AM *Subject:* Re: [U2] BETWEEN operator is between inclusive or exclusive? in other words wouldn't it be written 'between 10 and 19' for values 10 from 19 instead of 'between 9 and 20' for 10 to 19? makes more sense if it's inclusive, imho i've only seen BETWEEN used in uniquery

Re: [U2] BETWEEN operator

2012-04-18 Thread Bill Haskett
Oops...wrong To address. Sorry. :-( Bill - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/18/2012 8:45 AM *Subject:* Re: [U2] BETWEEN operator I'm

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
. Elwood aelw...@socal.rr.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 7:02 am Subject: Re: [U2] BETWEEN operator s between inclusive or exclusive? in other words wouldn't it be written 'between 10 and 19' for values 10 from 9 instead of 'between 9 and 20' for 10 to 19

Re: [U2] BETWEEN operator

2012-04-18 Thread Jeff Schasny
or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: There is no question. -Original Message- From: Allen Elwood RR aelw...@socal.rr.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Apr 17, 2012 6:01 pm Subject: Re: [U2] BETWEEN operator did u hit send b4 the question

Re: [U2] BETWEEN operator

2012-04-18 Thread Martin Phillips
Hi, Yes I would think, if such an operator were to be introduced to Pick BASIC, that Between should be exclusive which is how the UniQuery Between (only for Unidata sorry Universe people) works today. Between 2 and 4 means only 3, not 2 and not 4. I would disagree, and expect it to be

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
You don't think it would be confusing to have it work differently from Uniquery ? -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 9:29 am Subject: Re: [U2] BETWEEN operator Hi, Yes

Re: [U2] BETWEEN operator

2012-04-18 Thread Allen E. Elwood
) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, April 18, 2012 9:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] BETWEEN operator Yes I would think, if such an operator were to be introduced

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
To clarify Allen's joke http://en.wikipedia.org/wiki/Fumblerules -Original Message- From: Allen E. Elwood aelw...@socal.rr.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 9:36 am Subject: Re: [U2] BETWEEN operator would think the opposite simply

Re: [U2] BETWEEN operator

2012-04-18 Thread Brian Leach
...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: 18 April 2012 17:29 To: 'U2 Users List' Subject: Re: [U2] BETWEEN operator Hi, Yes I would think, if such an operator were to be introduced to Pick BASIC, that Between should be exclusive which is how the UniQuery Between (only for Unidata

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
Are you saying that Universe has a between operator somewhere? Where? I don't see it. -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 10:14 am Subject: Re: [U2] BETWEEN operator It's also inclusive

Re: [U2] BETWEEN operator

2012-04-18 Thread Allen E. Elwood
Subject: Re: [U2] BETWEEN operator Oops...wrong To address. Sorry. :-( Bill - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/18/2012 8:45 AM *Subject:* Re

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
ubject: Re: [U2] BETWEEN operator Oops...wrong To address. Sorry. :-( Bill Original Message - From:* wphask...@advantos.net To:* U2 Users List u2-users@listserver.u2ug.org Date:* 4/18/2012 8:45 AM Subject:* Re: [U2

Re: [U2] BETWEEN operator

2012-04-18 Thread Martin Phillips
it. -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 10:14 am Subject: Re: [U2] BETWEEN operator It's also inclusive in (UniVerse and every other) SQL. Of course, you could always write

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
:46 am Subject: Re: [U2] BETWEEN operator Hi, UV's BETWEEN operator is in the query processor. The previous discussions appear o be looking for it as a Basic operator. Martin Phillips On 18 Apr 2012, at 18:15, Wjhonson wjhon...@aol.com wrote: Are you saying that Universe has a between operator

Re: [U2] BETWEEN operator

2012-04-18 Thread Allen Egerton
Universe release 10.3.7 on a Windows platform. Voc entry BETWEEN 1 K 2 508 No online help for it, and intuitive guess how to use it didn't work, but it's definitely there On 4/18/2012 3:04 PM, Wjhonson wrote: The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
-Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 12:18 pm Subject: Re: [U2] BETWEEN operator Universe release 10.3.7 on a Windows platform. oc entry BETWEEN 1 K 2 508 No online help for it, and intuitive guess how

Re: [U2] BETWEEN operator

2012-04-18 Thread Richard Wilson
Unexpected symbol. Token was BETWEEN So I have no idea why it's in the VOC, maybe it's a left over from Prime days -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 12:18 pm Subject: Re: [U2] BETWEEN operator

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 12:18 pm Subject: Re: [U2] BETWEEN operator Universe release 10.3.7 on a Windows platform. oc entry BETWEEN 1 K 2 508 No online help for it, and intuitive guess how to use it didn't work, ut it's definitely

Re: [U2] BETWEEN operator

2012-04-18 Thread Phil Walker
Sent: Thursday, 19 April 2012 7:18 a.m. To: U2 Users List Subject: Re: [U2] BETWEEN operator Universe release 10.3.7 on a Windows platform. Voc entry BETWEEN 1 K 2 508 No online help for it, and intuitive guess how to use it didn't work, but it's definitely there On 4/18/2012

[U2] BETWEEN operator

2012-04-17 Thread Wjhonson
Pick BASIC IF MYVALUE 9 AND MYVALUE 20 THEN... or IF 9 MYVALUE 20 THEN ... or IF BETWEEN(MYVALUE,9,20) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] BETWEEN operator

2012-04-17 Thread Allen Elwood RR
did u hit send b4 the question? On 4/17/2012 5:46 PM, Wjhonson wrote: Pick BASIC IF MYVALUE 9 AND MYVALUE 20 THEN... or IF 9 MYVALUE 20 THEN ... or IF BETWEEN(MYVALUE,9,20) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] BETWEEN operator

2012-04-17 Thread Wjhonson
There is no question. -Original Message- From: Allen Elwood RR aelw...@socal.rr.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Apr 17, 2012 6:01 pm Subject: Re: [U2] BETWEEN operator did u hit send b4 the question? On 4/17/2012 5:46 PM, Wjhonson wrote: Pick BASIC

Re: [U2] BETWEEN operator

2012-04-17 Thread Allen Egerton
-users@listserver.u2ug.org Sent: Tue, Apr 17, 2012 6:01 pm Subject: Re: [U2] BETWEEN operator did u hit send b4 the question? On 4/17/2012 5:46 PM, Wjhonson wrote: Pick BASIC IF MYVALUE 9 AND MYVALUE 20 THEN... or IF 9 MYVALUE 20 THEN ... or IF BETWEEN(MYVALUE,9,20

Re: [U2] BETWEEN operator

2012-04-17 Thread dennis bartlett
Elwood RR aelw...@socal.rr.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Apr 17, 2012 6:01 pm Subject: Re: [U2] BETWEEN operator did u hit send b4 the question? On 4/17/2012 5:46 PM, Wjhonson wrote: Pick BASIC IF MYVALUE 9 AND MYVALUE 20