We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

tpoirier's avatar
tpoirier
Contributor
13 years ago
Solved

Calling a stored procedure

I am trying to call a stored procedure passing in several aruments and not having any success, with a trace I was able to find out that the parameter names were not being included when when the data i...
  • agabriel's avatar
    agabriel
    13 years ago
    For a dataset this might work:



    Instead of:




    var test = SProc.Parameters.ParamByName("OnHand").value;

    Log.Message(test);



    Try this:




    SProc.Open();


      SProc.First();


      while (! SProc.EOF)


      {


        Log.Message(SProc.FieldByName("OnHand").Value);


        SProc.Next();


      }


      SProc.Close();





tpoirier's avatar
tpoirier
Contributor
13 years ago
Thanks for the suggestions, I tried the null without quotes and got an error. Leaving it as an empty string will cause the proc to use the org value which will work for the moment. However getting the OnHand value is the issue now, it is not an output I realized rather it returns a dataset. How do I go about getting that back to a var to work with?



Thanks