Posted on by WinthropDC Developing For Dynamics GP

Support Debugging Tool Build 14 released

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

It has been a while since we had a new build of the Support Debugging Tool for Microsoft Dynamics GP. So we have decided to release Build 14.  This is primarily a maintenance release with bug fixes, minor enhancements and a couple of new features.  This build can be installed over the top of any existing installed build without needing to remove the old build first.

Please note that this is the final release for version 9.00.

Below is a summary of the changes made for releases 9.00.0014, 10.00.0014 and 11.00.0014, I have divided them into logical sections:

Fixes

  • Changes to Reject Script functionality in Advanced Debugging Mode to restore fields to their previous values.
  • Changes to Reject Script and Reject Record functionality so it can be controlled by using the OUT_Condition variable.
  • Fixed Non-logging triggers disabling Manual Logging Mode and Automatic Debugger Mode.
  • Fixed Security Information Show Resources Window showing Resource ID and Dictionary ID in incorrect columns.

Enhancements

  • Added Ctrl-R as Shortcut Accelerator Key for Raise All Windows (v10.0 or later).
  • Shift Company Color data storage from DUOS to coUserDefaults table, with automatic backwards compatibility.

Performance

  • Changes to minimise Suppport Debugging Tool scripts captured when turning on and off script logging.

Usability

  • Added support for Temporary tables into the Table Explorer window in the Resource Explorer.
  • Added support for Temporary tables into the Resource Information window.
  • Added text to Dex.ini Changes window shown at login to identify it as a Suppport Debugging Tool feature.
  • Added User Account Control (UAC) check when attempting to un-install Support Debugging Tool.

  • Added User Account Control (UAC) check when move products or deleting products in the launch file using Dictionary Control.

  • Added User Account Control (UAC) check when unchunking during installation.
  • Added User Account Control (UAC) state to the System Status report form ScreenShot.

Features

  • Added Table Keys information to Table Explorer window in the Resource Explorer.

  • Added Table Keys lookup window to Resource Explorer.

  • Added Display Keys button to Resource Information window when in Table and Field mode.

  • Added Keep Focus and Restore Value options to Reject Script functionality in Advanced Debugging Mode.

More Information

For more information, please see the GP Power Tools portal, which replaced the Support Debugging Tool Portal.

Please post your feedback on what you think of this build and what you would like to see in the future.

David

16-May-2013: Updated More Information and Downloads to link to Support Debugging Tool Portal page.

This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.

14 thoughts on “Support Debugging Tool Build 14 released”

  6. Hi David,
    As usual, another fabulous release! I spent a good time yesterday walking a client through the features of the tool. Eyes and smiles got bigger and bigger!
    OK, I have a wish. I would love to have a way to 'protect' a peice of script or SQL query such that a 'non-advanced' user could run it. Ideally I could use parameters in the query that the user could fill in and then execute. It's want, want, want from me :)!
    What do you think?
    Leslie

    Like

  7. Hi Leslie
    You could write this using the Runtime Execute window to ask the questions via system dialogs and then put in a script from SQL Execute, adjust the parameters and execute the script.
    The only think we don't have is the ability to prevent editing.
    David

    Like

  11. Hi David,
    I was excited to see that you added support for displaying Table Keys to the Resource Explorer included in this tool. I'm curious how you worked around the issue of Table_GetKeyInfo only working within the Core Dynamics Dictionary. I've been searching for a way around this same issue and haven't had much luck, any chance you can let us know how you did it?
    Thanks.

    Like

  12. Hi Tyler
    For GP 2010 onwards you can use the Table_GetKeyOption() function.
    For earlier builds, there is the getTableKeyAtPosition() of form XTableInformation; function.
    Below is an excerpt from the SDT's code:
    #if MBS_PROD_MAJ >= 11 then  l_duplicates = Table_GetKeyOption(IN_DictID, IN_Table_Name, IN_KeyID, KEY_OPTION_ALLOW_DUPLICATES);  l_primary = Table_GetKeyOption(IN_DictID, IN_Table_Name, IN_KeyID, KEY_OPTION_SQL_PRIMARY);  l_unique = Table_GetKeyOption(IN_DictID, IN_Table_Name, IN_KeyID, KEY_OPTION_SQL_UNIQUE);  l_clustered = Table_GetKeyOption(IN_DictID, IN_Table_Name, IN_KeyID, KEY_OPTION_SQL_CLUSTERED);#else  { if IN_DictID = DYNAMICS then    Table_GetKeyInfo(IN_ResID, IN_KeyID, l_duplicates, l_modifiable, l_compress, l_primary, l_index, l_unique, l_clustered);  end if;  }
      getTableKeyAtPosition (IN_Table_Name, IN_DictID, IN_KeyID, l_key_name, l_duplicates, l_modifiable, l_compress, l_primary, l_index, l_unique, l_clustered) of form XTableInformation;#end if
    David

    Like

  14. Pingback: Support Debugging Tool Portal | David Musgrave's Winthrop Development Consultants Blog

Please post feedback or comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.