Member Avatar for john.gale.92102

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
  • 110 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by BitBlt
Member Avatar for BitBlt

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.