Re: Closing Cursors

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: 2000/06/07
Message-ID: <393E9A07.5E27D40@Unforgetable.com>#1/1

Praetorian wrote:
>
> Is it necessary to close a cursor in the code of a procedure, or does
> the cursor close when the procedure completes?
>
> I am calling a stored procedure from Visual Basic with ADO 2.5. I need
> the cursor open in order to retrieve the results set, but I don't want
> to leave the cursor open indefinitely on the server side.

The cursor will close when the procedure goes out of scope, but it is still a good coding practice to close it explicitly. Received on Wed Jun 07 2000 - 00:00:00 CDT