DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
btamulis 3/7/2016 3:07:30 PM

VBA and SQL Stored Procedures

Okay -

 I need to modify some Manufacturing Tables using a Push Button on the MO Entry Screen.

 I know exactly what I need to do in SQL (I've written a SQL Stored Procedure that handles the updating and deleting part of the process).

My question is - Using Visual Basic Editor in GP - Can I fire off a SQL Stored Procedure? I would need to pass the MO Number as a parameter to the stored procedure.

 At this point I just need to confirm feasibility - anybody have an opinion?

 Thanks in advance........

 Bron

 

Version: GP 2015, GP 2013
Section: Dynamics GP, VBA