This is the first in a series of posts which are are designed to help Dexterity developers as well as VBA and Visual Studio Developers to understand how to work with passthrough Dexterity sanScript. The main focus of this series is to understand how to change the Dictionary Context that the code executes in.
When Dexterity code is executed it runs in the context of a specific dictionary. If the code needs to access resources, such as tables and forms, which exist in a particular dictionary, then the passthrough code needs to be executed in the context of that dictionary.
Dexterity has the execute()function which can be used to execute code stored in a string (255 character limit) or a text (32767 character limit) field. The function has an optional first parameter which can be used to specify the Dictionary or Product ID of the Dexterity dictionary to use as the context. You can obtain these ID values from the Dynamics.set launch file. Examples are 0 for Dynamics and 1493 for SmartList.
To explain the concepts, we will start simple and build up to more complex examples. The first script is just standard code which will display the Product ID and Name for the context that the code is executed in. If you use the Support Debugging Tool’s Runtime Execute window, you can change context and execute the code to see how it works.
The second example shows how the same code can be built into a text field and then executed in the context of a specified dictionary using the execute() function.
NOTE: Each level of nesting requires the double quotes to be doubled up. Add the carriage returns (ASCII value 13) is optional but makes the code more readable if it is displayed to the screen using a warning statement.
The third script is optional. It is being used to write a text file containing the same script as shown in the first example. This is in preparation for the final example. You could always use Notepad to write the code…. or write the code in Dexterity and cut & paste to Notepad.
The fourth and final example shows how Dexterity code can be used to read a text file and then execute the context of that text file in the context of the specified dictionary.
Note: The TextFile_Open() function requires the path to the text file to be provided in generic pathname format. You can use the Path_MakeGeneric() and Path_MakeNative() functions to swap between generic and native path formats. Generic pathnames are a format that works for Mac and PC and are a legacy from when Dexterity was supported on both platforms.
- Native Pathname C:\Program Files\Microsoft Dynamics\GP\Data
- Generic Pathname :C:Program Files/Microsoft Dynamics/GP/Data
The rule for generic pathnames is that they have the drive surrounded by colons, no root slash and use forward slash instead of backslash. If you look at the paths in the Dynamics.set launch file, you will see generic pathnames in use.
For more information working with multiple dictionaries, see Cross Dictionary Dexterity Development.
Stay tuned for the next post where we see how these concepts work from VBA (Link will be available on Wednesday).
// Copyright © Microsoft Corporation. All Rights Reserved.
// This code released under the terms of the
// Microsoft Public License (MS-PL, http://opensource.org/licenses/ms-pl.html.)