@@FETCH_STATUS variable

[Larry Hunter]

Hi -

I have question concerning the global variable @@FETCH_STATUS. From what
I have been reading it is a global variable that will continue to exist for
the life of a program's connection to the databae. Is that right?

My question is this:

The variable is used to determine if there are any rows of data in a cursor.
If the variable is global to the Server and two cursors (A and then B) are
openned ... which cursor information will the @@FETCH_STATUS variable be
referencing?

Larry

[Sergey]

The variable is global to the connection.
It's undefined until the first cursor is opened, after that it always shows
the status of the last fetch.

--
Sergey Kats
http://codebump.net

"Larry Hunter" <Hunterlmc@gateway.net> wrote in message
news:3ab27ec4$1@news.devx.com...
>
>
>
> Hi -
>
> I have question concerning the global variable @@FETCH_STATUS. From what
> I have been reading it is a global variable that will continue to exist
for
> the life of a program's connection to the databae. Is that right?
>
> My question is this:
>
> The variable is used to determine if there are any rows of data in a
cursor.
> If the variable is global to the Server and two cursors (A and then B)
are
> openned ... which cursor information will the @@FETCH_STATUS variable be
> referencing?
>
> Larry
>
>