Forum Discussion

blearyeye's avatar
blearyeye
Contributor
14 years ago

Using ParamByName with ADO.CreateAdoStoredProc()

I have a TC function that uses an SQL server stored procedure; see below. It bombs on the ParamByName line. I've tried the name with and without the @. When I omit the line, it complains (correctly) t...
aqAnt's avatar
aqAnt
SmartBear Alumni (Retired)
14 years ago
Hello Bill,




You need to create a parameter to work with. For example:





function Test_GetMachineConfiguration(instanceNumber) { 


  var qry = ADO.CreateADOStoredProc(); 


  qry.ConnectionString = ConnectionString.ConnectionString(); 


  qry.ProcedureName = "dbo.STUV_GetMachineConfiguration";


  qry.Parameters.CreateParameter("return_value", adInteger, adParamReturnValue, 0, null);


  qry.Parameters.CreateParameter("InstanceNumber", adInteger, adParamInput, 0, instanceNumber);        

  qry.ExecProc();                                                                             


  return qry.Parameters.ParamByName("return_value").Value;     


}







Please see the Call an SQL Stored Procedure article for more information.