Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Location
    Paris, France
    Posts
    43

    Unanswered: How can i get the error text ?!

    hi everyone
    i would like to get the formatted text of an error IN the procedure where the error occurs...

    we can check the number of the error, with the global variable @@error, throught which i can handle the non formatted text by finding it in sysmessages...
    but how to get the final text, which is received by the client.

    ex : error 530
    what i can get : " Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails."

    what i want : " Attempt to insert NULL value into column [myColumn] in work table (table id [MyTable]); column does not allow NULLS. UPDATE fails."

    do you know if this is possible ?
    thanx,
    erwan

  2. #2
    Join Date
    Nov 2004
    Posts
    1
    Maybe u can get the details in the error log!

  3. #3
    Join Date
    Jun 2004
    Location
    Paris, France
    Posts
    43
    no the errorLog doesn't contain all the errors, and specially not the errors i want to get (problems with duplicate keys, losts of connection, ...).
    and i would have liked to get the error IN the stocked procedure, to be able to insert it in a table before leaving it.

    but the more i think about it, the more my hopes flee away...

    but thank your for your post darking

Posting Permissions

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