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 it be

Re: [U2] UD - Account Permissions

2012-04-18 Thread Colin Alfke
It kind of looks like a missing write permission somewhere. I would try the VOC in MyAccount, see if you can write to the 'Q' pointer. Telnet is a little different. I tells customers that they need to setup the telnet user so that they are able to login at the console. Older versions of Windows

Re: [U2] BETWEEN operator

2012-04-18 Thread Bill Haskett
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' u2-users@listserver.u2ug.org *Date:*

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
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.

Re: [U2] BETWEEN operator

2012-04-18 Thread Jeff Schasny
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

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
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)

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
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

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
snort 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

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
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 aelw...@socal.rr.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012 10:44 am Subject: Re: [U2]

Re: [U2] BETWEEN operator

2012-04-18 Thread Martin Phillips
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 wjhon...@aol.com wrote: Are you saying that Universe has a between operator somewhere? Where? I don't see it.

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
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 martinphill...@ladybridge.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 18, 2012

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
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

Re: [U2] BETWEEN operator

2012-04-18 Thread Richard Wilson
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

Re: [U2] BETWEEN operator

2012-04-18 Thread Wjhonson
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

Re: [U2] BETWEEN operator

2012-04-18 Thread Phil Walker
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

Re: [U2] Issues calling REMOTE VOC pointer

2012-04-18 Thread Phil Walker
Only Allen, responded. But this has been logged as a bug/feature enhancement with Rocket. It appears that the use of REMOTE VOC entries for BASIC programs is not currently supported/supported correctly which seems to be a major oversight. Hopefully it will not be difficult to implement. It