cursor

[Geetha]

In sql 6.5 I have a nested cursor; Is there a way I can find if the cursor
is already open? What is the syntax for that?

Thanks in advance!

[DaveSatz]

AFAIK there is no way to do this in 6.5
--

HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
-----------------------------------------------------------------

"Geetha" <gelangov@hotmail.com> wrote in message
news:3c066999$1@147.208.176.211...
>
> In sql 6.5 I have a nested cursor; Is there a way I can find if the cursor
> is already open? What is the syntax for that?
>
> Thanks in advance!