Re: [U2] I need a favor
Slick... j On 7/26/07, Charles Barouch [EMAIL PROTECTED] wrote: All, I just put up a new (free) tool on my site. It takes very little time to use and I'd appreciate it if some of you would beat on it and let me know what you think. http://www.keyally.com/fasterskel/Main.php5 -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [jBASE] SELECT operator precedence
Marco You might want to send this to the JBASE group - not the U2 group! They are completely different products. You can find the jBase group on Google Groups: http://groups.google.com/group/jBASE Email: [EMAIL PROTECTED] Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 27 July 2007 11:49 To: u2-users@listserver.u2ug.org Subject: [U2] [jBASE] SELECT operator precedence I expected the following three SELECT statements to be equivalent but they dont seem to be: CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY EQ 1000 OR GE 1002 AND LE 173218 Records selected CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE OR EQ 1000 102160 Records selected CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY (GE 1002 AND LE ) OR EQ 1000 173218 Records selected The second select seems to be ignoring the OR EQ 1000 as it is returning the same number of records with: CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE 102160 Records selected I expect the brackets around (GE 1002 AND LE ) to be superfluous (only required to make the syntax clearer) but they seem to be having an impact on the number of records selected. Can someone please clarify. Regards, Marco. ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOledb error out of memory
I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error out of memory I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider IBM.UniOLEDB for linked server The provider ran out of memory Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] What Is the SCRATCH Folder ?
look at your smb.conf (located whereever you installed samba to on the HP system) if not sure do find / -name smb.conf -print this should find it for you, once you find it vi/cat/more the file (BUT DO NOT CHANGE ANYTHING UNLESS YOU KNOW WHAT YOU ARE CHANGING) my guess is that you will find a share called scratch that is being used for logging or such it should look something similiar to: *[scratchdisk]* * comment = Scratchdisk* * path = /scratch* * read only = no * * public = yes* if you wish email me your smb.conf file and I can tell you whats going on dougc Brutzman, Bill wrote: On our HP-Ux UniVerse system, I am using Samba to copy files to a WinXP machine via Windows Explorer. It works ok except that it pops up a confirm dialog box asking... do I want to overwrite a file in the SCRATCH folder. The SCRATCH folder has perhaps 100 files that are named things like bruce17 bruce18 tom14 ... etc Answers would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- When you are SURE that everything in your program is correct AND your program STILL DOES NOT work, one thing you can be sure of is that something you are sure of is wrong - unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [jBASE] SELECT operator precedence
I expected the following three SELECT statements to be equivalent but they dont seem to be: CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY EQ 1000 OR GE 1002 AND LE 173218 Records selected CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE OR EQ 1000 102160 Records selected CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY (GE 1002 AND LE ) OR EQ 1000 173218 Records selected The second select seems to be ignoring the OR EQ 1000 as it is returning the same number of records with: CLEARSELECT [528] List '0' cleared. jsh rbk ~ --SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE 102160 Records selected I expect the brackets around (GE 1002 AND LE ) to be superfluous (only required to make the syntax clearer) but they seem to be having an impact on the number of records selected. Can someone please clarify. Regards, Marco. ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOledb error out of memory
Have you had any success playing with the '-g' startup parameter? Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error out of memory I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error out of memory I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider IBM.UniOLEDB for linked server The provider ran out of memory Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOledb error out of memory
No I haven't. But without the -g setting, it should reserve 256 megs and I can't imagine that the oledb driver needs more then this to run. If you happen to have a system that isn't in production to play with the settings, then this may be something to try. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Friday, July 27, 2007 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error out of memory Have you had any success playing with the '-g' startup parameter? Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error out of memory I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error out of memory I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider IBM.UniOLEDB for linked server The provider ran out of memory Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I need a favor
I like it. Works well. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Thursday, July 26, 2007 11:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] I need a favor All, I just put up a new (free) tool on my site. It takes very little time to use and I'd appreciate it if some of you would beat on it and let me know what you think. http://www.keyally.com/fasterskel/Main.php5 -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I need a favor
I agree, it works well and I like the format of the code it generates. Good job Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cordes, Tom (contractor) Sent: Friday, July 27, 2007 9:42 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] I need a favor I like it. Works well. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Thursday, July 26, 2007 11:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] I need a favor All, I just put up a new (free) tool on my site. It takes very little time to use and I'd appreciate it if some of you would beat on it and let me know what you think. http://www.keyally.com/fasterskel/Main.php5 -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I need a favor
Very Nice. When I write one-time utilities to fix an issue there's always bits of code I reuse from past programs. Things like an escape while processing in the main loop. Something like the following... 0058 * Provide an Escape 0059 IF SYSTEM(14) THEN 0060 INPUT ANS,1 0061 IF ANS=CHAR(27) THEN 0062 CALL SB.DISP(4,'UTLD9000.2') ;!Exit? Yes, No 0063 IF RTN.FLAG = 'X' THEN CLEARSELECT; GO 999 0064 END 0065 END I could see you're code generator being very useful if it had selectable options to include bits of code for different purposes. Regards, Eric Y. Neu Sr. Programmer Analyst Zetron, Inc. eneu at zetron dot com 425.820.6363 x271 www.zetron.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Thursday, July 26, 2007 8:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] I need a favor snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] I need a favor
Are you at the point of taking suggestions (not for the purpose of tooting the collective 'my horn'?) about making the dropped code a little more robust. If so, here's a couple of mine: add 'ON ERRORs' on the WRITEs if you havent done so... provide for opens of DICTs or maybe just OPEN ,FILE NAME TO FILE.NAME.FILE On 7/27/07, john reid [EMAIL PROTECTED] wrote: Slick... j On 7/26/07, Charles Barouch [EMAIL PROTECTED] wrote: All, I just put up a new (free) tool on my site. It takes very little time to use and I'd appreciate it if some of you would beat on it and let me know what you think. http://www.keyally.com/fasterskel/Main.php5 -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Another gripe about IBM not letting end users access the articles in the knowledge base - Final Result
WHOOPS Saw the superseding post - hopefully it'll get sorted - no, it shouldn't be this difficult and I don't know why you hit a glitch. It *should* be pretty straight-forward... Sorry you had a problem. Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Another gripe about IBM not letting end users access the articles in the knowledge base
Brenda There have been a few postings about this in the group: Basically your support/software provider has to submit a form to U2 Business Connect (U2BC) authorising access for your Company and named individuals. There is one form for OEM / ISV partner end users and one for Distributor end users. The form should be available to the partner from U2BC on request by the partner. Tech Support are not a part of this process though they MAY (emphasis MAY) have the current forms they could forward to the ISV/Distributor if asked. Authorisation is a pure U2BC procedure - sorry IBM Tech Support can't help here. So get in touch with your VAR and all being well U2BC will be able to sort it out for you. Hope it helps, Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: 25 July 2007 18:57 To: u2-users@listserver.u2ug.org Subject: [U2] Another gripe about IBM not letting end users access the articles in the knowledge base We have a great VAR, we seldom need them but when we do they come through with flying colors but even they can not get IBM to get us an ID to access this. I am posting the response I've gotten from our VAR on this issue. They have tried to get us access to the locked articles in the knowledge base with this response from IBM. have emailed IBM U2 support on this several times, they have never been able to tell me how to setup an additional IBM ID for a customer. Throws the lack of support right back to IBM and points out the failure of IBM to address their paying customers and VARs needs. This is a problem that needs to be address to facilitate growth in the U2 market. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2] : Cleaner Case Statement
I agree with Martin. The CASE statement is just a more human readable form of multiple IF statements. I switch TO case statements when the logic becomes a little convoluded and I only want one result. That, in essense is the purpose of CASE, only one should fall true (or none if you omit the bailout CASE 1) I've seen CASE X=1 ; GOSUB 10 followed later in the same block with CASE X#1 ; GOSUB 20 so the construct may be a little hard to understand. Our is one of the more powerful forms of case. VB's tests only one variable (IIRC) where as MV tests combinations as well. My 1 cent. - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 12:37 PM Subject: Re: [U2] [u2] : Cleaner Case Statement Hi Bill, Unlike languages such as C, Basic does not allow multiple conditions in the way in which you are looking to do. In terms of run time performance or program size, if it really is just a GOSUB, there whould be little disadvantage in writing the more verbose form of your first example. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Cleaner Case Statement
I think that CASE 1;Null is an old technique. If the prior conditions don't prevail, then don't bother. Otherwise every IF statement with a THEN would have ELSE NULL. BTW, using IF X = 1 ELSE GOSUB 100 is also very hard to read. Sure it compiles but source code should be readable for the programmers who have to visually interpet these things. EVERY IF should have an THEN as it's predominately a positive test instead of a negative test. Then use IF X # 1 THEN GOSUB 100. - Original Message - From: Allen Egerton [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 12:48 PM Subject: [U2] RE: Cleaner Case Statement Bill Brutzman asked: How can this structure be cleaned-up? snip begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' case Ans = '2' ; gosub Check.B end case so that the gosub Check.B command is not repeated. I have tried a few alternatives without a victory. Dunno if it's cleaner, but this is how I would code it... Begin Case Case Ans eq A gosub Check.A: Case ((Ans EQ B) OR (Ans EQ 2)) gosub Check.B: Case 1 * Do nothing End Case -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2] : Cleaner Case Statement
I think this should not be an exercise in using other forms of logic. The CASE construct is actually pretty self documenting. - Original Message - From: Manu Fernandes [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 12:44 PM Subject: Re: [U2] [u2] : Cleaner Case Statement Try this ON index('AB2',Ans,1) GOSUB Check.A, Check.B, Check.B Manu - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 5:48 PM Subject: [U2] [u2] : Cleaner Case Statement How can this structure be cleaned-up? begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' ; gosub Check.B case Ans = '2' ; gosub Check.B end case The following is more difficult to read. begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' or Ans = '2' ; gosub Check.B end case I would like something like... begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' case Ans = '2' ; gosub Check.B end case so that the gosub Check.B command is not repeated. I have tried a few alternatives without a victory. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2] : Cleaner Case Statement
I'll defend ON GOSUB here. I inherit a ton of prior code and can see the value in maint programs. If each field on the screen is labeled 10, 20, 30 and within that section there is a closing statement before the RETURN labeled 15 PRINT @(x,y):REC1:, then I've enjoyed have the NEW record cycler be FOR I=1 TO 5 ON I GOSUB 10,20,30,40,50 NEXT I and the print of the record be: FOR I=1 TO 5 ON I GOSUB 15,25,35,45,55 NEXT I At the Change Which Line, it's a repeat of the 10,20,30 sequence. I don't care for worded labels in ON GOSUB as it's hard to read with the commas and a lot of worded labels have periods which is also confusing. Likewise for called sub parameter strings. Put a space after each command and the variables come to life. My 1 cent - Original Message - From: Perry Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 2:52 PM Subject: RE: [U2] [u2] : Cleaner Case Statement Someone want to explain to me why ON GOSUB is bdd ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Wednesday, July 25, 2007 1:06 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [u2] : Cleaner Case Statement ON GOSUB..Bad. Bill, that is a bad coding practice - don't go there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: Wednesday, July 25, 2007 12:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] : Cleaner Case Statement Try this ON index('AB2',Ans,1) GOSUB Check.A, Check.B, Check.B Manu - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 5:48 PM Subject: [U2] [u2] : Cleaner Case Statement How can this structure be cleaned-up? begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' ; gosub Check.B case Ans = '2' ; gosub Check.B end case The following is more difficult to read. begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' or Ans = '2' ; gosub Check.B end case I would like something like... begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' case Ans = '2' ; gosub Check.B end case so that the gosub Check.B command is not repeated. I have tried a few alternatives without a victory. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] I need a favor
Did ever using CLIENT-MASTER.FILE ever compile. I just tried D3 and it didn't work. I don't recall it ever working. That was the golden rule, no dashes, asterisks, slashes or plus signs in variable names as they are operators. My 1 cent - Original Message - From: Charlie Rubeor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, July 26, 2007 2:29 PM Subject: RE: [U2] I need a favor [EMAIL PROTECTED] wrote on 07/26/2007 01:16:44 PM: I got stuck with file names like CLIENT-MASTER, CLIENT-CRED-FILE, etc. You should convert dashes in file names to periods or underscores in the variable names. Otherwise, you get: OPEN 'CLIENT-MASTER' TO CLIENT-MASTER.FILE ... READ CLIENT-MASTER.REC FROM CLIENT-MASTER.FILE, CLIENT-MASTER.ID ... UV compiler doesn't like variables with dashes. It's not just Universe. Not many compilers will like variables with dashes. With CLIENT-MASTER.FILE, the compiler would think that you wanted to subtract MASTER.FILE from CLIENT. For example, try this (if it even compiles, that is): CLIENT = 3 MASTER.FILE = 1 TEMP = CLIENT-MASTER.FILE PRINT TEMP It should print out 2 -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/