Results 1 to 2 of 2
  1. #1
    byterbit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Oct 2010
    Location
    Noou Yauk
    Posts
    32

    Hesitation production psychological SQL Blues

    When writing SQL scripts to update my largest client’s system I find that, unlike my psychology with looping code , I hesitate to run my instructions. I double check myself, write test quires to verify recordsets, create test tables to run against and in general waste an incredible amount of time. Is this normal ? I’m not exactly a newbie with SQL (16 years ? more ?) , and my stuff works, when I run it. Is it that I test each bit of my VBA code as I write the loops and so trust it more ? Is it that I don’t want to lose my customer ?


    Is this a common condition ?

  2. #2
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    This is a psychological question. If you have 16 years or more experience of writing SQL queries, then you should have strong confidence on each query you write, however I prefer testing the SQL queries on local test copy of the database to avoid a BIG mess to the database...

    Regards,
    Khalid Afridi

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Production and Inventory Problem
    By jmorse in forum Access
    Replies: 2
    Last Post: 02-24-2011, 10:07 AM
  2. Production Tracking
    By old_chopper in forum Access
    Replies: 2
    Last Post: 10-11-2010, 12:12 PM
  3. Replies: 3
    Last Post: 06-23-2010, 07:33 AM
  4. Making report for tracking production
    By winniepoohbear38501 in forum Reports
    Replies: 1
    Last Post: 01-28-2010, 09:06 PM
  5. Production
    By teranet in forum Access
    Replies: 1
    Last Post: 06-07-2008, 06:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums