0

hi

I am having a challenge with a Fetch statement being used in a stored procedure. I am declaring a cursor and fetching data into a set of variables. The variable types match the column declarations exactly. There is data in the table from which I am fetching. @@FETCH_STATUS is 0 before the fetch and -1 after. As anyone any ideas why?

The code I am using is:

  DECLARE EQlist CURSOR FOR
        SELECT <a bunch of columns>
        FROM <my table>

   OPEN EQlist
        FETCH NEXT FROM EQlist INTO  <properly configured variables.
2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by BitBlt
0

You probably won't get any help until you supply more specifics. You are not supplying nearly enough detail for us to evaluate your situation.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.