CLR Stored proc debug problem

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  October 28, 2010 at 5:21 am

  #228453

  hi,

  I'm new to CLR Programming, here i'm trying to debug:

  '

  '

  '

  '

  Dim objReader As SqlDataReader = objCmd.ExecuteReader

  While (objReader.Read())

  Ackprocess(objReader(1).ToString())

  End While

  objReader is the sqlreader, objCmd sqlcommand

  the debug cursor is not processing to the while loop.

  thanks,

  🙂

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  October 28, 2010 at 10:29 pm

  #1243980

  hi i got the solution, there is a problem in the cmd query

  i put the try..catch then i find the error.

  🙂