Max Wanadoo
max.wanadoo at gmail.com
Thu Jun 25 14:04:37 CDT 2009
>>In my opinion. For instance, I would never use a kitchen knife as a screw-driver. When all you have is a hammer, all screws look like nails... Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: 25 June 2009 19:51 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Learning .Net -- PHP Instead? Hi Drew: Actually, GOTO is needed in MS Access to gracefully recover from an error or mini-crash... like a RTI, Return Through Interrupt. That is why it is used to manage errors. When all else fails GOTO recover... That is why the 'On Error GOTO...' is placed at the top of the routine. If there was no GOTO to recover to, all the variables could be lost and the program would probably, fail displaying an unrecoverable error. It should be used in the case of emergency and not just as another structure control call. I have found that just because something can be used in a certain way does not mean it should be used in that way. In my opinion. For instance, I would never use a kitchen knife as a screw-driver... ;-) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, June 25, 2009 8:52 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Learning .Net -- PHP Instead? Ya know Max, it's ironic, that on a list dedicated to a product that many in the IT world sees as 'bad practice', we have die hard 'purists' that can't see the forest through the trees. Goto can be misused. Everything can be misused. The fact that Goto is used in Errorhandling is EXACTLY why it's NOT a bad tool. It's just a tool that should be used for what it's designed for. You probably shouldn't drive cross country on your donut spare tire. But that doesn't make it bad practice to keep that donut tire in your car, to use it when it's needed! Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Wednesday, June 24, 2009 4:53 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Learning .Net -- PHP Instead? Drew, could it have been done in a recursive fashion, better than the "spaghetti Code" Max Ps. I love this song....be my soldier boy....1962 top hits. Reminds me of me... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: 24 June 2009 22:47 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Learning .Net -- PHP Instead? Ummmm, no. What I am describing is a jump point. Not a loop. A loop does something over and over. A jump point is when something needs to be 'looped' but conditionally on many factors. 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 http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com