SQL Stored Procedures to get the GP Constant value from SQL Server

Many a times, we do many customizations in GP, using SQL stored procedures and triggers. During these customizations, we might need to use few (or) many of the constants defined in GP for the purpose of various manipulations.

Instead of hard-coding these constants, we can fetch the value from SQL directly as these constants are stored in a table called CONSTANTS in the DYNAMICS database.

Use these stored procedures to get a GP constant value from SQL stored procedure for the constants defined in Dynamics GP.

smGetConstantString – To get a constant string value
smGetConstantFloat – To get a constant float value
smGetConstantInt – To get a constant integer value

These should make our SQL scripts look a lot more generic instead of hardcoding any values, which are defined as constants in GP.

VN:F [1.9.13_1145]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.13_1145]
Rating: 0 (from 0 votes)
SQL Stored Procedures to get the GP Constant value from SQL Server, 10.0 out of 10 based on 1 rating

December 15, 2008 В· veeyeskay В· No Comments
Posted in: Customizations, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 372