Monday, 16 December 2013

Making SL DH File easily using SQL Scripts

DH file formation (for Solomon User tables) will always consume huge amount of time to complete the entire content for the specified tables. 

Using this procedure, user can get an entire DH file content quickly by just passing the table name as parameter.

Steps to form the DH file:

1) Download the following SQL file


2) Execute the SL_DH_File_Creation.SQL file under Solomon Application database through SQL Server Management studio.

3) Execute the DH File creation procedure in the following way under Solomon Application Database

DH File for new Screen development :
--////////////////////////////////////////////
--Execute  ProcedureName  'TableName'
--/////////////////--Example-/////////////////
  EXECUTE SL_DH_File_Creation 'xTable'
--////////////////////////////////////////////

DH File for Customization's:
--////////////////////////////////////////////
--Execute  ProcedureName  'TableName'
--/////////////////--Example-/////////////////
  EXECUTE SL_DH_File_Customization 'xTable'
--////////////////////////////////////////////


Hope this blog will be very useful for SL-Developers!!!

Microsoft Dynamics Community