I have serveral SP's that are called from a vb app, I want to only call one SP and when it's complete call the other
SP's, passing it the parm(s) they need. How can I do this ????
If all of the procedures are going to be called every time the first on is run (ie. you don't intend to run a procedure by itself) you can have each procedure call the next one when it's through. At the end of each procedure, just have something like the following code calling whatever procedure you want to run next:
Warning: You want to be careful when doing this, you can easily have the procedures get caught in a loop. (first procedure calls the second procedure that calls the first procedure that calls the second procedure that calls the first procedure....)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.