Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unhappy Unanswered: storeProcedure does not return outpur

    i have a vb program which expects an output parameter from a store procedure.
    the store contains INSERTs and UPDATEs, and in the end has a SET command for the output and then RETURN. in which case the vb recieves EMPTY . if i delete all the UPDATEs and INSERTs from the store, then the vb recieves the output value intended.
    can anyone help me?

    p.s
    another store in the same program works fine but it does not have any commands but select.

    thanks
    shkunts

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Just try putting set nocount on at the start of the procedure

Posting Permissions

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