Running Stored Procedures

[PaulHamill]

All

Can someone please tell me how you run a SQL 7 Stored Procedure via Visual Basic 6 using ADO code. I have read that running Stored Procedures will speed up the response of the query.

Many thanks

 

[JonesMone]

This is an uninformed reply, but without even looking it up, can't you set up a querydef object?

 

[CajunCenturion]

This issue has been address numerous times in this forum. To get a list of the pertinent threads, click on the Keyword Search tab, enter stored procedure in the keyword, I would also set the Use radio button to All Words, and the When radio button to Any Date.

The results from the search should provide you with everything you need. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Idiota]

An example will do it.

This is a sp with only one parameter (integer) but is easily extended.

  Dim lCmd As New ADODB.Command
  Dim lP1 As New ADODB.Parameter
    
  lCmd.CommandText = "sp_BorrarRecibosVenta"
  lCmd.CommandType = adCmdStoredProc
  
  lP1.Type = adInteger
  lP1.Direction = adParamInput
  lCmd.Parameters.Append lP1
  
  Set lCmd.ActiveConnection = miConexion ' mi global ADO connection
  lCmd(0) = nroReciboID   ' Here I actually assign the parameter value with a variable
  lCmd.Execute

Good luck

Daniel