Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Malaysia
    Posts
    17

    Post Unanswered: stored procedure

    Server: Msg:50001
    Data Was Not saved.
    --------------------
    P.L.N.Prasad varma

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    You dont have to create a new thread everytime ... you can simply click on the reply button
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Re: stored procedure

    Originally posted by pln_verma
    Server: Msg:50001
    Data Was Not saved.

    The message is a user defined error message generated by the raiseerror statement in your sproc ....

    remove the error handling part in your test env. and you should be able to debug the sproc
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Mar 2004
    Location
    Malaysia
    Posts
    17

    Re: stored procedure

    hai enigma,

    this is the error i am getting after i comment the user defined error ...

    The 'PRODUCTS_Update' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.




    Originally posted by Enigma
    The message is a user defined error message generated by the raiseerror statement in your sproc ....

    remove the error handling part in your test env. and you should be able to debug the sproc
    --------------------
    P.L.N.Prasad varma

Posting Permissions

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