Forum Discussion

tpoirier's avatar
tpoirier
Contributor
12 years ago

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
    12 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
12 years ago
It looks like the execution is happening at the end of the script. Try changing the last 3 lines to:




  SProc.ExecProc(); 


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


  Log.Message(test);




Change:


SProc.Parameters.CreateParameter("OnHand", adInteger, adParamReturnValue, 6, null);



and instead use something more like:




SProc.Parameters.AddParameter(); 


SProc.Parameters.Items(6).name = "OnHand";


SProc.Parameters.Items(6).DataType = adInteger; 


SProc.Parameters.Items(6).Direction = pdParamReturnValue; 


SProc.Parameters.Items(6).Value = null;