Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: ROW_COUNT in SQL/Pl

    I'm attempting to get the number of rows updated by a SQL statement, however ROW_COUNT is always 0. I'm using GET DIAGNOSTICS to set my local variable to ROW_COUNT. Any ideas why ROW_COUNT is always 0?


    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    GET DIAGNOSTICS must immediately follow the statement for which you're collecting the diagnostics. Make sure there's nothing else in between, not even a SET statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •