Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Adding AutoComplete Items with Dexterity
This is a quick and easy way to add items to the AutoComplete list for a field. I'm talking specifically about the autocomplete property on a field.
In this case, the customer didn't want to use the lookup window to select an existing item number, they wanted it to be in the autocomplete list. The problem is that in order for it to get into the autocomplete list, you have to select or type it at least one time. They wanted all of the items in the autocomplete list…
All about the Dexterity OLE Container
Over the years, the question of how to interact with the Microsoft Dynamics GP OLE Notes from outside the application has been raised many times.
I have responded to newsgroup posts with information that would hopefully…
Altering a Table From Dex
I got an interesting query from a guy on how to alter a table without using any SQL statements from within Dexterity.
As per the Dexterity Guide, a table cannot be altered from within Dexterity, that means only thru' Dex coding. If you’re converting tables stored in a SQL database, you must use pass-through SQL to perform the conversion.
Having said that, we can do it from Dexterity but calling a SQL Stored Procedure which will contain the necessary SQL Statements for that table alteration.
1. Make the necessary table changes on Dex Dictionary.
2. Write a SQL Stored Procedure like below (The SQL SP is written on SQL Server 2005 DB and uses SQL 2005 syntaxes):
/* Drop the SP if it exists */
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Custom_Tables_Alteration]') AND type in (N'P', N'PC'))
Auto-Complete for Dexterity Coding?!?!
Last year, David posted an article that shocked all Dexterity developers, he created a screenshot that shows dexterity codes inside Visual Studio .Net! Developers using dexterity was very much excited to work on that, but unfortunately it was April fool’s day and David couldn’t live without posting such an article!
BlackBox - The First Dexterity Game
Back in my past, when I ran Winthrop Dexterity Consultants, I wrote a game in Dexterity (approx 1999). This game is called BlackBox and is based on the original board game by Eric Solomon.
The concept of the game is to find the location of a number of atoms hidden in a 8 by 8 grid. Your only method of looking for the atoms is to "fire" beams into the grid from the edges of the grid…
Carefully Place Variables Assignment in Dex
This post is right after a coding correction done in one of my customizations.
There is a form which needs to be opened from both SOP Entry & SOP Inquiry. Based on the source, I had to either lock or unlock certain fields, exactly like how SOP Entry & SOP Inquiry windows work.
I created a GLOBAL field called "SOPSource" and created two Startup trigger scripts, namely SOP_Entry_Open_Addl and SOP_Inquiry_Open_Addl on SOP_Entry and SOP_Inquiry respectively. Inside each script, I wrote a piece of code like below: