Microsoft Dynamics GP Developing for Dynamics GP
A blog dedicated to the Microsoft Dynamics GP Developer & Consultant community
 
Welcome to MSDN Blogs Sign in | Join | Help

Developing for Dynamics GP

by David Musgrave (Australia) and the Microsoft Dynamics GP Developer Support Team (USA)

News

  • Please use the Blog Feedback? - Contact Us link at the top of the page to email questions relating to the blog itself.

    If you wish to ask a technical question, please use the links below to ask on the Newsgroups. If you ask on the Newsgroups, others in the community can respond and the answers are available for everyone in the future.

    Please do not use comments on pages and posts to ask questions unrelated to the topic on that page or post.



    Dates of Interest:

    11-Jul-2008: Blog Created by David Musgrave.
    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.



    WorldMaps Statistics since
    24-Feb-2009:




    Click for WorldMaps Stumbler



    Translator Tool:




    Social Networking

    Follow David Musgrave and the blog on:

    David Musgrave on Twitter

    David Musgrave on LinkedIn


    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.

Contents

Favourite Posts

Blog Links

Newsgroups Links

Resources Links

How to access a Third Party Table Buffer on a Cross Dictionary Procedure Trigger

Dave DusekThis particular situation has come up in a number of support incidents and I also run into this myself on occasion.  The situation is that you have a cross dictionary procedure or function trigger on a script and one of the parameters is a third party table buffer. 

According to KB Article 861788 Secure Link, you can transfer third party table definitions into your own dictionary and then you have direct access to those table definitions.  However, that strategy does not work in the case of a table buffer parameter.  If you transferred the table definition into your own dictionary and then tried to access the table buffer in the trigger processing procedure, the table buffer would always be empty.  The issue is that your table has it's own buffer and is not using the buffer on the procedure/function.  The reason for this is because the resource id of the third party table in your dictionary doesn't match the resource id of the table in the third party dictionary. 

In this situation, instead of transferring the table definition, you need to change the table
buffer parameter to anonymous and then use the column function to access the data.  Now you
will be accessing the table buffer that is passed in the parameters list.

Example Dexterity Code - This is the trigger processing procedure on a cross dictionary procedure trigger.  This is the correct way to access a third party table buffer:

For more information on how to create a combined dictionary and working with Cross Dictionary Development see the following articles:

Cross Dictionary Dexterity Development

How to combine the Dynamics.dic core dictionary and an extracted dictionary by using Dexterity Utilities in Microsoft Dynamics GP (KB 930350) Secure Link

Dave Dusek
Dynamics GP Developer Support

Posted: Friday, May 15, 2009 9:00 AM by Dave Dusek [MSFT]

Comments

No Comments

Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker