Steve Goodhall
steve at goodhall.info
Fri Jun 26 12:50:45 CDT 2009
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }If you want to be strictly OOP, you could use this construct to skip code that you don't want to remove completely do exit do ' skip the rest ...unexecuted code exit do ' safeguard from eternal loop loop also, you don't really need to use goto in error code even though Access generates a bunch of it. I will follow up on that later Regards, Steve Goodhall, MSCS, PMP 248-505-5204 On Fri 26/06/09 12:58 PM , "Drew Wutka" DWUTKA at marlow.com sent: And that is the core issue Rocky. I personally have not used Goto, other then in ErrorHandling, in quite some time. The last time I can remember is something similar to what Max posted, where I had a section I was skipping in 'testing/development', and I used the goto to sort of 'mass comment' out a section. With OOP, it should be very rare that you ever even have a super long single procedure function. Objects should be coded to handle a vast majority of whatever your code is trying to do. Standard Modules should only be used when it doesn't make sense to create an object to handle a task. However, my main point in debating this particular issue is that you can't possibly know every possible coding project that has or will ever exist, so to deny a tool simply because of people misusing it is just stubborn! ;) Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [1] [accessd-bounces at databaseadvisors.com [2]] On Behalf Of Rocky Smolin Sent: Friday, June 26, 2009 8:42 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Learning .Net -- PHP Instead? If the steps are coded as subs or functions then you don't have to repeat the Step code - just call the sub or function. Making the original example pretty clear. Especially if the functions or subs are titled something description and/or a few comments are inserted into the code. (Comments??!! Gasp!) Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [3] [accessd-bounces at databaseadvisors.com [4]] On Behalf Of Gustav Brock Sent: Thursday, June 25, 2009 12:14 AM To: accessd at databaseadvisors.com [5] Subject: Re: [AccessD] Learning .Net -- PHP Instead? Hi Drew This is a splendid example to demonstrate why _not_ to use GoTo. You have to read you simple example several times to get an idea what is may do. But only an idea. The first variant is much easier if you rewrite it properly: Step 1 If Not SomeCondition Then Step 1 End if The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com [6] http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Links: ------ [1] mailto:accessd-bounces at databaseadvisors.com [2] mailto:accessd-bounces at databaseadvisors.com [3] mailto:accessd-bounces at databaseadvisors.com [4] mailto:accessd-bounces at databaseadvisors.com [5] mailto:accessd at databaseadvisors.com [6] mailto:AccessD at databaseadvisors.com