How to determine which Great Plains product is currently being run through Dexterity sanScript code

Article ID: 878415
Expand all | Collapse all

TechKnowledge Content

SUMMARY

This article contains a Dexterity code sample that determines which Great Plains product is currently running.

MORE INFORMATION

1. Examine the "SQL Server" of globals system variable. This integer value indicates which product is currently being used. The following table lists the constants that correspond to the active product:

Version 6.0 and 7.0

Value ConstantDescription

0 DYNAMICS Dynamics or Great Plains Select
5 SMALL BUSINESS MANAGER Small Business Manager
10 DYNAMICSSQL Dynamics for SQL Server (not used after Great Plains name change)
100 EENTERPRISESQL eEnterprise or Great Plains Edition

Version 7.5

0 DYNAMICS Great Plains Standard ISAM
5 SMALL BUSINESS MANAGER Small Business Manager
100 EENTERPRISESQL Great Plains Professional on MSSQL
100 EENTERPRISESQL Great Plains Standard on MSDE or SBS

2. On Great Plains version 7.0 and later, IsModuleRegistered(SM_CS) of form syRegKeyObj can be used to verify Great Plains Professional vs. Great Plains Standard because the "SQL Server" of globals value is the same for both of these products.

Version 7.0 and 7.5n

Value Description
FALSE Small Business Manager
FALSE Great Plains Standard
TRUE Great Plains Professional

Shown below is an example of how this can be referenced in your sanScript code:

if 'SQL Server' of globals > 0 then 
case 'SQL Server' of globals 
in [5] 
{Small Business Manager} 
in [10] 
{Dynamics on SQL Server 6.0, not used on 7.0 or 7.5} 
in [100] 
{Great Plains Professional or Great Plains Standard} 
 if IsModuleRegistered(SM_CS) of form syRegKeyObj then
{Great Plains Professional on MSSQL}
else
{Great Plains Standard on MSDE or on Small Business Server}
end if;
end case; 
else 
{Great Plains Standard ISAM(P.SQL/Btrieve or Faircom ctree} 
end if;
This article was TechKnowledge Document ID: 34505

Properties

Article ID: 878415 - Last Review: July 25, 2011 - Revision: 3.0
Keywords: 
kbmbsmigrate KB878415

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com