Quick Tip: Dexterity Ranges and how to update Fields that are part of the Key

Last week, I had an interesting case where a Dexterity Developer was having trouble getting some code to update a range of records selected in a table. The code would only update the first record in the range.   The Scenario The developer was trying to move the contents of the SOP_Serial_Lot_WORK_HIST table for a line…

0

Quick Tip: Unusual behaviour when working with SQL Server from Dexterity

Today, I came across an issue where a feature in Microsoft Dynamics GP would work when the workstation had its regional settings set to United States, but would fail to produce any data when the workstation had its regional setting set to Australia, New Zealand, United Kingdom, etc. We have seen related issues where code…

1

Quick Tip: Where does that customisation come from?

I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what…

1

Quick Tip: Debugging Visual Studio Tools

Let’s jump right in. We debug our Visual Studio applications over and over; and attaching to the test environment is among the most important, and time-consuming skills we use. (How many times have I launched GP2010 when I was thinking of GP2013?) Of course we all simplify our testing by building the dll and pdb…


Quick Tip: VBA ADO Connection Run-time error ‘3709’

It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while. When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to…

2

Quick Tip: Using Third Party Tables to fill a Scrolling Window

My good friend, Mariano Gomez (The Dynamics GP Blogster) raised this issue recently. He wanted to use the method I discussed in my previous Quick Tip post: Quick Tip: Accessing Third Party Table Buffers using anonymous tables to gain access to the third party table so he could display it in a Scrolling Window on his form….

0

Quick Tip: Accessing Third Party Table Buffers using anonymous tables

I have been spending a lot of time recently working on consulting engagement in Malaysia. This project involves a large amount of custom Dexterity code, some of which involves accessing tables in other third party product’s dictionaries. In the past, I have covered Cross Dictionary Dexterity Development techniques and the usual method I recommended for…

6

Quick Tip: Creating a Splitter control between panes of a window with Dexterity

For many years Dexterity developers have wanted to be able to add a splitter control to windows with “panes” created with lists, treeviews or listviews. Using the window Object property Resizeable set to True-Per Field, developers have created windows which can be resized but the join between the panes has been fixed as either Stay…

3

Quick Tip: Getting Command Based Menus working in Dexterity

In the last couple of weeks, I have had a few cases where Dexterity command based menus for addon products no longer showed in Microsoft Dynamics GP 2010 after Service Pack 3 was installed. In each of the cases, a review of the menu creation procedures identified that the code was actually incorrect. Once the…

12

Quick Tip: Capturing the Save Event with Visual Studio Tools

I recently responded to a community post which was asking how to ensure that all save events from the Item Maintenance window were captured using Visual Studio Tools. The aim was to make sure that the additional fields added to the window with Modifier were saved when the item data in the window was saved. The developer had already…

2

Quick Tip: Copying larger amounts of data in SQL Server quickly

I recently posted the Quick Tip: Copying small amounts of data in SQL Server quickly. This quick tip used the clipboard to copy data between tables as an alternative to using DTS (Data Transformation Services), SSIS (SQL Server Integration Services) or Transact-SQL (T-SQL). In this post, I thought I would show a fairly simple way to…

2

Quick Tip: Copying small amounts of data in SQL Server quickly

Last week, I was working on a Microsoft Dynamics GP update case where we had to re-upgrade one company from the previous service pack to the current service pack. To allow Dynamics GP Utilities to re-upgrade one company there are 3 things we need to do. Restore the previous version of the Company database. Restore…

5

Quick Tip: Solving Dexterity Trigger Clashes

In a recent support case, I had the rare situation where Dexterity Triggers clashed.  Dexterity allows third party developers to create triggers against various events and scripts in a Dexterity application (like Microsoft Dynamics GP). There are times where more than one third party product registers a trigger against the same event or script. Most…

6

Quick Tip: Working with VBA, Extender and Sales Transaction Entry

I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server. The project involved…

1

Quick Tip: Passing Date and Time Variables to SQL Server

As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server, I wanted to discuss the related topic about passing of date and time variables. There are two main issues we see with passing Dates and Times and both can cause SQL Server to throw the following exception: /*  Date: 12/15/2011  Time:…

4

Quick Tip: Passing Variables to SQL Server

Wow, the week is almost over and I am yet to post something. This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through…

7

Quick Tip: Making sure Activity Tracking is enabled for all users

This Quick Tip comes to you courtesy of an idea from my friend, Robert Cavill. On a Microsoft Dynamics GP system where Activity Tracking is being used, it needs to be activated for each User ID/Company ID that you want it enabled for. In most cases, you would want the Activity Tracking enabled for all…

3