Jim Lawrence
accessd at shaw.ca
Thu Jun 25 16:22:30 CDT 2009
Your off the subject Drew ;-) 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 2:14 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Learning .Net -- PHP Instead? Sigh...the irony.... And how many people would say that you should never use Access as a serious development tool? Yet how many people on this list have made good money doing that? To say you would never use a kitchen knife as a screwdriver is really just acknowledging that you have yet to find the screw that needed a kitchen knife to operate it! Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Thursday, June 25, 2009 1:51 PM 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... 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