Rethinking Your Processes
Don't Keep Doing What You're Doing Wrong
Issue: 10.5 (July/August 2012)
Author: Bob Keeney
Article Description: No description available.
Article Length (in bytes): 5,137
Starting Page Number: 64
RBD Number: 10509
Resource File(s): None
Related Link(s): None
Known Limitations: None
Excerpt of article text...
I've been doing Real Studio consulting for ten years and I can tell you that it gets really easy to get into a rut and do the same things over and over again. It's easy when you don't have to come up with new solutions. There's an old adage admonishing us to work smarter not harder, so every now and then it pays off to evaluate what you do the most of and see if you can find a better way.
Most of our consulting work involves database applications. If you've done much work with Real Studio database applications, they have a tendency to be the same chunks of code over and over and over again. It's fairly easy and there's not much mystery behind it.
A few years back I had one of those 'aha!' moments when I started asking questions like: Were we using the most efficient way of coding database applications? What drawbacks are there to the way we are currently coding database applications?
After looking at our own very serviceable code we came up with a number of drawbacks to the 'standard way' of coding Real Studio database applications. The first was that it relied too much on copying and pasting of field names. Even though we check for database errors (see my blog post [http://www.bkeeneybriefs.com/2012/06/database-programmers-do-yourself-a-favor/]) we often found typos in our recordset and DatabaseRecord insert code.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.