#SQLServer Working with Dexterity Dates and Times in Transact-SQL


David Meego - Click for blog homepageWhen Dexterity was first implemented on SQL Server for version 3.15, there was a number of decisions made on how to map the datatypes, fields and tables designed for ISAM platforms such as Ctree and Btrieve/Pervasive SQL to work on SQL Server.

One of the decisions was how to map the individual date and time control types to work with the datetime datatype in SQL Server.

Continue reading

Advertisements

#GPUGSummit Developers at GPUG Summit


David Meego - Click for blog homepageHey Developers… Are you attending the GPUG Summit 2017 conference in Nashville, Tennessee in October? If so, this article is to let you know about Microsoft Dynamics GP related Developer content at the conference.

I asked why there was not much content for developers at GPUG Summit and I was told that there are not many developers in attendance. I disagreed and requested a session for Developers, which Bob McAdam promptly organised … thanks Bob. 🙂

Continue reading

#Dexterity Development Environments – Part 1: Installation


David Meego - Click for blog homepageThis article has been a long time coming and is the first of a series of articles on how I set up my machine for developing Dexterity applications across multiple versions.

I promised I would detail how my system is set up a while back at the reImagine 2015 conference and had never got around to writing the article until now.

Continue reading

#FabrikamDay How to quickly update the sample data to 2027


David Meego - Click for blog homepageIn case you missed it, yesterday was Fabrikam Day for the Microsoft Dynamics GP community. This was the 12th April 2017, the date that the sample company’s, Fabrikam, data is based around.

For more information about Fabrikam Day and the sample company have a look at my article from yesterday:

Continue reading

Identifying Triggers registered against a Table


David Meego - Click for blog homepageLast week, I wrote about a situation which was causing issues with the Database Validation feature of GP Power Tools. Triggers on the ACTIVITY table that fired when records are deleted that attempt to clean up data in the company that the record is related to.

The problem is that if the current user does not have access to this company or company database does not exist or is not online, errors are generated and the code fails. This is discussed in my blog:

Continue reading

Delete or Remove Range Errors on ‘SY_Current_Activity’ table after GP 2015 R2


David Meego - Click for blog homepageMicrosoft Dynamics GP 2015 R2 added lots of new features and enhancements and fixed a number of bugs too. However, it also introduced a change that is now causing errors in some ISV’s (Independent Software Vendor) products.

I first came across this issue when preparing to release GP Power Tools build 22 and was testing the Database Validation feature on my Microsoft Dynamics GP 2016 install.

Continue reading

#GPPT Adding data from any SQL table to SOP Documents


David Meego - Click for blog homepageFollowing on from my recent article, #GPPT Adding Vendor Item Number to SOP Documents, I thought it would be worth showing how we can use GP Power Tools custom Report Writer functions with a SQL Query to obtain any data available from any table on the SQL Server.

To make this happen we are going to combine the Runtime Execute Setup custom RW function code with a SQL script created in SQL Execute Setup. Note that these techniques, which have been available since June 2009, are completely Web Client compatible which makes them even more valuable now.

Continue reading