SBX - Search With Button

SBX - Forum Post Title

Reg : Import DB Scripts

Microsoft Dynamics SL Forum

Mohamed Ibrahim asked a question on 6 Jul 2018 4:37 AM
My Badges

Question Status

Verified

How to invoke new stored procedures created against Dynamics SL Database in Production Server

Reply
Erich Strelow responded on 11 Jul 2018 8:38 AM
My Badges
Verified Answer

Can you be more specific?

You mean invoke the sp from within SL or from an external tool?

Some recommendations:

  1. On adding objects to the database, always execute the "Synchronize All Ownership & Security". Locate the 9829000.exe, connect to your DB server and execute this step. Otherwise, you may get access problems on the sp from within SL.
  2. You can invoke a non-table sp from a VBA customization within SL using Call sql(c, "exec mysp " & IParm(myNumber) & "," & SParm(myText) ). No option for return parameters is available.
  3. A table sp may be queried from VBA using the sqlfetch function calls, but you must provide a record definition (the so called DH file) serr1 = sqlfetch1(c1, "mysp " + sparm(myText), bmysp, LenB(bmysp)).
  4. If invoking from an external tool (like Excel, Infopath, any BI thing), there are certain security tweaks involved.


 

Reply
Mohamed Ibrahim responded on 12 Jul 2018 2:44 AM
My Badges
Verified Answer

Thanks for your support.

I done some customization changes and also added some stored procedure's in SQL Dynamics SL Database.I Invoke customization from .cst file like that is it possible to invoke custom stored procedure's from Dynamics SL Screen.

Reply
Erich Strelow responded on 11 Jul 2018 8:38 AM
My Badges
Verified Answer

Can you be more specific?

You mean invoke the sp from within SL or from an external tool?

Some recommendations:

  1. On adding objects to the database, always execute the "Synchronize All Ownership & Security". Locate the 9829000.exe, connect to your DB server and execute this step. Otherwise, you may get access problems on the sp from within SL.
  2. You can invoke a non-table sp from a VBA customization within SL using Call sql(c, "exec mysp " & IParm(myNumber) & "," & SParm(myText) ). No option for return parameters is available.
  3. A table sp may be queried from VBA using the sqlfetch function calls, but you must provide a record definition (the so called DH file) serr1 = sqlfetch1(c1, "mysp " + sparm(myText), bmysp, LenB(bmysp)).
  4. If invoking from an external tool (like Excel, Infopath, any BI thing), there are certain security tweaks involved.


 

Reply
Mohamed Ibrahim responded on 12 Jul 2018 2:44 AM
My Badges
Verified Answer

Thanks for your support.

I done some customization changes and also added some stored procedure's in SQL Dynamics SL Database.I Invoke customization from .cst file like that is it possible to invoke custom stored procedure's from Dynamics SL Screen.

Reply

SBX - Two Col Forum

SBX - Migrated JS