Re: [U2] BETWEEN operator
Will et al As I said, it's only in SQL in UniVerse - >SELECT COUNT(*) FROM BOOK_TITLES WHERE @ID BETWEEN 1 AND 10; COUNT ( * ) 10 1 records listed. UniVerse' SQL is bound into the run machine just like RetrieVe (the UV name for UniQuery, oh I wish there was a standard naming for the mv enquiry language). You can pretty much mix and match the two: sometimes one is better for a particular task, sometimes the other. The main differences being that SQL is more powerful and less friendly, and you can capture a SQL statement as a result set and iterate through it in code. You can't do that directly with retrieve, without having to do ugly things like create compound dictionaries, send it to XML or use Reformat with @NI as the id. I've noticed a lot of old-time UV programmers (like me) are resistant to using SQL, but for fetching data in UV it's very useful and does sometimes (not always) give the best of both worlds. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 18 April 2012 20:21 To: u2-users@listserver.u2ug.org Subject: Re: [U2] BETWEEN operator Curious you're right. I have a Between in my VOC But if I do something like LIST VOC BETWEEN or LIST VOC IF @ID BETWEEN 1 AND 2 or anything like that I just get an error 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 To: U2 Users List 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 there n 4/18/2012 3:04 PM, Wjhonson wrote: The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11. or something snip> __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
In UV it is only available in SQL. Cannot remember why we did thatprobably timeframe of getting the functionality in for a particular release. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Allen Egerton > 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 3:04 PM, Wjhonson wrote: > > > > The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as > > I can see anyway. > > Unless they *just* put it into 11. or something > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
Interesting. Evidently "Crafton Hills College" http://doclib.sbccd.net/Files/CHC/CHC_Campus_Map_052405.pdf has uploaded their entire set of Unidata manuals http://doclib.sbccd.net/Files/District/District_Computing_Services/Documentation-DCS/UdtDoc/queref.pdf or something At any rate Google found them,and tells me the syntax should be LIST VOC WITH F1 BETWEEN "A""Z" but of course that doesn't work on my Universe 10.2.3 installation It doesn't like the Between token. Evidently the VOC got ahead of the actual coding in the query language -Original Message- From: Allen Egerton To: U2 Users List 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 there n 4/18/2012 3:04 PM, Wjhonson wrote: The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11. or something snip> __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
try it in within an sql construct my UV voc BETWEEN item shows Keyword - SQL selection criteria 508 Wjhonson wrote: Curious you're right. I have a Between in my VOC But if I do something like LIST VOC BETWEEN or LIST VOC IF @ID BETWEEN 1 AND 2 or anything like that I just get an error 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 To: U2 Users List 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 there n 4/18/2012 3:04 PM, Wjhonson wrote: The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11. or something snip> __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
Curious you're right. I have a Between in my VOC But if I do something like LIST VOC BETWEEN or LIST VOC IF @ID BETWEEN 1 AND 2 or anything like that I just get an error 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 To: U2 Users List 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 there n 4/18/2012 3:04 PM, Wjhonson wrote: The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11. or something snip> __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 3:04 PM, Wjhonson wrote: > > The BETWEEN only exists in Unidata's Uniquery > Not Universe, as far as I can see anyway. > Unless they *just* put it into 11. or something > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11. or something -Original Message- From: Martin Phillips To: U2 Users List Sent: Wed, Apr 18, 2012 11: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 wrote: > Are you saying that Universe has a between operator somewhere? Where? I don't see it. -Original Message- From: Brian Leach To: 'U2 Users List' 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 it as an external function for UniBasic, hen it can be however you want. 'long as you document it.. Brian -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips ent: 18 April 2012 17:29 o: 'U2 Users List' ubject: Re: [U2] BETWEEN operator Hi, Yes I would think, if such an operator were to be introduced to Pick BASIC, hat Between should be exclusive which is how the UniQuery Between (only for nidata sorry Universe people) works today. "Between 2 and 4" means only 3, ot 2 and not 4. I would disagree, and expect it to be an inclusive range. Perhaps the ncertainty of semantics is a good reason not to have this as an operator. "Give me a number between 1 and 5". I think most people would expect this to e inclusive. Martin Phillips adybridge Systems Ltd 7b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England 44 (0)1604-709200 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
Hi, UV's BETWEEN operator is in the query processor. The previous discussions appear to be looking for it as a Basic operator. Martin Phillips On 18 Apr 2012, at 18:15, Wjhonson wrote: > > Are you saying that Universe has a between operator somewhere? > Where? I don't see it. > > > > -Original Message- > From: Brian Leach > To: 'U2 Users List' > 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 it as an external function for UniBasic, > hen it can be however you want. 'long as you document it.. > Brian > -Original Message- > rom: u2-users-boun...@listserver.u2ug.org > mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips > ent: 18 April 2012 17:29 > o: 'U2 Users List' > ubject: Re: [U2] BETWEEN operator > Hi, > > Yes I would think, if such an operator were to be introduced to Pick BASIC, > hat Between should be exclusive which is how the UniQuery Between (only for > nidata sorry Universe people) works today. "Between 2 and 4" means only 3, > ot 2 and not 4. > > I would disagree, and expect it to be an inclusive range. Perhaps the > ncertainty of semantics is a good reason not to have this as an operator. > > "Give me a number between 1 and 5". I think most people would expect this to > e inclusive. > > > Martin Phillips > adybridge Systems Ltd > 7b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England > 44 (0)1604-709200 > ___ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
I work for a municipality. Every year the pay of *every employee* is posted in the local newspaper. Isn't that a hoot -Original Message- From: Allen E. Elwood To: 'U2 Users List' Sent: Wed, Apr 18, 2012 10:44 am Subject: Re: [U2] BETWEEN operator snort> at least you didn't email the executive pay scale report to the ntire company -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett ent: Wednesday, April 18, 2012 8:50 AM o: U2 Mail List ubject: Re: [U2] BETWEEN operator Oops...wrong "To" address. Sorry. :-( Bill Original Message - From:* wphask...@advantos.net To:* U2 Users List Date:* 4/18/2012 8:45 AM Subject:* Re: [U2] BETWEEN operator I'm fixing this now. The backup only ran 49% last night and I have no idea why. So...reboot! :-) Bill -- -- - Original Message - *From:* aelw...@socal.rr.com *To:* 'U2 Users List' *Date:* 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 before so. > > -Original Message- > From:u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis > bartlett > Sent: Tuesday, April 17, 2012 10:19 PM > To: U2 Users List > Subject: Re: [U2] BETWEEN operator > > the point is that rather than the cumbersome way we have always > written the GE LE statement, there might be a better way... that > makes readability better and will take you 3425.6 man hours to > implement throughout your system.. > > however I have no idea what I'm talking about here > > On 18 April 2012 11:16, Allen Egerton wrote: > >> So what was/is your point? >> >> 'cause I'm like the other Allen, sitting here wondering what it is >> that you're asking or responding to... >> >> >> >> On 4/17/2012 9:08 PM, Wjhonson wrote: >>> There is no question. >>> >>> >>> >>> -Original Message- >>> From: Allen Elwood RR >>> To: U2 Users List >>> 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) THEN ... >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
at least you didn't email the executive pay scale report to the entire company -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, April 18, 2012 8:50 AM To: U2 Mail List Subject: Re: [U2] BETWEEN operator Oops...wrong "To" address. Sorry. :-( Bill - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List *Date:* 4/18/2012 8:45 AM *Subject:* Re: [U2] BETWEEN operator > I'm fixing this now. The backup only ran 49% last night and I have no > idea why. So...reboot! :-) > > Bill > > -- > -- > - Original Message - > *From:* aelw...@socal.rr.com > *To:* 'U2 Users List' > *Date:* 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 before so. >> >> -Original Message- >> From:u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis >> bartlett >> Sent: Tuesday, April 17, 2012 10:19 PM >> To: U2 Users List >> Subject: Re: [U2] BETWEEN operator >> >> the point is that rather than the cumbersome way we have always >> written the GE LE statement, there might be a better way... that >> makes readability better and will take you 3425.6 man hours to >> implement throughout your system.. >> >> however I have no idea what I'm talking about here >> >> On 18 April 2012 11:16, Allen Egerton wrote: >> >>> So what was/is your point? >>> >>> 'cause I'm like the other Allen, sitting here wondering what it is >>> that you're asking or responding to... >>> >>> >>> >>> On 4/17/2012 9:08 PM, Wjhonson wrote: >>>> There is no question. >>>> >>>> >>>> >>>> -Original Message- >>>> From: Allen Elwood RR >>>> To: U2 Users List >>>> 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) THEN ... >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
Are you saying that Universe has a between operator somewhere? Where? I don't see it. -Original Message- From: Brian Leach To: 'U2 Users List' 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 it as an external function for UniBasic, hen it can be however you want. 'long as you document it.. Brian -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips ent: 18 April 2012 17:29 o: 'U2 Users List' ubject: Re: [U2] BETWEEN operator Hi, Yes I would think, if such an operator were to be introduced to Pick BASIC, hat Between should be exclusive which is how the UniQuery Between (only for nidata sorry Universe people) works today. "Between 2 and 4" means only 3, ot 2 and not 4. I would disagree, and expect it to be an inclusive range. Perhaps the ncertainty of semantics is a good reason not to have this as an operator. "Give me a number between 1 and 5". I think most people would expect this to e inclusive. Martin Phillips adybridge Systems Ltd 7b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England 44 (0)1604-709200 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
It's also inclusive in (UniVerse and every other) SQL. Of course, you could always write it as an external function for UniBasic, then it can be however you want. 'long as you document it.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@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 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 an inclusive range. Perhaps the uncertainty of semantics is a good reason not to have this as an operator. "Give me a number between 1 and 5". I think most people would expect this to be inclusive. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
To clarify Allen's joke http://en.wikipedia.org/wiki/Fumblerules -Original Message- From: Allen E. Elwood To: 'U2 Users List' Sent: Wed, Apr 18, 2012 9:36 am Subject: Re: [U2] BETWEEN operator would think the opposite simply because i eschew obfuscation in all forms (see that's a joke because instead of saying 'avoiding making syntax so onfused or opaque as to be difficult to perceive or understand' i said schew obfuscation? ok, it's a English teacher's joke anyway) -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Wednesday, April 18, 2012 9:20 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] BETWEEN operator es I would think, if such an operator were to be introduced to Pick BASIC, hat Between should be exclusive which is how the UniQuery Between (only for nidata sorry Universe people) works today. "Between 2 and 4" means only 3, ot 2 and not 4. Original Message- rom: Allen E. Elwood o: 'U2 Users List' ent: Wed, Apr 18, 2012 7:02 am ubject: Re: [U2] BETWEEN operator s between inclusive or exclusive? n other words wouldn't it be written 'between 10 and 19' for values 10 from instead of 'between 9 and 20' for 10 to 19? akes more sense if it's inclusive, imho i've only seen BETWEEN used in niquery before so. Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett nt: Tuesday, April 17, 2012 10:19 PM : U2 Users List bject: Re: [U2] BETWEEN operator he point is that rather than the cumbersome way we have always written the LE statement, there might be a better way... that makes readability etter nd will take you 3425.6 man hours to implement throughout your ystem.. owever I have no idea what I'm talking about here On 18 April 2012 11:16, llen Egerton wrote: So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that ou're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: > There is no question. > > > > -Original Message- > From: Allen Elwood RR > To: U2 Users List > 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
i would think the opposite simply because i eschew obfuscation in all forms (see that's a joke because instead of saying 'avoiding making syntax so confused or opaque as to be difficult to perceive or understand' i said eschew obfuscation? ok, it's a English teacher's joke anyway) -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 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. -Original Message- From: Allen E. Elwood To: 'U2 Users List' 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? makes more sense if it's inclusive, imho i've only seen BETWEEN used in uniquery before so. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett ent: Tuesday, April 17, 2012 10:19 PM o: U2 Users List ubject: Re: [U2] BETWEEN operator the point is that rather than the cumbersome way we have always written the E LE statement, there might be a better way... that makes readability etter and will take you 3425.6 man hours to implement throughout your ystem.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton wrote: > So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: > There is no question. > > > > -Original Message- > From: Allen Elwood RR > To: U2 Users List > 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
You don't think it would be confusing to have it work differently from Uniquery ? -Original Message- From: Martin Phillips To: 'U2 Users List' Sent: Wed, Apr 18, 2012 9:29 am Subject: Re: [U2] BETWEEN operator Hi, Yes I would think, if such an operator were to be introduced to Pick BASIC, that etween should be exclusive which is how the niQuery Between (only for Unidata sorry Universe people) works today. "Between and 4" means only 3, not 2 and not 4. I would disagree, and expect it to be an inclusive range. Perhaps the ncertainty of semantics is a good reason not to have this as n operator. "Give me a number between 1 and 5". I think most people would expect this to be nclusive. Martin Phillips adybridge Systems Ltd 7b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England 44 (0)1604-709200 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 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 an inclusive range. Perhaps the uncertainty of semantics is a good reason not to have this as an operator. "Give me a number between 1 and 5". I think most people would expect this to be inclusive. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
A point? It's Will... ;-) Seriously though, this points out yet again, one of the best parts of our common U2 and associated environments. There are almost always multiple ways of skinning the proverbial cat. Often one's approach is based on what 'flavor' you are most familiar with. I know I'm an old school Prime Information guy (my copy statement has only one carriage return) so my solution almost never includes a proc or a correlative. Allen Egerton wrote: So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: There is no question. -Original Message- From: Allen Elwood RR To: U2 Users List 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
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. -Original Message- From: Allen E. Elwood To: 'U2 Users List' 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? makes more sense if it's inclusive, imho i've only seen BETWEEN used in uniquery before so. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett ent: Tuesday, April 17, 2012 10:19 PM o: U2 Users List ubject: Re: [U2] BETWEEN operator the point is that rather than the cumbersome way we have always written the E LE statement, there might be a better way... that makes readability etter and will take you 3425.6 man hours to implement throughout your ystem.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton wrote: > So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: > There is no question. > > > > -Original Message- > From: Allen Elwood RR > To: U2 Users List > 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
Oops...wrong "To" address. Sorry. :-( Bill - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List *Date:* 4/18/2012 8:45 AM *Subject:* Re: [U2] BETWEEN operator I'm fixing this now. The backup only ran 49% last night and I have no idea why. So...reboot! :-) Bill - Original Message - *From:* aelw...@socal.rr.com *To:* 'U2 Users List' *Date:* 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 before so. -Original Message- From:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Tuesday, April 17, 2012 10:19 PM To: U2 Users List Subject: Re: [U2] BETWEEN operator the point is that rather than the cumbersome way we have always written the GE LE statement, there might be a better way... that makes readability better and will take you 3425.6 man hours to implement throughout your system.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton wrote: So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: There is no question. -Original Message- From: Allen Elwood RR To: U2 Users List 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
I'm fixing this now. The backup only ran 49% last night and I have no idea why. So...reboot! :-) Bill - Original Message - *From:* aelw...@socal.rr.com *To:* 'U2 Users List' *Date:* 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 before so. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Tuesday, April 17, 2012 10:19 PM To: U2 Users List Subject: Re: [U2] BETWEEN operator the point is that rather than the cumbersome way we have always written the GE LE statement, there might be a better way... that makes readability better and will take you 3425.6 man hours to implement throughout your system.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton wrote: So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: There is no question. -Original Message- From: Allen Elwood RR To: U2 Users List 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
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 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 before so. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett > Sent: Tuesday, April 17, 2012 10:19 PM > To: U2 Users List > Subject: Re: [U2] BETWEEN operator > > the point is that rather than the cumbersome way we have always written the > GE LE statement, there might be a better way... that makes readability > better and will take you 3425.6 man hours to implement throughout your > system.. > > however I have no idea what I'm talking about here > > On 18 April 2012 11:16, Allen Egerton wrote: > > > So what was/is your point? > > > > 'cause I'm like the other Allen, sitting here wondering what it is > > that you're asking or responding to... > > > > > > > > On 4/17/2012 9:08 PM, Wjhonson wrote: > > > There is no question. > > > > > > > > > > > > -Original Message- > > > From: Allen Elwood RR > > > To: U2 Users List > > > 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) THEN ... > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 before so. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Tuesday, April 17, 2012 10:19 PM To: U2 Users List Subject: Re: [U2] BETWEEN operator the point is that rather than the cumbersome way we have always written the GE LE statement, there might be a better way... that makes readability better and will take you 3425.6 man hours to implement throughout your system.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton wrote: > So what was/is your point? > > 'cause I'm like the other Allen, sitting here wondering what it is > that you're asking or responding to... > > > > On 4/17/2012 9:08 PM, Wjhonson wrote: > > There is no question. > > > > > > > > -Original Message----- > > From: Allen Elwood RR > > To: U2 Users List > > 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) THEN ... > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
the point is that rather than the cumbersome way we have always written the GE LE statement, there might be a better way... that makes readability better and will take you 3425.6 man hours to implement throughout your system.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton wrote: > So what was/is your point? > > 'cause I'm like the other Allen, sitting here wondering what it is that > you're asking or responding to... > > > > On 4/17/2012 9:08 PM, Wjhonson wrote: > > There is no question. > > > > > > > > -Original Message- > > From: Allen Elwood RR > > To: U2 Users List > > 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) THEN ... > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: > There is no question. > > > > -Original Message- > From: Allen Elwood RR > To: U2 Users List > 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
There is no question. -Original Message- From: Allen Elwood RR To: U2 Users List 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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] BETWEEN operator
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
