Dexterity (programming language)

DexterityParadigm| Procedural

|

Developer| Great Plains Software, Microsoft
License| Proprietary software
Filename extensions| .mac, .dic

The Dexterity programming language was designed in the late 1980s for the implementation of platform independent graphical accounting software.[1] Dexterity itself is written in the C programming language.[2][3] It was used in the development of Great Plains accounting software.

Microsoft Dynamics GP, formerly Great Plains Dynamics and eEnterprise, is a Dexterity-written application. Microsoft's small business line, Microsoft Small Business Manager and Small Business Financials, were also written in Dexterity and use the same code base as Great Plains.

## Contents

* 1 History of Dexterity
* 2 Features
* 3 References
* 4 Further reading
* 5 External links

## History of Dexterity

Great Plains Dexterity is a proprietary programming language and technology, designed in the late 1980s[by whom?] with the goal to build a platform-independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (with the hope that C would provide platform independence). The user can install Dexterity from the Dynamics GP CD #2 and it allows custom pieces to be seamlessly integrated with the Dynamics GP interface.[citation needed]

## Features

Native Dexterity Cursors

Dexterity was designed as a platform-independent programming language. If you want code to be operable on all currently supported Dynamics GP databases, use Dexterity ranges and loops to manipulate the records
Dexterity with SQL Stored Procs

Currently, most Dynamics GP installations have been moved to MS SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
COM Object calls

Beginning with version 7.0, Dexterity supports COM objects - register them as libraries in Dexterity. Refer to the manual as to how to do this. This technique allows you to call such things as web services across the internet.
Dynamics GP Alternate Forms

These are modifications to existing forms – the ones found in DYNAMICS.DIC. The most popular customizations are made on the SOP Entry form. Alternate forms are not recommended by Microsoft as they make version upgrades more difficult. Customization usually has to be redone.
Some restrictions

Dynamics GP is actually an integration of multiple dictionaries: DYNAMICS.DIC, ADVSECUR.DIC, EXP1493.DIC, etc. In your Dexterity customization you can generally deal with only one dictionary - DYNAMICS.DIC. Integration with other dictionaries is supported but is difficult.

Dynamics GP macros can also be recorded in Dexterity. The ability to handle branches does not appear to exist in these macros.

## References

1. ↑ Dexterity overview
2. ↑ Microsoft Dynamics 365 For Dummies. John Wiley & Sons. 2018. ISBN 978-1119508885.
3. ↑ "DevNews". http://www.devnewz.com/devnewz-3-20040827GreatPlainsDexterityProgrammingOverviewforDevelopers.html.

## Further reading

* Developing Microsoft Dynamics GP Business Applications. Packt Publishing. 2012. ISBN 978-1849680264.
* Microsoft Dynamics 365 For Dummies. John Wiley & Sons. 2018. ISBN 978-1119508885.

## External links

* Dexterity Development System Releases for Microsoft Dynamics GP

* v
* t
* e

Microsoft Dynamics

Enterprise applications|

* Dynamics 365
* Business Central
* Dynamics AX
* Dynamics C5
* Dynamics CRM
* Dynamics GP
* Dynamics NAV
* Dynamics SL

Certification|

* Certified for Microsoft Dynamics

* v
* t
* e

Microsoft development tools

Development
environments|

| Visual Studio|

* Code
* Azure DevOps
* Express
* Team System Profiler
* Test Professional
* Tools for Applications
* Tools for Office

|

Others|

* .NET Compiler Platform
* App Studio
* Blend
* Expression Web
* GW-BASIC
* Microsoft Pascal
* MSBuild
* Robotics Developer Studio
* SharePoint Designer
* FrontPage
* PowerShell ISE
* QuickBASIC
* QBasic
* QuickC
* Small Basic
* WebMatrix
* Windows SDK
* CLR Profiler
* ILAsm
* Native Image Generator
* XAMLPad

Languages|

* Microsoft Basic
* Visual Basic
* Visual Basic .NET
* Visual C++
* C++/CX
* C++/CLI
* Managed C++
* C#
* Dafny
* F#
* F*
* J#
* J++
* Visual FoxPro
* IronPython
* IronRuby
* JScript
* PowerShell
* Q#
* Small Basic
* TypeScript
* VBA
* VBScript
* XAML

Major APIs and
frameworks
(see all)|

* Windows API
* Silverlight
* XNA
* DirectX
* Managed DirectX
* Xbox Development Kit
* Windows Installer

.NET Framework|

* ASP.NET
* Core
* AJAX
* Dynamic Data
* MVC
* Razor
* Web Forms
* ADO.NET
* Entity Framework
* CardSpace
* Communication Foundation
* Identity Foundation
* LINQ
* Presentation Foundation
* Workflow Foundation

Device drivers|

* WDK
* WDF
* KMDF
* UMDF
* Windows HLK
* WDM

Database|

| SQL Server|

* Express
* Compact
* Management Studio
* Business Intelligence Development Studio
* MSDE

|

SQL services|

* Analysis
* Reporting
* Integration
* Notification

Other|

* Visual FoxPro
* Microsoft Access
* Jet Engine
* Extensible Storage Engine

Source control|

* Visual SourceSafe
* Team Foundation Version Control

Delivery|

* Active Setup
* ClickOnce
* NuGet
* vcpkg
* Web Platform
* Windows Installer
* WiX
* Microsoft Store

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Dexterity (programming language). Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Dexterity_(programming_language)&oldid=325156"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template