Best Practice – Page 7 – Winthrop Development Consultants Blog

Why won’t my Dexterity Application Dictionary update?

Jun 30, 2010 Tagged with Best Practice, Blogsphere, Dexterity 1 Comment

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A couple of weeks ago, I had another interesting situation raised by Sivakumar Venkataraman. In this scenario, we had a custom Dexterity dictionary installed on a customer’s system. This customisation contained a table definition for a temporary table. To support some additional functionality, the temporary table needed an extra index added. Installing the updated chunk on the customer’s system failed to add the new index to the table definition. Running the code generated errors about an invalid index.

Developing For Dynamics GP

Using RW_Token to parse Runtime build numbers

Jun 1, 2010 Tagged with Best Practice, Dexterity, RW Functions 2 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The tip for today is how a Report Writer function added into the core dictionary can be used to parse runtime version and build numbers.

Developing For Dynamics GP

Improving Performance Accessing Tables in Dexterity

Mar 14, 2010 Tagged with Advanced Topic, Best Practice, Dexterity 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Here are a couple of really cool tricks that can boost performance of your Dexterity code for almost no effort at all. The techniques discussed below can significantly speed up accessing table buffers in functions and procedures when looping through a range of records in a table.

Developing For Dynamics GP

Limitations of Dexterity Table Triggers

Feb 2, 2010 Tagged with Best Practice, Dexterity, Triggers 1 Comment

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

“Why doesn’t my Dexterity table trigger fire when the table is changed.”

I have heard this question asked a number of times and so I thought I would highlight some of the possible reasons for the trigger failing to fire. Some of the reasons can be resolved by coding, while other reasons are a limitation in the way Dexterity table triggers work and cannot be resolved from inside Dexterity.

Developing For Dynamics GP

What causes an “All call stacks are in use” error?

Jan 31, 2010 Tagged with Best Practice, Dexterity, Exception 2 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

As a Dexterity developer you might have come across the following error:

All call stacks are in use. Cannot start script.

Developing For Dynamics GP

Checklist for creating a new Dexterity Window

Nov 29, 2009 Tagged with Best Practice, Dexterity, Modifier 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, we go back to basics. It is always good to make sure that we have the foundations handled properly. When I teach the Dexterity, I always go through the standard checklist below for creating (or modifying) Dexterity windows.

Developing For Dynamics GP

Accessing a Table Buffer when it is not passed as a parameter

Nov 22, 2009 Tagged with Advanced Topic, Best Practice, Cross Dictionary, Dexterity, Triggers 1 Comment

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post is a follow up to the previous posts on the Three Trigger Technique. If you have not read the posts explaining this technique, please use the links below:

The idea of the three trigger technique is to use a trigger on an unrelated function or procedure call to get the timing you require for your code. The 1^st and 2^nd triggers are used to ensure that the 3^rd trigger is only used when it is called from your desired parent script.

Developing For Dynamics GP

What does Option Explicit do in VBA?

Aug 6, 2009 Tagged with Best Practice, VBA 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

My colleague asked me for assistance with a Visual Basic for Applications (VBA) case yesterday.

Developing For Dynamics GP

Dexterity Pragma Pre-compiler directives

Jul 14, 2009 Tagged with Best Practice, Dexterity No Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Most Dexterity developers would have seen the pragma(disable warning LiteralStringUsed) command used at some stage to avoid literal string warnings when hard coded strings are needed as part of a script. This can often be the case when building SQL where clauses or pass through SQL, sanScript or macro code.

Developing For Dynamics GP

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

May 15, 2009 Tagged with Best Practice, Dave Dusek, Dexterity, NDM 1 Comment

This is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

This 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.

Tag: Best Practice