Re: [U2] Credit Card numbers in your database
You need to talk to your QSA, our QSA is great because we can ask him questions anytime and he doesn't charge for each question we ask. He helps us make decisions about our products that eases the recertification process. We only pay every 3 years for our PCI PA-DSS certification. It is well worth the investment! We know we are offering solid PCI PA-DSS solutions to our customers. As I understand it, you are responsible to keep your backups very secure, and dispose of the backups in a secure manner (bulk eraser for tape backups?). For disk backups, you should encrypt the backup and securely delete when you no longer have a need. You should have an auditable means of tracking access to your backups, especially if it is easy to take the backup off-site. I don't believe you are required to restore the backup, encrypt the data, then cut a new backup. One word of caution, make sure you have the encryption key secured for the backups. When it comes to credit cards, it is best to always error on the side of caution. The consequences if you lose data is huge for you and your customers. Good luck, PCI is real "fun"! Tom RATEX Business Solutions -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 5:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] Credit Card numbers in your database Probably every company has gone through adding more stringent rules to the use of credit cards in your database. But surely no one has actually gone back to their old backups to "cleanse" them ? Does anyone think that's really part of the PCI DSS we're supposed to be following? We have backups going back umpteen years ___ 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] Credit Card numbers in your database
Probably every company has gone through adding more stringent rules to the use of credit cards in your database. But surely no one has actually gone back to their old backups to "cleanse" them ? Does anyone think that's really part of the PCI DSS we're supposed to be following? We have backups going back umpteen years ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Issues calling REMOTE VOC pointer
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 shouldn't be, the just need to look at the PATH in the remote pointer for the object code, rather than looking in the object directory that the calling program resides in. Currently a BASIC program will look in the VOC file for a subroutine and if not found it will look in its own object directory. What I would like is it to look in the VOC, see that it is a remote voc entry, execute the security subroutine if specified, and then execute the object code specified by the Remote VOC pointer. This will allow the security routine to be used to AUDIT all programs on the system. Hopefully function calls would work the same way. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Allen Egerton > Sent: Tuesday, 10 April 2012 8:33 p.m. > To: U2 Users List > Subject: Re: [U2] Issues calling REMOTE VOC pointer > > You're "EXECUTING" PROG1 from TCL, so you can invoke it in any of the > ways that you've documented below. > > >From within PROG1, you're "CALLING" PROG2, it's a subroutine, so it has > to be locatable as you've so clearly documented in your example. > > If you wanted to have them both run using <4> for security, then you could: > 'EXECUTE "PROG2" CAPTURING CMD.CAP' from within PROG1. If you need > to pass args you're either going to have to store them in named common or > pass them as command line args and parse them out. > > > > On 4/10/2012 4:05 AM, Phil Walker wrote: > > Hi, > > > > This is a contrived solution, but I have a program file BP1 and another > program file BP2. In program file BP1 I have a program PROG1. In program > file BP2 I have a program PROG2. > > > > PROG1 is the following: > > > > PROG1 > > 0001 PROGRAM PROG1 > > 0002 CRT "IN PROGRAM PROG1" > > 0003 CRT "CALLING PROG2" > > 0004 CALL PROG2 > > 0005 CRT "BACK IN PROG1" > > 0006 RETURN > > > > PROG2 is the following: > > > > PROG2 > > 0001 PROGRAM PROG2 > > 0002 CRT "IN PROGRAM PROG2" > > 0003 RETURN > > > > If I RUN BP1 PROG1 I get the following > > > >> RUN BP1 PROG1 > > IN PROGRAM PROG1 > > CALLING PROG2 > > Program "PROG1": Line 4, Unable to open the operating system file > "BP1.O/PROG2". > > [ENOENT] No such file or directory > > Program "PROG1": Line 4, Unable to load file "PROG2". > > Program "PROG1": Line 4, Unable to load subroutine. > > > > This is as expected, in that Universe assumes when there is not VOC entry > that PROG2 is in the same OBJECT file, BP1.O. > > > > If I CATALOG BP2 PROG2 LOCAL COMLETE > > > >> CATALOG BP2 PROG2 LOCAL COMPLETE > > "PROG2" cataloged. > >> CT VOC PROG2 > > > > PROG2 > > 0001 V > > 0002 /tmp/BP2.O/PROG2 > > 0003 B > > 0004 BN > > 0005 > > 0006 > > 0007 > > 0008 > > 0009 /tmp/BP2.O > > > > and then RUN BP1 PROG1 I get the following > > > >> RUN BP1 PROG1 > > IN PROGRAM PROG1 > > CALLING PROG2 > > IN PROGRAM PROG2 > > BACK IN PROG1 > >> > > > > If I CATALOG BP1 PROG1 LOCAL COMPLETE > > > >> CATALOG BP1 PROG1 LOCAL COMPLETE > > "PROG1" cataloged. > >> CT VOC PROG1 > > > > PROG1 > > 0001 V > > 0002 /tmp/BP1.O/PROG1 > > 0003 B > > 0004 BN > > 0005 > > 0006 > > 0007 > > 0008 > > 0009 /tmp/BP1.O > > > > and then execute PROG1 I get the following > > > >> PROG1 > > IN PROGRAM PROG1 > > CALLING PROG2 > > IN PROGRAM PROG2 > > BACK IN PROG1 > >> > > > > The same results which is still good. However what I really want to do > > is add a security routine to both VOC entries PROG1 and PROG2. To do > > this I copy the VOC entries to PROG1 and PROG2 to the VOCLIB file and > > change the VOC entries to the following > > > > PROG1 > > 0001 R > > 0002 VOCLIB > > 0003 PROG1 > > > > PROG2 > > 0001 R > > 0002 VOCLIB > > 0003 PROG2 > > > > I will see if this works first, before adding attribute 4 for the security > routine. > > > >> PROG1 > > IN PROGRAM PROG1 > > CALLING PROG2 > > Program "PROG1": Line 4, Unable to open the operating system file > > "/tmp/BP1.O/PRO G2". > > [ENOENT] No such file or directory > > Program "PROG1": Line 4, Unable to load file "PROG2". > > Program "PROG1": Line 4, Unable to load subroutine. > >> > > > > As you can see this does not work. It appears that while Universe will use > the contents of attribute 2 LOCAL VOC entry (the path to the object code), > Universe will not use the contents of attribute 2 of the REMOTE VOC entry. > > > > I believe this is a bug...does you agree? > > > > For further clarification this was in IDEAL flavour. If I change it to > > PICK, > PIOPEN it still behaves the same. > > > > Regards > > > > Phil > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug
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] UD - Account Permissions
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 had defaulted permissions on users that allowed this, the newer ones don't - although I haven't had to setup a 2008 box. It sounds like the user can telnet in though - just to another account. We were lazy when setting up our accounts. We simply have a group created with full permissions on the UD folder and then we put everything under it. A little funny considering our target market - but over 20 years I only had one "security" related incident. hth Colin -Original Message- From: Bill Haskett Sent: April 17, 2012 5:13 PM To: U2 Users List Subject: Re: [U2] UD - Account Permissions Colin: The funny thing is, this is a local user. The network doesn't use a domain (it's a server network). I'm a valid user and I can log onto any other dbms account. When I try to telnet into this one account I get: "Unable to set current directory to E:\Advantos\MyAccount" But, I log into another account, set a 'Q' pointer to "MyAccount's" (VOC) file, or any other file for that matter, and I can list the contents of any of the files. This tells me the permissions are fine. UniObjects has no trouble connecting to the account and neither does mv.NET using UO.Net (I'm using a user id that is a member of the UniDataUnique group). This particular user can't telnet in either. When I try to telnet in using my credentials, which happen to be the "owner" of everything under the dbms account's directory, it fails too. So, I guess I'll just put the permissions back to the way they were and forget about this, as telnet accesses something UO doesn't. :-( Thanks, Bill ___ 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