Posted by Erland Sommarskog on 09/30/50 11:52

Zvonko (zvonko_NOSPAM_@velkat.net) writes:
> Let's say that a user clicks a button that executes a stored procedure
> which computes some figures: how will my application know when the
> procedure is done, so it can get a result on screen.

All client API provides synchronous methods to issue a query or run a
stored procedure. With these methods you simply wait until the API call
returns.

Some API:s also provides asynchronous methods which permits the application
to other things in the mean while. You will have to check the documentation
for the client API to find out whether the query has completed.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]