Browse by Tags
All Tags » Best Practice ( RSS)
-
|
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...
|
-
|
"Why doesn't my Dexterity table trigger fire when the table was 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...
|
-
|
As a Dexterity developer you might have come across the following error: All call stacks in use, can't start script. This post will describe what call stacks are (from a Dexterity perspective), how they are used and what causes this error to be generated...
|
-
|
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. This checklist is valid...
|
-
|
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: Using the Dexterity Three Trigger Technique Part 1 Using the Dexterity Three Trigger...
|
-
|
My colleague asked me for assistance with a Visual Basic for Applications (VBA) case yesterday. The VBA code was being used to customise a report and use ActiveX Data Objects (ADO) to read a value from the SQL Server data and display it on the report...
|
-
|
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...
|
-
|
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...
|
-
|
As a follow on from the post last week on capturing the logging in and logging out events in Microsoft Dynamics GP, I want to cover how to open a form after logging into Microsoft Dynamics GP. This could be a hidden form used by your code or a window...
|
-
|
A while back I did a post on running Visual Basic for Applications (VBA) scripts when logging into and out of Microsoft Dynamics GP. Recently, I was asked about the best method of capturing the same events from Dexterity. I have seen developers use triggers...
|
-
|
In the previous part of this post we discussed the theory of the Three Trigger Technique and the details of a problem that was solved using this technique. This post will cover the actual solution used and has the scripts used so you can see the techniques...
|
-
|
When working with Dexterity triggers, the hardest part of the process is working out where to place the triggers. There are times where it seems impossible to get the trigger you need in the correct location. This post explains the concept of what I call...
|
-
|
I recently responded on a Newsgroup posting where the developer was wanting to identify a table delete event from a particular form. However, the delete event was happening in a global script and did not use a form level table buffer on any form. This...
|
-
|
As a developer there are often times when I need to write and maintain code which works for multiple versions of Microsoft Dynamics GP. A great example of this is the Support Debugging Tool for Microsoft Dynamics GP . This tool has been written for versions...
|
|
|
|
|
|
|
|