Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)
Search Form
  • Advanced search options...
Options
Tags
News

Dates of Interest

11-Jul-2008: Blog Created by David Musgrave.
03-Oct-2008: Syndicated to the Dynamics Communities.
10-Oct-2008: First Post by Scott Stephenson.
04-Nov-2008: First Post by Dave Dusek.
11-Nov-2008: First Post by Beth Gardner.
28-Nov-2008: First Post by Chris Roehrich.
30-Dec-2008: First Post by Patrick Roth.
24-Feb-2009: First Post by Greg Willson.
22-Apr-2009: First Post by David Clauson.
04-May-2009: First Post by Ryan Wigestrand.
19-Jun-2009: First Post by Dawn Langlie.
03-Jul-2009: First Post by Emily Halvorson.
23-Sep-2009: Created Twitter account with blog feed.
20-Nov-2009: First Post by Alice Newsam.
21-Apr-2010: First Post by Allan Cahill.
19-May-2010: First Post by Marian Verzosa.
24-May-2010: Blog Migrated to new Platform.
28-May-2010: Created Facebook account with blog feed.
15-Aug-2011: First Post by Development team.
05-Sep-2011: Created http://aka.ms/Dev4DynGP and http://aka.ms/SDT Shortened URLs.

Social Networking & Syndication

Follow David Musgrave and the blog on:

Developing for Dynamics GP on Twitter

David Musgrave on LinkedIn

Developing for Dynamics GP on Facebook

This blog at Dynamics Communities

Shortened URLs

This Blog: http://aka.ms/Dev4DynGP
SDT Portal: http://aka.ms/SDT
Menus for VST: http://aka.ms/MVST

Disclaimer

This blog is provided "AS IS" with no warranties, and confers no rights.

The links in this blog may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.
WorldMaps
WorldMaps Statistics since 24-Feb-2009:



Click for WorldMaps Stumbler
Translator Tool
Links
Contents
Newsgroups & Forums Links
Blog Links
Resources Links
Favourite Posts
Archives
Archives

Support Debugging Tool Build 14 released

MSDN Blogs > Developing for Dynamics GP > Support Debugging Tool Build 14 released

Support Debugging Tool Build 14 released

Rate This
1 Dec 2010 4:00 PM
  • Comments 13

David Meego - Click for blog homepageIt 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.
     


Downloads

Support Debugging Tool for Microsoft Dynamics GP 9.0 Secure Link

Support Debugging Tool for Microsoft Dynamics GP 10.0 Secure Link

Support Debugging Tool for Microsoft Dynamics GP 2010 (v11.0) Secure Link

NOTE: The tool is posted on PartnerSource Secure Link and so can be downloaded by partners.  If you are a customer, you will need to obtain the tool through your partner. Any feedback or questions about the tool will be handled via the Microsoft Dynamics GP Community Forum.

 

Please check out the Support Debugging Tool Portal page, your one-stop-shop for all things relating to the Support Debugging Tool.

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

David

, , , ,
Comments
  • 1 Dec 2010 6:26 PM

    Post from Mariano Gomez, The Dynamics GP Blogster

    dynamicsgpblogster.blogspot.com/.../support-debugging-tool-for-microsoft.html

  • 2 Dec 2010 6:56 AM

    Post from Michael Johnson, The MBS Guru

    mbsguru.blogspot.com/.../support-debugging-tool-build-14.html

  • 2 Dec 2010 6:57 AM

    Post from Mohammad Daoud

    mohdaoud.blogspot.com/.../support-debugging-tool-build-14.html

  • 2 Dec 2010 6:57 AM

    Post from Vaidy Mohan and Dynamics GP - Learn & Discuss

    www.vaidy-dyngp.com/.../support-debugging-tool-sdt-build-14.html

  • 2 Dec 2010 3:05 PM

    Posting from Mark Polino at DynamicAccounting.net

    msdynamicsgp.blogspot.com/.../support-debugging-tool-build-14.html

  • Leslie
    3 Dec 2010 3:40 AM

    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

  • 5 Dec 2010 1:48 AM

    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

  • 5 Dec 2010 1:48 AM

    Posting from Leslie Vail, The Dynamics Confessor

    dynamicsconfessions.blogspot.com/.../support-debugging-toolnew-release.html

  • 6 Dec 2010 3:40 PM

    Posting from Jennifer Kuntz at Kuntz Consulting Blog

    www.kuntzconsulting.ca/.../the_support_debugging_tool_is_my_new_best_friend

  • 8 Dec 2010 4:06 PM

    Posting from Mark Polino at DynamicAccounting.net

    msdynamicsgp.blogspot.com/.../support-debugging-tool-is-kuntz.html

  • Tyler
    15 Jan 2011 11:19 AM

    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.

  • 16 Jan 2011 6:50 PM

    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

  • Phil
    15 Apr 2011 9:38 AM

    Great job at Convergence 2011.  Can't wait to use this tool.  I guess I missed the release of this the past couple of years.

Page 1 of 1 (13 items)
Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post