@@FETCH_STATUS variable


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: @@FETCH_STATUS variable

  1. #1
    Larry Hunter Guest

    @@FETCH_STATUS variable




    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



  2. #2
    Sergey Guest

    Re: @@FETCH_STATUS variable

    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
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center