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();





agabriel's avatar
agabriel
Contributor
13 years ago
As for passing a null value, try:




  SProc.Parameters.AddParameter();


  SProc.Parameters.Items(2).name = "StoreList";


  SProc.Parameters.Items(2).value = null;



without quotations.