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


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3