VBA call Stored Procedure (1 Viewer)

T

Tupacmoche

Registered User.

Local time

Today, 02:13

Joined

Apr 28, 2008

Messages

291

• Aug 20, 2018

• #1

Hi VBA Masters,

I'm calling a stored procedure in VBA which runs for some time doing many things. Is there a return value that can be captured to know when the sproc is complete?

 

June7

AWF VIP

Local time

Yesterday, 22:13

Joined

Mar 9, 2014

Messages

5,466

• Aug 20, 2018

• #2

I would expect so, and what do you want to do with the value - present it in a message box?

And what do you mean by stored procedure - just a procedure in VBA module?

 

T

Tupacmoche

Registered User.

Local time

Today, 02:13

Joined

Apr 28, 2008

Messages

291

• Aug 20, 2018

• #3

By stored procedure, I mean ms sql stored procedure running in sql server 2008 R2. I would like to process the outcome in a msgbox.

 

June7

AWF VIP

Local time

Yesterday, 22:13

Joined

Mar 9, 2014

Messages

5,466

• Aug 20, 2018

• #4

I've never used them. Perhaps the stored procedure has to be modified. Apparently there is a return method. Bing search: https://stackoverflow.com/questions...-server-stored-procedure-vi/25528645#25528645

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 23:13

Joined

Aug 30, 2003

Messages

36,124

• Aug 20, 2018

• #5

I have the SP return a value with an output parameter and use an ADO command object to execute the SP and grab the return value. At a glance that's one of the methods discussed in the link June7 posted.