Re: [U2] SB Password
Hi John, The item PASSWORD.VALIDATION in DMSECURITY controls how the validation is done when users are prompted for new passwords. There are 4 different ways this can happen:- A) If nothing is in PASSWORD.VALIDATION1, then SB+ performs several validations by default, e.g. can't be the same as user id or the old password, must be between 4 and 50 chars long, etc. But users in ROOT group can have null passwords. B) If the name of a user cataloged routine is in PASSWORD.VALIDATION1, then this routine will be called to validate the password, and the default SB+ checks will be skipped. The user supplied routine takes 2 parameters. The 1st is the new password just entered and the 2nd is the return value, 0 if valid, non-zero otherwise. Note: This only applies to users setting their own password following a reset by the system administrator, any existing accounts with a null password already set will remain accessible. SUBROUTINE PASSWD.CHECK(PASSWD, RTN.FLAG) RTN.FLAG=0 IF PASSWD= THEN CALL SB.DISP(3,NULL PASSWORD NOT ALLOWED) RTN.FLAG=1 END RETURN C) Same as B but the name of the routine is prefixed with an '*', e.g. *MY.PW.CHK'. Then the routine 'MY.PW.CHK' will be called first, and if it passes validation then the default SB+ checks will then be carried out as in A. D) If '**BYPASS' is in PASSWORD.VALIDATION1 then SB+ will skip validation altogether except for the compulsory check that passwords can't be numeric which is in place for all 4 cases. Thanks, Martin From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org Sent: 24 October 2013 21:31 To: U2 Users List Subject: [U2] SB Password Is there a process in SB to put limits on the SB password. For example, it must be 8 or more characters, must have a digit, must have at least 1 upper and 1 lower case, etc. Thanks JRI Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] SB: Character Mode Works Great, GUI Does Not
Hi Al, GUI does not like a direct call to INVOKE.TEXT.ED in the screen itself at certain SB releases. Create a new 1 line paragraph that just calls INVOKE.TEXT.ED and put that paragraph on the screen and regen.gui. Martin - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: 09 August 2013 19:07 To: (u2-users@listserver.u2ug.org) Subject: [U2] SB: Character Mode Works Great, GUI Does Not I am creating a simple screen. Two fields. The Before Process in the Definition defines @KEY, reads @RECORD and loads @RECORD6 into @WORK1 which is displayed on the screen (lines of text). @WORK1 is a multivalue field. The Before Process invokes the text editor. The user is allowed to manipulate text. When the user presses F2 to exit the text editor and goes to the second field and the length of the MV field is displayed and if it is greater than 350 it displays an error and returns the user to the field to shorten it. Once things are good it will write the new field to the file (WRITEV) and exit the screen. Everything works in character mode. The text field displays, etc. However, it GUI the text field is blank. REGEN.GUI does nothing to fix the problem. Any ideas. Albert DeWitt, CPIM 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
Re: [U2] OPENSEQ
If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it is present (if the XLS is open with Excel you will usually get an abort) Although I personally would check it is actually there via normal read syntax first OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' READ CHECKITSTHERE FROM LRGLBRVARS,FNAME ELSE STOP 201,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 05 August 2013 14:31 To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looked at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM 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
Re: [U2] OPENSEQ
Spot the spilling miss steak. and that will of course be 202,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 05 August 2013 14:48 To: U2 Users List Subject: Re: [U2] OPENSEQ If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it is present (if the XLS is open with Excel you will usually get an abort) Although I personally would check it is actually there via normal read syntax first OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' READ CHECKITSTHERE FROM LRGLBRVARS,FNAME ELSE STOP 201,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 05 August 2013 14:31 To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looked at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM 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 Click https://www.mailcontrol.com/sr/xTPlpmVs7T!GX2PQPOmvUnx5AcfplCJVvID731zL8nSDZHbh!LQJTNwGoUldJppTIyW01XaW!eLX405xsHCs!A== to report this email as spam. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
...Aaaah. If it is NOT there then do this:- OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' WRITE ON LRGLBRVARS,FNAME OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: Martin Braid Sent: 05 August 2013 14:52 To: U2 Users List Subject: RE: [U2] OPENSEQ Spot the spilling miss steak. and that will of course be 202,FNAME -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 05 August 2013 14:48 To: U2 Users List Subject: Re: [U2] OPENSEQ If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it is present (if the XLS is open with Excel you will usually get an abort) Although I personally would check it is actually there via normal read syntax first OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' READ CHECKITSTHERE FROM LRGLBRVARS,FNAME ELSE STOP 201,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 05 August 2013 14:31 To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looked at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM 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 Click https://www.mailcontrol.com/sr/xTPlpmVs7T!GX2PQPOmvUnx5AcfplCJVvID731zL8nSDZHbh!LQJTNwGoUldJppTIyW01XaW!eLX405xsHCs!A== to report this email as spam
Re: [U2] What is true
Identical on UDNT 7.1.20 - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: 01 August 2013 15:52 To: U2 Users List Subject: Re: [U2] What is true Here is a simple program I wrote and ran on UV 11.1.9. It would be interesting to hear if UD behaves the same way. 0001: A='' 0002: CRT 'A = ':QUOTE(A):' ': 0003: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0004: A=0 0005: CRT 'A = ':QUOTE(A):' ': 0006: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0007: A='HELLO' 0008: CRT 'A = ':QUOTE(A):' ': 0009: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0010: A=1 0011: CRT 'A = ':QUOTE(A):' ': 0012: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' The results are: A = FALSE A = 0 FALSE A = HELLO TRUE A = 1 TRUE Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Swain Sent: Thursday, August 01, 2013 8:24 AM To: U2 Users List Subject: Re: [U2] What is true This is not true as when A='HELLO' IF (A) returns true. You use the parenthesis to set a Boolean variable, i.e BRITISH = (COUNTRY = 'ENGLAND' OR COUNTRY = 'WALES') etc the var BRITISH is set to 1 when the conditions inside the parenthesis are met, otherwise BRITISH is set to 0 Jim Swain - Developer Telephone: +44 (0) 1295 701 810 | Fax: +44 (0) 1295 701 819 www.zafire.com Consider the environment. Think before you print. This is a commercial communication from Zafire Group. This communication is confidential and is intended only for the person to whom it is addressed. If you are not that person you are not permitted to make use of the information and you are requested to notify us immediately that you have received it and then destroy the copy in your possession. Zafire Group may monitor outgoing and incoming e-mails. By replying to this e-mail you consent to such monitoring. This e-mail message and any attached files have been scanned for the presence of computer viruses. However, you are advised that you open attachments at your own risk. Zafire Limited is a limited liability company registered in England and Wales. Co. Reg. No. 3968255. Our registered address is Zafire House, Manor Park, Banbury, Oxfordshire OX16 3TB. VAT Reg.No. 754 0161 55. Zafire Aviation Software Limited is a limited liability company registered in England and Wales. Co. Reg. No. 05577742. Our registered address is Zafire House, Manor Park, Banbury, Oxfordshire OX16 3TB. VAT Reg.No. 874 5890 70 If you have any concerns regarding the content of this e-mail please contact postmas...@zafire.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: 01 August 2013 13:17 To: U2 Users List Subject: Re: [U2] What is true Hi, To add a little more to the discussion. I know in UniVerse this is true and I suspect it is true in other flavors of Pick. If you wrap a variable in parenthesis it will be treated as a Boolean test. For example: A='' IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in FALSE. A=0 IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in FALSE. A='HELLO' IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in TRUE. A=1 IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in TRUE. I have found this useful in coding. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, August 01, 2013 4:40 AM To: 'U2 Users List' Subject: Re: [U2] What is true To clarify In multivalue, True is not False, where False is anything that is 'falsy' i.e. zero or empty. Obviously different than other languages, notably those where true is -1 (all bits set on a signed integer). So: A = HELLO IF A THEN CRT A : WORLD
Re: [U2] UniData PreStore to change the KEY of a record?
Quite. Less lines than the original post. - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 29 May 2013 08:25 To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. 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
Re: [U2] SB Lookups Changes
Hi John, Have you had an SB upgrade? This is /SEC.USER.SETUP F8 and ListView Style Selects held on DMSECURITY27,21 and DMSECURITY28,21 Martin - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 21 May 2013 16:06 To: U2 Users List Subject: [U2] SB Lookups Changes As of this morning, all of the F3 lookups we have are behaving slightly differently. The results used to return in a nice, clean white list of data. For unknown reasons, this morning, the clean white display is now showing up with each piece of data being displayed within a box, very much the way Excel displays each cell. We are unaware of any changes we have made that would do this. Any ideas how to turn the Excel look off? Thanks John 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
Re: [U2] Redback error?
This is either a DMSECURITY or IICONTROL problem. Usually the former. You are having fun. Martin - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 21 May 2013 21:34 To: U2 Users List Subject: [U2] Redback error? I am getting the following message in the Redback logs: II RECORD CORRUPT! - CONTACT SYSTEM ADMINISTRATOR I think this is an Avanté/Epicor issue, but I usually get faster response from this group. Any thoughts? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. 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
Re: [U2] Redback error?
and you potted the deliberate error. I meant the latter. Try sweeping up IICONTROL manually and checking it afterwards with GUIDE. - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 21 May 2013 21:46 To: U2 Users List Subject: Re: [U2] Redback error? This is either a DMSECURITY or IICONTROL problem. Usually the former. You are having fun. Martin - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 21 May 2013 21:34 To: U2 Users List Subject: [U2] Redback error? I am getting the following message in the Redback logs: II RECORD CORRUPT! - CONTACT SYSTEM ADMINISTRATOR I think this is an Avanté/Epicor issue, but I usually get faster response from this group. Any thoughts? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. 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] UD - Display Current Terminal Type
Not ECL, but UniBasic and should work in UD on either Unix or NT X=GETENV(TERM) PRINT X vt220 - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: 24 April 2013 13:23 To: U2 Users List Subject: Re: [U2] UD - Display Current Terminal Type Sorry, I thought it was available on both UV and UD. It is a valid verb on UV: GET.TERM.TYPE Wyse Technology 50/60 (W) Width : 127 Depth : 40 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 9:09 PM To: U2 Users List Subject: Re: [U2] UD - Display Current Terminal Type :GET.TERM.TYPE Not a verb GET.TERM.TYPE :version Module Name Version Licensed UniData RDBMS 7.3 Yes Connection Pooling... 7.3 Yes Device License... 7.3 Yes NFA.. 7.3 No RFS.. 7.3 No EDA.. 7.3 No 733 Bill Untitled Page - Original Message - *From:* tewhitm...@ratex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 5:11 PM *Subject:* Re: [U2] UD - Display Current Terminal Type GET.TERM.TYPE will display the terminal type, width and depth. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. 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
Re: [U2] Compressing PDFs
Move all the PDF files to a new Unix folder FRED tar -cvf JI.tar FRED compress JI.tar This will then give you a Unix file JI.tar.Z which you can then ftp to a Windows location Accessing this file in NT will act as a zip file that can be extracted (with folder names enabled if any) - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 28 March 2013 12:55 To: U2 Users List Subject: [U2] Compressing PDFs HPUX, UniData SB: After a bunch of work, I have a UNIX directory that has a bunch of PDFs. I wish to bundle these PDFs up into a 7zip formatted compressed file. I see that there is a ported version of the Windows version of 7zip for UNIX called p7zip. Has anyone installed p7zip and if so, what else needed to be installed with it? Is it stand-alone or is it dependent on other software packages being loaded first? OR Does anyone have a simple way for UNIX to run the Windows command line version of 7zip against my UNIX PDF directory? Thanks JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. 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
Re: [U2] List..
If you are using SB, then use /FD and the filename (SODET perhaps) and then F5 - you will be looking for those items with POS.SUB zero and called e.g. ORDER.NO - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 26 March 2013 14:40 To: U2 Users List Subject: Re: [U2] List.. I am guessing that these are lines on a sales order (SODET). List the Dict to SODET (or whatever) with the LISTDICT FILENAME command. If you are using SB, you will wind up with a bunch of things other than true Dicts (like screens), but this is a start. Look for an I-Descriptor that does a FIELD command or a G (group extraction) on the key, @ID or whatever. You could also make an educated guess as to what it might be called and type something like: SELECT DICT SODET = SO] Followed by the LISTDICT command. This will limit what you see, but again, you have to have a guess as to what the name might be. If you are running in native UniData or UniVerse mode, the select would look like: SELECT DICT SODET WITH @ID LIKE SO... This is also assuming I have the file name correct. :-) We use SB where I work and I build a VOC called LISTDICT2 that does the same thing as LISTDICT but strips out the non-Dict items. Let me know if you want it. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, March 26, 2013 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] List.. Hi all,.. I have a small issue in listing a file. When I use LIST FILENAME, the data comes like 123456*001 123456*001. I would like to display the data as 123456 123456 Can someone please help me in doing this? TIA, Sathya V. ___ 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/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. 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
Re: [U2] SB+ screen translation problem
Check if this is generated. i.e. has /GC been used? Manually remove if so. Martin - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: 24 January 2013 04:33 To: u2-users@listserver.u2ug.org Subject: [U2] SB+ screen translation problem Hi SB+ Gurus, I have an interesting problem with a screen translation that I hope someone can help me with. That is, it is a sub-screen that will not work. This is working fine in production but when I make a change to the screen in development or test it will not create a working Spanish version of the screen. I have cleared the NETDRIVERS file many times but it still aborts when it tries to call the subscreen for a Mexico user with language set to Spanish.If I change the user from Spanish to English it works fine. It just won't work for the Spanish version of the screen. Has anyone had this problems before? If so, what to do to fix it? Thanks in advance, Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] Another job ad written by people who have no clue
I don't have time for this Give us all a break -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 09 December 2012 19:01 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Another job ad written by people who have no clue if not(cond) then Jump Label1 cmd1 cmd2 Jump Label2 * Label1: cmd3 cmd4 * Label2: That's all folks I think SMI's RPL has this type of requirement If you mean the IF knows when it ENDS because it hits a JUMP that's not a very nice solution -Original Message- From: Brian Leach br...@brianleach.co.uk To: U2 Users List u2-users@listserver.u2ug.org Sent: Sun, Dec 9, 2012 10:06 am Subject: Re: [U2] Another job ad written by people who have no clue since I often find myself working in mvBasic, Delphi, C#, javascript and sometimes VB.NET at the same time it is the multiline end and else syntax that is the one that trips me. Basic If cond Then blah End Else blah End Delphi If cond Then Begin blah; End Else Begin blah; End; VB.NET If cond Then blah Else blah End If .. So sometimes the C# and javascript braces are welcome! But I would add that good code is beautiful irrespective of the syntactic vagaries of the chosen language - except for TSQL of course which is always horrible. grin Brian Sent from my iPad On 9 Dec 2012, at 17:38, Wjhonson wjhon...@aol.com wrote: For a single line. I don't understand how an IF would know, for multiple lines, where it's supposed to end. With a semi colon? Horrible. Computer languages should be written for humans to read, not machines. -Original Message- From: u2ug simpson-u...@gerzio.ca To: louiebergsagel louiebergsa...@gmail.com; U2 Users List u2-users@listserver.u2ug.org Sent: Sun, Dec 9, 2012 9:32 am Subject: Re: [U2] Another job ad written by people who have no clue mv basic doesn't require an END to an IF either -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louie Bergsagel Sent: Sunday, December 09, 2012 3:21 AM To: U2 Users List Subject: Re: [U2] Another job ad written by people who have no clue I'm in my current job because I was willing to learn Python at work and on my own dime. I took a beginner's course in Python at the University of Washington because I didn't know much besides Prime Information, Henco's Info, Structure/4, UniVerse, UniData and MITS. It was fun to learn Python as the syntax was so similar to Pick basic. Program controls is through indentation, which we usually use anyway. They even go Pick one better: an IF statement doesn't need an END. They all require one, right, so why not assume it? I love that thinking. Learn some Python. You'll be glad you did. ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== 1O3VGvZQIqY7TB0O9Dz9j4aDK!jBrZYucwFoPzuIXnePg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] Another job ad written by people who have no clue
So sad. Do you have any hobbies? Other than creating havoc on respectable U2 lists I mean. I can recommend a good psychiatrist. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 09 December 2012 20:15 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Another job ad written by people who have no clue Those of us who *wish* to discuss it can continue, and those who don't want to read it, should stop reading it and whining about being *forced* to read it ;) You aren't. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== DcA+CTCYoVqysIEwS6ur!2UDK!jBrZYuczOTml8Ao4xWg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] SB Client question
Since you are using SBClient, you could use /TCL rather than Real TCL (0) and the problem will go away if your emulation is correct. Insert at Real TCL will give a control character issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: 07 December 2012 22:50 To: U2 Users List Subject: Re: [U2] SB Client question The terminal emulation is Wyse60. I don't use the insert key when at TCL because I just enter 'I' at the command prompt when I am in the editor and there is never a reason for insert key to be pressed otherwise. I am not sure how to reassign the key but I don't think that I want to do that because I do use the insert key when I am in the full-screen editor or SB+ screen. I went to the Setup tab and changed the terminal type to VT220 and the editor worked like it should but when I changed it back to Wyse60 it had the same old problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 2:40 PM To: U2 Users List Subject: Re: [U2] SB Client question I've never had this problem but I'd look at the terminal emulation you're using. You might try using a different terminal type then see if you can replicate the problem. I would imagine you don't use the insert key since it seems to mess you up (only at TCL???) so maybe redefine just that key? Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== 8rtCBEd1+lbIRILJ5VXZDG75sRojb7FJUAVpvj!OtdP1Q== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] SB Client question
You have a stacker with /TCL via up/down arrows or F3. SAVE-LIST/GET-LIST should work perfectly. You DO have issues if they don't work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: 07 December 2012 23:05 To: U2 Users List Subject: Re: [U2] SB Client question That is true. I could use /TCL but I lose all of my stacker info. Plus save-list and get-list do not always work the way I expect them to. Maybe I will just have to live with this problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: Friday, December 07, 2012 3:00 PM To: U2 Users List Subject: Re: [U2] SB Client question Since you are using SBClient, you could use /TCL rather than Real TCL (0) and the problem will go away if your emulation is correct. Insert at Real TCL will give a control character issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: 07 December 2012 22:50 To: U2 Users List Subject: Re: [U2] SB Client question The terminal emulation is Wyse60. I don't use the insert key when at TCL because I just enter 'I' at the command prompt when I am in the editor and there is never a reason for insert key to be pressed otherwise. I am not sure how to reassign the key but I don't think that I want to do that because I do use the insert key when I am in the full-screen editor or SB+ screen. I went to the Setup tab and changed the terminal type to VT220 and the editor worked like it should but when I changed it back to Wyse60 it had the same old problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 2:40 PM To: U2 Users List Subject: Re: [U2] SB Client question I've never had this problem but I'd look at the terminal emulation you're using. You might try using a different terminal type then see if you can replicate the problem. I would imagine you don't use the insert key since it seems to mess you up (only at TCL???) so maybe redefine just that key? Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== 8rtCBEd1+lbIRILJ5VXZDG75sRojb7FJUAVpvj!OtdP1Q== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] BFORMAT
Pass on BFORMAT but ummm, doesn't ED have the FOR command? FOR -M0 -I2 (margin zero, indent 2) Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: 28 November 2012 21:43 To: U2 Users List Subject: Re: [U2] BFORMAT Hi Does anybody have a working copy of BFORMAT - I downloaded it from some useful site a long time back and modded it to work for modern UniVerse, but somewhere along the line (one late night) I have introduced some bugs I don't have time to go fix.. so before I do, maybe someone out there already has a BASIC formatting program that will allow me to only have an indent of 2 spaces instead of the usual 6? Anyone? Thanks Dennis ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== mFG8GTB3HjWZZWswXfBxQrQmlpQUG1hf7xue2rhFpgg0Q== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] BFORMAT
I now know why I prefer UniData. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 28 November 2012 21:53 To: 'U2 Users List' Subject: Re: [U2] BFORMAT FORMAT -M0 -I2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, November 28, 2012 4:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] BFORMAT ED BP A 10 lines long : FOR Try HELP. -Original Message- From: Martin Braid mbr...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 28, 2012 1:48 pm Subject: Re: [U2] BFORMAT Pass on BFORMAT but ummm, doesn't ED have the FOR command? FOR -M0 -I2 (margin zero, indent 2) Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: 28 November 2012 21:43 To: U2 Users List Subject: Re: [U2] BFORMAT Hi Does anybody have a working copy of BFORMAT - I downloaded it from some useful site a long time back and modded it to work for modern UniVerse, but somewhere along the line (one late night) I have introduced some bugs I don't have time to go fix.. so before I do, maybe someone out there already has a BASIC formatting program that will allow me to only have an indent of 2 spaces instead of the usual 6? Anyone? Thanks Dennis ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== mFG8GTB3HjWZZWswXfBxQrQmlpQUG1hf7xue2rhFpgg0Q== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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] Loading a UNIX-based UNIDATA file system on a Windows system...
and you want to make sure that the originating UNIX system does not have files named in both upper and lower case e.g. EMPLOYEES and employees. That causes some fun. Correct these on the UNIX side before an attempt is made. There are standard utilities e.g. NT_SCOUT for checking issues prior to conversion (written to _HOLD_) On UniData the simplest method of transferring ACCOUNTNAME from Unix to NT is:- tar -cvf MDB.tar ACCOUNTNAME compress MDB.tar This will then give you a single Unix file MDB.tar.Z which you can then ftp harmlessly. Accessing this file in NT will act as a zip file that can be extracted with folder names enabled. Go to the exploded NT directory and CONVMARK 255/192/129 ACCOUNTNAME CONVDATA -r ACCOUNTNAME CONVCODE ACCOUNTNAME CONVIDX -r ACCOUNTNAME UPDATEVOC -oca ACCOUNTNAME Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 07 November 2012 10:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... And to add even further to the mix ... bear in mind my advice is about operating systems not U2, and my knowledge is UV not UD ... Are you SURE it's not needed if the source is Linux? Or do you actually mean Linux/x86? Certainly with UV, the OS is irrelevant, what matters is the endian-ness of the chip, so files can be freely copied between Intel machines regardless of OS. (Mind you, you probably can't get U2 for non-Intel Linux :-) And nobody has even mentioned the file-corruption issue the OP asked about ... this is *probably* ftp. Could be samba. Anyways, you need to make sure that however you copy the files, you tell it that it is a binary file. If ftp or samba think it's a text file, it will translate between crlf and lf (and cr on a mac, I believe). Cheers, Wol On 06/11/12 21:03, Wally Terhune wrote: Fnuxi is UniVerse - not UniData. UDTBIN\convdata will convert the byte order of hashed files. If the source machine is Linux, this will not be necessary. You will need to run it - if the source UNIX is AIX, HPUX, Solaris. Convidx will convert UniData indexes. If you need to run programs: convcode Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 06, 2012 1:49 PM To: U2 Users List Subject: Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system... After loading the data on the Windows system you will have to run fnuxi (C:\u2\UV\bin\fnuxi) on each file you wish to access. I would suggest you do this as follows: - locate the directory where the UniData files are loaded - run fnuxi on the VOC and D_VOC - drop into UniData and create a listing of the files in the directory (LIST ONLY VOC WITH F1 = F) output to the hold file and copy the list from the hold file to the directory containing the UniData files - using the editor of your choice prefix each line in the file tie c:\u2\UV\bin\fnuxi.exe and save it as a windows .bat file - run the batch file to convert all the files. - edit the batch file and change all the filenames to D_filename - run it again Robert wrote: I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== tflf2J7gTMnv4MtWkFx2NBVUENuAmfNZOqsCq9I+zBdpQ== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it
Re: [U2] SB+ question
Yes. You need CAIDE (use the F3) on an input controlling field and paging is automatic. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 23 October 2012 08:30 To: U2 Users List Subject: Re: [U2] SB+ question I always leave one input field usually containing the line number set as controlling the other fields but don't allow changes to the field. You obviously need an input field for the cursor so you can use page up or down. On 23/10/2012 00:46, Lunt, Bruce wrote: Hi All, I have a question that relates to how to display multiple pages of data on an entry screen that does not allow the lines in question to be modified. What we have is a screen that displays the current status of a customer. There are 6 different multivalued fields that are all related but they are just being displayed. There are 2 fields above the line-item section that do allow modification but the request is for me to allow the user to page up or down to review all of the line-items. On inquiry screens this is fairly simple but I don't know how to drive the pagination when the 6 fields are never even accessed by the screen. I tried to bump the @CNT field but that didn't work. Can someone suggests how I should handle this? All suggestions are greatly appreciated. Thanks in advance, Bruce Lunt ___ 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/MZbqvYs5QwJvpeaetUwhCQ== WuZAUpI7tSremuGzpV7zxTq0S2vc9r44DuURD1dro2FIg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] Selection Suggestions for using UV instead of SQL
I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd do - create an index on file2 based on PID. Create an idescriptor on file1 that gets the contents of that index. I had a routine somewhere that got fed an index value and file, and returned the contents of the index. It was quite useful, iirc. Manipulate it from there. Probably selecting where there is no value matching ...+1+... Cheers, Wol ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== eUdxXwzJfD+jSPSM4kcQUHfMaOyCAuUs69aXEW7R1X!lw== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and 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
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the master process, and let your SUBR virtual field default to list 0 {zero}? The other option could be to do a READLIST within the SUBR function and reset the list when RETURNing, but this could be onerous in terms of processing speed. HTH -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 11:43 AM To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 04y!LlOoL8USVGrPZehFfPKcPPmbfFPdrr1lqOECv!Swg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] U2 Bug reporting / list monitoring
Not quite succinct, but well said. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 31 August 2012 19:14 To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Bug reporting / list monitoring Three topics here... From: Wjhonson 1) Not support though. Bugs. In my book, they are opposite ends of the spectrum. And a company that ignores bug reports because they don't come through approved channels is heading in the direction of Netscape and Liquid Audio. Questions and answers aren't always simple. The bug you see in your system might only manifest under specific conditions. It takes time to understand those details and then to reproduce the case internally so that a vendor can then fix the problem. Even when you publish details about a bug, a tech needs to verify the information. Usually notes in forums are incomplete - often simply wrong. It takes technicians time to verify, diagnose, reproduce, and log anomalies. Someone must pay the techs for their time. That's what Support/Maintenance fees are for. Sure, sometimes it's a slam-dunk - someone reports a bug and the issue seems like an obvious bug that should get logged and processed. But then comes the question about why are we doing this? Can a company justify a product change because someone in a public forum reported it? What's the priority of this compared to other reports logged by paying clients? If a paying client doesn't report an issue, might this not be an indication that this is not a serious-enough issue for paying clients, and thus not worth a development effort? On this notion I've had strong arguments with many people - I believe people are often more inclined to leave a platform than to report bugs, so bugs need to be identified and squashed however possible. If the process of reporting issues is too rigorous, That is a separate problem that needs to be addressed with paying clients. All of these things need to be considered, but without following processes, chaos rules. WJ, you're a huge fan of chaos. That simply doesn't work well in the real world. 2) I agree there are consultants who know tricks and make customers pay for not only their knowledge of those tricks, but the hours it took them, perhaps unpaid, to acquire that knowledge. But to make the 20th customer pay the same hours as the 19th customer did, is really a bit shocking. As long as people are asking specific questions there will be someone charging for related answers. Quality is a factor that can make the 20th answer as valuable as the 1st or the 19th. Information has just as much value to the 20th customer who does not have that information as it did to the 1st customer who did not have that information. As long as there are people out there who perceive value in something, there will be others who offer that value at varying prices and with varying degrees of quality. There might be people willing to pay for information because they believe it has value to them. Others will not be willing to pay anything or as much, because to them the information has less value. By offering information for free, because a consultant has earned enough for it, he/she is re-defining the value of the specific offering for everyone. The market also redefines value. Pricing based on what consumers will bear has been the basis of trade for thousands of years, and defines the nature of the stock market. Your notion of shocking doesn't fit the world as it has existed for millenia. 3) That *some* people in the professional services world, wish that user groups didn't exist, so they could keep charging high prices for simple questions... is perhaps too bad on them. I don't believe anyone has said what you just suggested. Will, this has been an ongoing subtheme of yours for years. Really, anyone can go back into archives and check that we've talked about this many times. You expect other people to do research and then to provide complete, site-specific answers in public forums so that you can then get your customers to pay you for solutions. We're not here to do your research, and those of us who continue to do research every day and night can't pay our own bills if we keep giving away our findings. We use data as raw materials, and manufacture knowledge and context-specific, actionable information as our product. Take your time to manufacture a product and give it away if you wish, but those of us who are not independently wealthy cannot afford to do so, especially for your benefit. So please, once again, stop asking. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== !tHfodsaR+!P3M2s8oL93KJZhAszQEBXlqVy4oAFznL6w== to report this email as spam.
Re: [U2] Web Error
Delete LIVE.DATA from your ODBC connections and recreate it -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 16 August 2012 18:09 To: 'U2 Users List' Subject: [U2] Web Error Yesterday, we had a DR test where we used all of our DR hardware to test our DR plan. Everything in Avante went fine as did most of our ePortal testing. However, when it came to the web pages connecting to the Avante account (as opposed to connecting to the ePortal account), I am getting the nebulous 500 error message in my browser. To eliminate any misleading messages, I have bounced RedBack (thus clearing out the logs and starting fresh), stopped IIS, cleared all logs in IIS, changed Windows\rgw.ini to use the DR box name (wdhp7640), then restarted IIS. When I attempt to go to the web page in question, I get: 2012-08-16 16:38:28 172.16.1.22 POST /ePortal/std/storefront/shipping.asp guid=43442041196|162|80004005|Can't_connect_to_account_'LIVE.DATA'_(wdhp 7640:8509)_rc=-1_ 443 - 192.168.9.232 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.1;+WOW64;+Trident/5.0;+S LCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+InfoPa th.2;+.NET4.0C;+.NET4.0E) 500 0 0 15537 The key point being: Can't_connect_to_account_'LIVE.DATA'_(wdhp7640:8509) Here is the updated Windows\rgw.ini rbexamples wdhp7640:8501 rbodemo wdhp7640:8502 EPORTAL wdhp7640:8503 LIVE.DATA wdhp7640:8509 == EPORTAL_PILOT wdhp7640:8505 PILOT.DATA wdhp7640:8506 EPORTAL_DEV wdhp7640:8507 TEST.DATA wdhp7640:8508 [LogLevel] panic=1 err=1 wrn=0 inf=0 init=0 trace=0 verb=0 big=0 What am I missing? It connects to the EPORTAL account just fine. I have convinced management to leave things in a DR mode until the end of the day to try to figure this out. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== s+!ICtCF3ulfLlPD6aicL5PvYXhYd9V7qILtzovJ!KJwA== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] trimming a list (a test of your ability)
String concatenation will probably work faster since it doesn't care about pointers IF NEW.LIST# THEN NEW.LIST := @AM (or @VM if you want in the original format) NEW.LIST := UTILITY.ID Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: 12 July 2012 14:20 To: Marco Manyevere; U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) This is the best solution, using REMOVE and building a new list instead of constantly 'shrinking' the original table. That being said, as NEW.LIST gets rather large, adding new elements to it can get 'time' consuming. Just like the REMOVE keeps track of the pointer as you spin through a table, I wish there was a comparable statement that kept track of the pointer as we added new elements -1 to tables. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere Sent: Thursday, July 12, 2012 4:14 AM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) Is this what the OP is asking about or I'm missing something? The 2 code fragments look totally different. We dont know what's happening in GET.UTILITY.RECORD or the significance of UTILITY.NAME and LAST.NAME to totally eliminate them during the 'optimisation' I would rather do: NEW.LIST = '' LOOP REMOVE UTILITY.ID FROM KEY.LIST SETTING MORE WHILE MORE:UTILITY.ID GOSUB GET.UTILITY.RECORD IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN CONTINUE NEW.LIST-1 = UTILITY.ID REPEAT KEY.LIST = NEW.LIST NEW.LIST = '' ;* free the memory From: Kate Stanton k...@walstan.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, 12 July 2012, 4:27 Subject: Re: [U2] trimming a list (a test of your ability) I am getting sucked in! NLST =;* For new list MAXI = DCOUNT(KEY.LIST1,@vM) ;* Count items FOR INO =1 TO MAXI ;* Each key in list KEY.ID = KEY.LIST1,INO;* A key ID LOCATE(KEY.ID,NLST,1;POS;'AL') ELSE ;* see if there INS KEY.ID BEFORE NLIST1,POS ;* Sort to list END NEXT INO ;* Check all keys On 12 July 2012 12:09, Wjhonson wjhon...@aol.com wrote: 1295 FOR DISPLAY.LOOP = 1 TO KEY.COUNT 1296 UTILITY.ID = KEY.LIST1,DISPLAY.LOOP 1297 GOSUB GET.UTILITY.RECORD 1298 IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN 1299KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0) 1300DISPLAY.LOOP -= 1 1301KEY.COUNT -= 1 1302 END 1303 NEXT DISPLAY.LOOP Comments? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.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 Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] [UV] Program X: Line 2, WRITE failure. ( SYS.MESSAGE 040019 )
Correct. I was merely stating that these cause UniBasic WRITE failed and may cause your error in UV. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 12 June 2012 23:48 To: U2 Users List Subject: Re: [U2] [UV] Program X: Line 2, WRITE failure. ( SYS.MESSAGE 040019 ) Thanks, but does UD have the same error numbers as UV? Something similar, but not exactly the same as SYS.MESSAGE, uv/errlog file, right? I'm looking for causes of that particular 040019 WRITE failure. A very particular number for a very generic error. (A wonderful documentation enhancement would be a better description of the error codes and their possible causes.) On 6/12/2012 3:52 PM, Martin Braid wrote: Not a complete list, but on UD ... You are writing a key containing an asterisk into a DIR type file. Permissions. A programming error to do with STATUS in a global Trigger routine. Possible problem with e.g. McAfee not releasing at NT level fast enough. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 12 June 2012 21:02 To: U2 Users List Subject: [U2] [UV] Program X: Line 2, WRITE failure. ( SYS.MESSAGE 040019 ) Does anyone have a complete list of what kinds of problems will throw this error? RUN CDS.BP X Program X: Line 2, WRITE failure. uv\errlog: Tue Jun 12 15:54:05 12848 cdstevenson Program X: Line 2, Message[040019] Although I generated it here by attempting to write a record with a system delimiter in the Id: 01 OPEN 'CDSTMP' TO F ELSE STOP 201 02 WRITE '' TO F, 'ABC':@VM:'XYZ' while I have UVCONFIG's param prohibiting that: ALLOWMARKS 0 Yet, I fear there are several sundry ways to yield up that generic message. Care to contribute to the list? Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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/UQtlIgW3oe3TndxI!oX7UsdpzMR7Bo2KGxvzgiKsg 3EzN8QNo+nd3rIcH9XOUWY3duLqcdA6XX!FX!XDabuzkg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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] Attribute Problem
You've already got the answer. Use F_MATL instead of F-MATL and stop thinking about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 02 May 2012 20:13 To: u2-users@listserver.u2ug.org Subject: [U2] Attribute Problem Hi. I think I have finally gone insane. I am having a problem with the attribute MATL.AMT. It calculates the extended amount on hand by taking the frozen material cost times the on hand amount. The problem is when I use F_MATL for the frozen material cost, MATL.AMT is good. When I use F-MATL for the frozen material cost, it returns 0 everytime. F_MATL and F-MATL are identical and if you list them both work fine. But when they are used in the calculation F_MATL works, but F-MATL. doesn't. Can anyone see what the problem is? ** :AE DICT INVENTORY-LOCATION_18 MATL.AMT Top of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43 characters. *--: P 001: V 002: ON.HAND * F-MATL 003: MR25, 004: MATERIAL.AMT 005: 13R 006: S Bottom. ** :AE DICT INVENTORY-LOCATION_18 F_MATL Top of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters. *--: P 001: V 002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66) 003: MD5, 004: MATERIAL/UNIT 005: 13R 006: S Bottom. *** :AE DICT INVENTORY-LOCATION_18 F-MATL Top of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters. *--: P 001: V 002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66) 003: MD5, 004: MATERIAL/UNIT 005: 13R 006: S Bottom. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] The CONTINUE statement
Here we go again. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 26 April 2012 22:39 To: u2-users@listserver.u2ug.org Subject: Re: [U2] The CONTINUE statement You said you had no idea what it was. How are you going to respond to the point, without knowing what the code actually does? -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 2:36 pm Subject: Re: [U2] The CONTINUE statement - || || MoreEnd Help List Commands || - || |+-- --- The CONTINUE statement is a loop-controlling statement. For syntax details, ee the FOR statement and the LOOP statement. So what... ? --Bill -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Thursday, April 26, 2012 5:27 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] The CONTINUE statement t TCL type HELP BASIC CONTINUE -Original Message- rom: Bill Brutzman bi...@hkmetalcraft.com o: U2 Users List u2-users@listserver.u2ug.org ent: Thu, Apr 26, 2012 2:26 pm ubject: Re: [U2] The CONTINUE statement . I do not see a continue statement in the UniVerse manual. There is the exit command... used to break out of a loop... when a certain ndition is satisfied. The point of the original post is not clear to me. -Bill Original Message- om: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of Wjhonson nt: Thursday, April 26, 2012 5:12 PM : u2-users@listserver.u2ug.org bject: [U2] The CONTINUE statement OR I = 1 TO X do something IF some condition THEN CONTINUE do something else XT I ersus OR I = 1 TO X do something IF NOT(some condition) THEN do something else XT I _ -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 Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== n2pTd2PMK1wi0RsnJFyHNsuOdrLq1veiccY6wpstbrpNg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] YYMMDD easy way?
OCONV(DATE(),D2YMD:@VM:MCN) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 25 April 2012 00:52 To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 2eKQFaw1sOoTA9gaOpFHJJo+VEWAxlvp7UeaPLWGci2!g== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] Remove items from lsit in DICT
Or just EV the attribute and then C/B//G and FI twice. Assuming there are no linked MV attributes that also need messing with. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 06 April 2012 03:26 To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT G option for C might come in handy here (Global: repeats command until there are no more matches) ^ C/B^253//G Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 05, 2012 4:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Remove items from lsit in DICT ^ up-arrow-mode C/B^253// C C C C C C C -Original Message- From: Holt, Jake jh...@samsill.com To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Apr 5, 2012 3:06 pm Subject: [U2] Remove items from lsit in DICT This is probably really simple, but I can't seem to find a way without riting a sub. Is there an easy way to simply remove items from a MV ield in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just emove the Bs. Thanks, Jake Holt | samsill | Information Technology Director p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.com mailto:jh...@samsill.com | www.samsill.com | ww.bindersforlife.com ___ 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 Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== D2VHiLeE8cjwJ+6UKgOADBjSxIHBYlYk1F8TccP!XTbKg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] Redback Connection Problem
1) Try stopping/starting RedBack 2) Ensure that you are an SB ROOT user and log to LIVE to ensure everything compiles (rolling to LIVE does not recompile - you have to log there) Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 22 January 2012 06:00 To: U2 Users List Subject: Re: [U2] Redback Connection Problem Hi John My guess is that there are security restrictions on the Live system that are not on the test system Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Sunday, 22 January 2012 2:53 PM To: 'U2 Users List' Subject: [U2] Redback Connection Problem I have 3 UniData accounts (LIVE.DATA, PILOT.DATA TEST.DATA). Each has its own web site (live, pilot test). We are using Redback (U2 Web DE). We are using Epicor's Avanté backend and a HEAVILY customized version of their ePortal web software. Over the past few months, I have developed code in TEST and moved it to PILOT for user testing. Everything works 100% in TEST and PILOT. Today, I loaded everything from PILOT to LIVE (UniData code, web stuff, Redback objects, etc.) There are 2 ways that the web pages connect to UniData: myCart.Open2 account,SF:oPreOrder - where myCart is the object account is the ePortal account (sister account to the Avanté account) and oOrder.Open2 accnt,SF:oOrder,userid,passwd- where oOrder is the object, accnt is the Avanté account userid is the Redback login passwd is the Redback passwd I have never been told the reason for a difference, but it works cleanly in TEST and PILOT , but the 2nd type of connection is failing in LIVE. I have confirmed that the userid and password are correct (the same in TEST and PILOT since Redback is global) and accnt is the intended Avanté account. If I do not get success over the weekend, I will be contacting Epicor for help, but I would REALLY like to get this working before Monday. Any thoughts? John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. ___ 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/wQw0zmjPoHdJTZGyOCrrhg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] Redback Connection Problem
SB Group Security restriction on the userid in LIVE.DATA ? SYS3030 for the SB user may need Open Process Calling flag setting and SYS0161 running in LIVE.DATA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 January 2012 22:18 To: U2 Users List Subject: Re: [U2] Redback Connection Problem Done all of that. Thanks John Israel Sent from my iPhone On Jan 22, 2012, at 5:16 PM, Martin Braid mbr...@epicor.com wrote: 1) Try stopping/starting RedBack 2) Ensure that you are an SB ROOT user and log to LIVE to ensure everything compiles (rolling to LIVE does not recompile - you have to log there) Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 22 January 2012 06:00 To: U2 Users List Subject: Re: [U2] Redback Connection Problem Hi John My guess is that there are security restrictions on the Live system that are not on the test system Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Sunday, 22 January 2012 2:53 PM To: 'U2 Users List' Subject: [U2] Redback Connection Problem I have 3 UniData accounts (LIVE.DATA, PILOT.DATA TEST.DATA). Each has its own web site (live, pilot test). We are using Redback (U2 Web DE). We are using Epicor's Avanté backend and a HEAVILY customized version of their ePortal web software. Over the past few months, I have developed code in TEST and moved it to PILOT for user testing. Everything works 100% in TEST and PILOT. Today, I loaded everything from PILOT to LIVE (UniData code, web stuff, Redback objects, etc.) There are 2 ways that the web pages connect to UniData: myCart.Open2 account,SF:oPreOrder - where myCart is the object account is the ePortal account (sister account to the Avanté account) and oOrder.Open2 accnt,SF:oOrder,userid,passwd- where oOrder is the object, accnt is the Avanté account userid is the Redback login passwd is the Redback passwd I have never been told the reason for a difference, but it works cleanly in TEST and PILOT , but the 2nd type of connection is failing in LIVE. I have confirmed that the userid and password are correct (the same in TEST and PILOT since Redback is global) and accnt is the intended Avanté account. If I do not get success over the weekend, I will be contacting Epicor for help, but I would REALLY like to get this working before Monday. Any thoughts? John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] End of Month date routine
LEAP.YEAR needs to be FALSE at the start -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 07 December 2011 18:49 To: u2-users@listserver.u2ug.org Subject: Re: [U2] End of Month date routine Because ? -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Dec 7, 2011 10:22 am Subject: Re: [U2] End of Month date routine That doesn't give the correct results, although removing the comparisons with 0 ill improve it's performance - as you say. Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Wednesday, December 07, 2011 10:29 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] End of Month date routine his algorithm is redundant and also fails to take into account the Boolean ature of the terms and thus adds extra unneeded op codes in the compare to 0 nd compare to 1 steps. Below is the equivalent BEGIN CASE CASE MOD(YEAR,400) ;LEAP.YEAR = TRUE CASE MOD(YEAR,100) ;LEAP.YEAR = FALSE CASE MOD(YEAR,4) ;LEAP.YEAR = TRUE ND CASE Leap year algorithm to detect if today is a leap year EAR = OCONV(TODAY,DY) MOD(YEAR,4) = 0 THEN IF MOD(YEAR, 100) = 0 THEN IF MOD(YEAR, 400) = 0 THEN LEAP.YEAR = 1 ELSE LEAP.YEAR = 0 END ELSE LEAP.YEAR = 1 D ELSE LEAP.YEAR = 0 -Original Message- rom: Daniel McGrath dmcgr...@rocketsoftware.com o: U2 Users List u2-users@listserver.u2ug.org ent: Wed, Dec 7, 2011 8:02 am ubject: Re: [U2] End of Month date routine erfectly fine except if you need to run this is a very large loop (such as atch rocessing 100 million records - although it only adds about 1.5 mins on y achine). he modulo method takes (roughly) 54% the execution time of ICONV. This would be cause of the extra processing ICONV has to do internally as well as the string ncatenation and memory allocation from Feb 29:YEAR Just something to keep in he back of the mind. Date Conversion to detect if today is a leap year EAR = OCONV(TODAY,DY) EST ICONV(Feb 29:YEAR,D) EAP.YEAR = (STATUS() = 0) Vs Leap year algorithm to detect if today is a leap year EAR = OCONV(TODAY,DY) MOD(YEAR,4) = 0 THEN IF MOD(YEAR, 100) = 0 THEN IF MOD(YEAR, 400) = 0 THEN LEAP.YEAR = 1 ELSE LEAP.YEAR = 0 END ELSE LEAP.YEAR = 1 D ELSE LEAP.YEAR = 0 Original Message- om: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of David A. Green nt: Wednesday, December 07, 2011 8:25 AM : 'U2 Users List' bject: Re: [U2] End of Month date routine YEAR = OCONV(PASS.DATE, DY) EST = CONV(Feb 29 :YEAR, D) EAP.YEAR = (STATUS() = 0) David A. Green 80) 813-1725 G Consulting Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath nt: Tuesday, December 06, 2011 4:22 PM : U2 Users List bject: Re: [U2] End of Month date routine Leap years are a little more complex han MOD(YEAR,4) From http://en.wikipedia.org/wiki/Leap_years#Algorithm f year modulo 4 is 0 then if year modulo 100 is 0 then if year modulo 400 is 0 then is_leap_year else not_leap_year else is_leap_year se not_leap_year -Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester nt: Tuesday, December 06, 2011 4:16 PM : U2 Users List bject: Re: [U2] End of Month date routine Your method is also the way I've lways done it, but an alternate method just ame to mind: ONTH = OCONV(DATE, 'DM') AR = OCONV(DATE, 'D Y[Z4]') AP = MOD(YEAR, 4) = 0 NTHS = '' NTHS1 = 31 NTHS2 = 28 + LEAP NTHS3 = 31 NTHS4 = 30 NTHS5 = 31 NTHS6 = 30 NTHS7 = 31 NTHS8 = 31 NTHS9 = 30 NTHS10 = 31 NTHS11 = 30 NTHS12 = 31 ST.DAY = MONTHSMONTH ot very concise, but you can tell at a glance how many days your dealing with. ---Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake nt: Tuesday, December 06, 2011 2:34 PM : U2 Users List bject: Re: [U2] End of Month date routine Someone has probably already uggested one like this but I use: ATE = ICONV(2-11-11,'D') NTH = OCONV(DATE,DM) AR = OCONV(DATE,DY) NTH += 1 MONTH 12 THEN NTH = 1 AR += 1 D AST.DAY = ICONV(MONTH:/1/:YEAR,'D')-1 ___ -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 __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list
Re: [U2] I-Type question in PH
You could of course ESEARCH for the string ompleted. And when that produces a select list, smash them to hell and back. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 30 November 2011 19:40 To: 'U2 Users List' Subject: Re: [U2] I-Type question in PH Or if you are on *nix something like find /usr/ud/accounts/accountname/_PH_ -mtime +2 -exec rm -rf {} \; deletes anything over 2 days old -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: 30 November 2011 16:37 To: 'U2 Users List' Subject: Re: [U2] I-Type question in PH UniData has the _PH_ file which is a DIR type file. There is the DIR() function that will return a lot of information for you without the expense of opening the file. Perhaps UniVerse has something similar. See http://www.pickwiki.com/cgi-bin/wiki.pl?GetOsInfo for examples and code on how to use it to get the OS date/time/size quickly and easily. hth Colin Calgary, Canada -Original Message- From: Perry Taylor If you don't want to mess with the nuances of the PH ID you can call a subroutine which does an OPENSEQ then uses STATUS to get the modification date right from the file system. Perry - Original Message - From: Charles Stevenson You can also get elapsed time by subtracting that ID date-time stamp from the os's date-time-modified stamp, which is when the job ended. (if the job writes to the PH log as it ends.) On 11/29/2011 4:01 PM, John Thompson wrote: Yep... need more sleep. Thanks. On Tue, Nov 29, 2011 at 4:58 PM, Wjhonson wrote: Third field, not second field FIELD(@ID,'_',3) -Original Message- From: John Thompson So I thought I would build an I-type to get the date of thePH items in niverse so I could more easily purge them... The item id looks like so: AUTOMATED.UPDATE.REO_23400_15641 The friendly manual says that the item id is: hantomverb_time_date So my I-type looks like so: 001 I 02 FIELD(@ID,'_',2) 03 04 Date 05 10 06 R And of course, I have not put in the conversion code yet... The output of the I-type is this: ID.. Date.. AUTOMATED.UPDATE.REO_23400_15641 23400.0 What am I missing? Shouldn't Date be 15641? -- ohn Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4047 - Release Date: 11/29/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== lIy9jFKn4LiZyzlRHz9PH0wlkCR7TUWOqrbd8XIx2vetQ== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] Wintegrate 3 on Windows 7 issues
If you use Player to load an image, then Wintegrate will not start until you close the Player (not the image, the Player itself) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 09 November 2011 22:16 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Wintegrate 3 on Windows 7 issues From: Martin Braid VMWare also interferes with Wintegrate. Martin How so? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 9f4bTj7EW4NlTSDp90VMg7XIidmxQ5+qTmVy4oAFznL6w== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] Wintegrate 3 on Windows 7 issues
VMWare also interferes with Wintegrate. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Scott Richardson Sent: 09 November 2011 02:34 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Wintegrate 3 on Windows 7 issues On 11/8/2011 9:01 PM, iggch...@comcast.net wrote: Thanks Scott. I'll try turning off UAC and see if that does the trick. - Original Message - From: Scott Richardsoncheetah...@comcast.net To: u2-users@listserver.u2ug.org Sent: Tuesday, November 8, 2011 8:40:52 PM Subject: Re: [U2] Wintegrate 3 on Windows 7 issues On 11/8/2011 8:19 PM, Jeff Butera wrote: Slight tangent that may shed light. Back when Datatel was based on wIntegrate, we would occasionally see this behavior for some machines deployed on campus. In short, another process (often TSR) would somehow block wIntegrate. In some cases it was MS Office Taskbar, in others it was been antivirus. As you point out, once the offending program was terminated, wIntegrate fired up like nothing was wrong. On 11/08/2011 07:57 PM, iggch...@comcast.net wrote: Hi All, Before I begin let me state that I know that I have an old version and should look into a better way. However, I'm stuck using the Wintegrate version that I have for the time being. That being said... Can anyone tell me a way of determining what is interfering with my Wintegrate application firing up? I just began experiencing the problem l ast night. I attempt to open the application and it never shows itself. I can see it in task manager. Image NameUser NameCPUMemory Description MSOSYNC.EXE THOMPSC 00 3364K Microsoft Office Document Cache w integ.exeTHOMPSC 00 wowexec.exe THOMPSC 00 It looks odd to me for winteg.exe to be a child of MSOSYNC.EXE. Maybe that's not the case but it looks that way in task manager. After quite a long time, the application will suddenly appear without rhyme or reason. My initial thought was that it was a communication issue with my host. However, I can ping without any loss whatsoever. Any advice would be greatly appreciated. Thanks Scott ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users UAC on Windows 7 is infamous for such behavior ? ___ 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 UAC being turned off requires a reboot for it to take affect - another poster seems to have another solid idea as well. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 7cQu3yEMwy9WBR61CE7HAf3a54hJhFMuZ2DEGNPdlyNkQ== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] Using 'MATCH'
Hi Greg, I would convert your string to a VM array, use the LOCATE syntax to add it if relevant and then convert back to a string. Martin (I am not going to worry why you aren't just using an array) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: 31 October 2011 17:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using 'MATCH' Hey Guys, I am concatenating an alpha code into a string providing that the code does not already exist (in the string). If my existing string = X.STRING and my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN END ELSE X.STRING = X.STRING:',':X.CODE END Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, 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
Re: [U2] FAST
Indeed. (F)utile (A)rgument (S)top (T)his Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Barouch Sent: 07 October 2011 17:42 To: U2 Users List Subject: Re: [U2] FAST This seems like a good time to declare END OF THREAD. Charles Barouch ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== XE6njD7W27YDBYeKVyEWl4lQm!+n!ECf!q1yubdBaCdqw== 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. 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
Re: [U2] The math just doesn't work.
ICONV everything MD2 and check that for equality -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Hammerle Sent: 29 September 2011 13:30 To: u2-users@listserver.u2ug.org Subject: [U2] The math just doesn't work. Can anybody please help? For some reason A + B does not equal C in the comparison below. Is there any trick to get the comparisons to work properly? Unidata 7.2 on Hp Unix 11+ Top of TEST.COMP in RMH.MAIN, 13 lines, 263 characters. *--: P 001: A = 3176.79 002: B = 106.19 003: C = 3282.98 004: D = 920.11 005: A = A + D 006: C = C + D 007: IF (A+B) # C THEN 008: CRT '(A+B) # C? YOU LIE' 009: CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C 010: END ELSE 011: CRT '(A+B) = C? YOU ROCK' 012: CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C 013: END Bottom. *--: FIBR Filed TEST.COMP in file RMH.MAIN unchanged. Compiling Unibasic: /db1/ud1/PGM/RMH.MAIN/TEST.COMP in mode 'u'. compilation finished (A+B) # C? YOU LIE A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 George Hammerle Programming Dude Hubert Company LLC. 9555 Dry Fork Road Harrison, Ohio 45030 513-367-8974 zhammerle@hubertREMOVE_THIS.com This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or company to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and delete this e-mail including all attachments from your system. Thank you ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== AE52BnsDXn5pV+hkVGX5HIJHEbJBLmXkgHQE4zD1Sgchg== 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. 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
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 u2-users@listserver.u2ug.org *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] 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] /GC at SBXA 6.0.5.2501 not compiling
ALLOW.PDF is unassigned in the generated code. Simple to fix, but annoying. DMGC GC.PD.R is not replacing \ALLOW.PDF\ with the result. Anyone know where this is coming from? Does not seem to be in DMSYSDEFN GC.CONTROL Not from PD.R 27,11 Not from RD 37,3 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
Re: [U2] udt dir file max key length
Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. 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
Re: [U2] udt dir file max key length
Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 22 July 2011 13:55 To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 is pretty small tho ... -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 22 July 2011 11:22 To: 'U2 Users List' Subject: RE: [U2] udt dir file max key length These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 09:51 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. 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 - No virus found in this message
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
Absolutely. SELECT on a SELECT will prune the list if there is an active select and matching criteria. What should NOT happen is zero records on the second SELECT if you know the record is present - irrelevant of syntax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 07 July 2011 17:24 To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)- BPTEST CMD = \SELECT SOMEFILE WITH INVNO = 1234567\ ; CMD-1 = \SELECT SOMEFILE 3 71*1\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill - Original Message - *From:* mbr...@epicor.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/7/2011 9:02 AM *Subject:* Re: [U2] Found something interesting.Bug or No Bugthat ismy question? Sound like a bug to me. UniData is fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 07 July 2011 16:59 To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? We are running Information flavor.. Could be. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson Sent: Thursday, July 07, 2011 11:46 AM To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? Prime information also returned a hit anytime the following syntax was used I'm guessing UV tried to emulate prime whenever possible SELECT filename recordid perhaps a different flavor would yield different results Rich Dianne Ackerman wrote: Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== tqU8Szsdb6q+D60dYsLMkVk+N89MWS9AodmYIqzE2R4VA== 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. 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] Infoflo INV.INDEX
All files ending in INDEX are updated via the SB dictionary function /FD (filename) F10, XREF and Define. Initially, the index file is created and built here, thereafter the operating system maintains it as long as the SB screen has the Write Flag set. (If not, then it needs to be updated via a manual call to SB.UPDATE.BTREE as per IIWRITE) In your example, this maintains DICT INV $CROSS.REF i.e. if a record is created/changed/deleted, the matching index (if affected) is created/changed/deleted also. 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