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

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

Advertisements

#GPTechConf Update to Controlling Mouse Cursor from Dexterity Tip

At last month’s Microsoft Dynamics GP Technical Conference 2017 in Fargo, North Dakota, USA, Mariano and I presented the session “Yet Another 25 Development Tricks and Hacks in 50 Minutes” with tips 51 to 75.

During this session, we presented a tip on how to control the mouse cursor from Dexterity. When developer, Mark Fuglie tried to use the tip, it did not work for him.

#GPUGSummit Developers at GPUG Summit

Hey 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. 🙂

#Dexterity Development Environments Series

This is the index article for my series about setting up and working with your Dexterity Development Environments.

Disclaimer: This is the Musgravion principles of development machine setup. It is not the only method but it has worked for me for many years and has been fine tuned during my career. Feel free to use it if it works for you.

#Dexterity Development Environments – Part 7: Single Click Distribution

This is the seventh article in my series about setting up and working with your Dexterity Development Environments.

If you have not read the previous articles, please do so first using the links below:

• #Dexterity Development Environments – Part 1: Installation
• #Dexterity Development Environments – Part 2: Setting up Projects
• #Dexterity Development Environments – Part 3: Single Code Base
• #Dexterity Development Environments – Part 4: Creating Chunk Files
• #Dexterity Development Environments – Part 5: Creating Dictionary Assemblies
• #Dexterity Development Environments – Part 6: Automating Distribution

#Dexterity Development Environments – Part 6: Automating Distribution

This is the sixth article in my series about setting up and working with your Dexterity Development Environments.

If you have not read the previous articles, please do so first using the links below:

• #Dexterity Development Environments – Part 1: Installation
• #Dexterity Development Environments – Part 2: Setting up Projects
• #Dexterity Development Environments – Part 3: Single Code Base
• #Dexterity Development Environments – Part 4: Creating Chunk Files
• #Dexterity Development Environments – Part 5: Creating Dictionary Assemblies

#Dexterity Development Environments – Part 5: Creating Dictionary Assemblies

This is the fifth article in my series about setting up and working with your Dexterity Development Environments.

If you have not read the previous articles, please do so first using the links below:

• #Dexterity Development Environments – Part 1: Installation
• #Dexterity Development Environments – Part 2: Setting up Projects
• #Dexterity Development Environments – Part 3: Single Code Base
• #Dexterity Development Environments – Part 4: Creating Chunk Files