Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : BrS3fd1cPqb/ei61YLNNNs

Making SL DH File easily using SQL Scripts

Community Member Profile Picture Community Member
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


This was originally posted here.

Comments

*This post is locked for comments