Re: [U2] UD - Triggers
No, CUSTOMER and CUSTOMER,CUSTOMER act the same as long as you have the trigger on CUSTOMER. LIST.TRIGGER CUSTOMER and LIST.TRIGGER CUSTOMER,CUSTOMER are the same. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 16 August 2011 20:25 To: U2 Users List Subject: Re: [U2] UD - Triggers So, are you saying if I have a trigger for CUSTOMER but not for CUSTOMER,CUSTOMER then the trigger won't work if some code looks like: "TCL.CMD = \SELECT CUSTOMER WITH CLIENTNO = "6500" : @AM : \DELETE CUSTOMER,CUSTOMER\ ; EXECUTE TCL.CMD CAPTURING OUTPUT"? H... Bill - Original Message - *From:* mbr...@epicor.com *To:* U2 Users List *Date:* 8/16/2011 1:53 AM *Subject:* Re: [U2] UD - Triggers > I have no problem with this on UD 7.2. > You do need to create the triggers e.g. DELETE on all partitions > CUSTOMER and CUSTOMER,NEWCUST and CUSTOMER,PREVCUST > CUSTOMER,CUSTOMER will also then be hit. > Similarly, if you put e.g. a DELETE trigger on CUSTOMER and > CUSTOMER,PREVCUST but not on CUSTOMER,NEWCUST and then create and delete > a record in CUSTOMER,NEWCUST it will not trigger - because there isn't > one set up at the partition level. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett > Sent: 15 August 2011 19:37 > To: U2 Mail List > Subject: [U2] UD - Triggers > Did anyone know that when one creates a trigger for a multi-level file, > and references the full file to delete or update a record, the triggers > _DON'T_ work. e.g. > CUSTOMERFILE >+ NEWCUST >+ PREVCUST > If I delete the "CUSTOMERFILE,CUSTOMERFILE" triggers don't work but they > do if I delete the "CUSTOMERFILE". So, I can't use multi-level files > for any file that contains triggers and whose DATA file name is > different than the file name. Therefore, beware on conversions. > I'm wondering if this is a bug or a feature? :-) > Bill > > > Epicor Software (UK) is a limited company registered in England& Wales. > Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB > This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. > > > This message has been scanned for malware by Websense. www.websense.com > ___ > 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 Click https://www.mailcontrol.com/sr/JvWqoNuHqhDTndxI!oX7UsdpzMR7Bo2K5w7dzs4ny +jSAn+EA2MfMQw3rzaN3YBrj4fdSEfZti1EcZNy6HxKug== to report this email as spam. Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Masking of Password Input (Universe Basic)
There was nothing in the request about validating the keys entered... So even if a backspace is pressed, throw the *... If there is a desire to test the validity of the character entered (it is within the allowed character range of this password - I.E., alpha-numeric or standard "special" characters [presumably]), I would probably use the !GET.KEY subroutine and presumably test the key entered against whichever is shorter - valid or invalid keys. If an errant character type is detected, advise the operator accordingly, wipe out the password, and make the operator retype from the beginning. This is not a test of the nth character entered compared to the nth character of the password - just whether the key pressed is valid; if it is valid, output the *. The documentation is a little lacking, but I believe that !GET.KEY does not do any of the limited character handling that KEYIN() will do. However, speedy does not come to mind when I think of everything entailed in doing this; the longer the password required, the less speedy it shall be. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent: Tuesday, August 16, 2011 7:09 PM To: U2 Users List Subject: Re: [U2] Simple Masking of Password Input (Universe Basic) Slight amendment in case your positioned in middle of screen. PASSWD = '' LOOP CHR = KEYIN() UNTIL CHR = CHAR(13) DO BEGIN CASE CASE CHR # CHAR(8) CRT "*": PASSWD := CHR CASE PASSWD # '' CRT CHAR(8):' ':CHAR(8): PASSWD = PASSWD[1,LEN(PASSWD)-1] END CASE REPEAT CRT CRT PASSWD Cheers, Andy From: nschroth To: u2-users@listserver.u2ug.org Sent: Tuesday, 16 August 2011, 19:51 Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic%29- tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] Simple Masking of Password Input (Universe Basic)
It's not all that simple, but try http://www.pickwiki.com/cgi-bin/wiki.pl?FieldInput ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Masking of Password Input (Universe Basic)
Slight amendment in case your positioned in middle of screen. PASSWD = '' LOOP CHR = KEYIN() UNTIL CHR = CHAR(13) DO BEGIN CASE CASE CHR # CHAR(8) CRT "*": PASSWD := CHR CASE PASSWD # '' CRT CHAR(8):' ':CHAR(8): PASSWD = PASSWD[1,LEN(PASSWD)-1] END CASE REPEAT CRT CRT PASSWD Cheers, Andy From: nschroth To: u2-users@listserver.u2ug.org Sent: Tuesday, 16 August 2011, 19:51 Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic%29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] Simple Masking of Password Input (Universe Basic)
How about PASSWD = '' LOOP CHR = KEYIN() UNTIL CHR = CHAR(13) DO IF CHR # CHAR(8) THEN CRT "*": PASSWD := CHR END ELSE CRT CHAR(8):' ':CHAR(8): PASSWD = PASSWD[1,LEN(PASSWD)-1] END REPEAT CRT CRT PASSWD END HTH, Andy From: nschroth To: u2-users@listserver.u2ug.org Sent: Tuesday, 16 August 2011, 19:51 Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic%29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] Simple Masking of Password Input (Universe Basic)
How about backspacing to correct mistakes? ;-) Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, August 16, 2011 12:54 PM To: 'U2 Users List' Subject: Re: [U2] Simple Masking of Password Input (Universe Basic) That's actually pretty good! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Tuesday, August 16, 2011 3:43 PM To: U2 Users List Subject: Re: [U2] Simple Masking of Password Input (Universe Basic) Just a quick sample PROMPT '' PW='' ECHO OFF LOOP INPUT X,1: IF X = '' THEN EXIT IF X THEN PRINT '*': PW := X REPEAT ECHO ON PRINT PRINT PW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: Tuesday, August 16, 2011 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic %29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] Simple Masking of Password Input (Universe Basic)
That's actually pretty good! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Tuesday, August 16, 2011 3:43 PM To: U2 Users List Subject: Re: [U2] Simple Masking of Password Input (Universe Basic) Just a quick sample PROMPT '' PW='' ECHO OFF LOOP INPUT X,1: IF X = '' THEN EXIT IF X THEN PRINT '*': PW := X REPEAT ECHO ON PRINT PRINT PW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: Tuesday, August 16, 2011 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic %29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] Simple Masking of Password Input (Universe Basic)
Just a quick sample PROMPT '' PW='' ECHO OFF LOOP INPUT X,1: IF X = '' THEN EXIT IF X THEN PRINT '*': PW := X REPEAT ECHO ON PRINT PRINT PW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: Tuesday, August 16, 2011 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic %29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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 - Triggers
So, are you saying if I have a trigger for CUSTOMER but not for CUSTOMER,CUSTOMER then the trigger won't work if some code looks like: "TCL.CMD = \SELECT CUSTOMER WITH CLIENTNO = "6500" : @AM : \DELETE CUSTOMER,CUSTOMER\ ; EXECUTE TCL.CMD CAPTURING OUTPUT"? H... Bill - Original Message - *From:* mbr...@epicor.com *To:* U2 Users List *Date:* 8/16/2011 1:53 AM *Subject:* Re: [U2] UD - Triggers I have no problem with this on UD 7.2. You do need to create the triggers e.g. DELETE on all partitions CUSTOMER and CUSTOMER,NEWCUST and CUSTOMER,PREVCUST CUSTOMER,CUSTOMER will also then be hit. Similarly, if you put e.g. a DELETE trigger on CUSTOMER and CUSTOMER,PREVCUST but not on CUSTOMER,NEWCUST and then create and delete a record in CUSTOMER,NEWCUST it will not trigger - because there isn't one set up at the partition level. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 15 August 2011 19:37 To: U2 Mail List Subject: [U2] UD - Triggers Did anyone know that when one creates a trigger for a multi-level file, and references the full file to delete or update a record, the triggers _DON'T_ work. e.g. CUSTOMERFILE + NEWCUST + PREVCUST If I delete the "CUSTOMERFILE,CUSTOMERFILE" triggers don't work but they do if I delete the "CUSTOMERFILE". So, I can't use multi-level files for any file that contains triggers and whose DATA file name is different than the file name. Therefore, beware on conversions. I'm wondering if this is a bug or a feature? :-) Bill Epicor Software (UK) is a limited company registered in England& Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ 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] Simple Masking of Password Input (Universe Basic)
Not exactly what you are asking for but: PRINT "ENTER YOUR PASSWORD" HUSH ON INPUT PWD HUSH OFF PRINT "YOU ENTERED:":PWD Works to hide the input -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: Tuesday, August 16, 2011 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic %29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] Simple Masking of Password Input (Universe Basic)
Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic%29-tp32274238p32274238.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Triggers
I have no problem with this on UD 7.2. You do need to create the triggers e.g. DELETE on all partitions CUSTOMER and CUSTOMER,NEWCUST and CUSTOMER,PREVCUST CUSTOMER,CUSTOMER will also then be hit. Similarly, if you put e.g. a DELETE trigger on CUSTOMER and CUSTOMER,PREVCUST but not on CUSTOMER,NEWCUST and then create and delete a record in CUSTOMER,NEWCUST it will not trigger - because there isn't one set up at the partition level. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 15 August 2011 19:37 To: U2 Mail List Subject: [U2] UD - Triggers Did anyone know that when one creates a trigger for a multi-level file, and references the full file to delete or update a record, the triggers _DON'T_ work. e.g. CUSTOMERFILE + NEWCUST + PREVCUST If I delete the "CUSTOMERFILE,CUSTOMERFILE" triggers don't work but they do if I delete the "CUSTOMERFILE". So, I can't use multi-level files for any file that contains triggers and whose DATA file name is different than the file name. Therefore, beware on conversions. I'm wondering if this is a bug or a feature? :-) Bill Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
