fetch_status preventing nested loops

• Buzz_1977

  SSC Enthusiast

  Points: 122

  More actions

  January 13, 2003 at 3:47 pm

  #79981

  i am trying to run a loop statement within another loop statement and the 2 loops are reading similar values from the same table. Because the inner loop is achieving a fetch_status of 0 the other loop is no longer looping. Is there a way of setting the fetch_status or handling nested loops to read from the table another way?

  your help would be greatly appreciated.

• philcart

  SSC-Forever

  Points: 47796

  More actions

  January 13, 2003 at 4:02 pm

  #446235

  Firstly, pasting a bit of your code would help with providing a solution.

  Secondly, try assigning the value of @@FETCH_STATUS to a seperate variable for each of the loops.

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface

• Scorpion_66

  SSCertifiable

  Points: 7891

  More actions

  January 13, 2003 at 10:57 pm

  #446257

  That will do it....