February 14, 2002 at 12:41 pm
My experience with VB/SQL is cursory. Is there a way to return a periodic status indicator from a stored proc to the calling application? I'm on SQL7 & VB6. Thanks for any input!
February 14, 2002 at 2:06 pm
Not really. You could insert a value into some other table and query this periodically.
Steve Jones
February 14, 2002 at 2:12 pm
Thanks-am doing that currently... thought there might be a more sophisticated method. Thanks for response.
quote:
Not really. You could insert a value into some other table and query this periodically.Steve Jones
February 14, 2002 at 2:17 pm
You are welcome. Don't really know of a way to run a stored proc asynchronously. I think it won't return intermediate result sets.
HAve to test it though?
Steve Jones
February 14, 2002 at 2:43 pm
February 14, 2002 at 3:29 pm
...True - while the procedure is executing, the timer interval doesn't invoke... will keep looking - thanks again
February 14, 2002 at 4:07 pm
saw an article & a posting on doing this, but seemed more effort that i wanted to put in at the moment - but if i get desperate (i.e. the users start throwing things) ...
thanks for response. Shelley
December 8, 2002 at 8:08 pm
Communication with client apps is via the request/response model. There isn't any real API to get unsolicited input from SQL Server.
December 8, 2002 at 8:17 pm
Are you after async processing.
Fire a command and check periodically if finished. Done in dblib. While server runs monster sp the app was initializing the controls and then wait for sp to finish.
Should be able to do the same in ADO. Done asynch ADO IO with ASP with events.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply