Printable View
Dear
I create a store procedure such as
CREATE PROCEDURE test @qty1 as float output
as
select @qty1 = sum(qty) from TestTable where TestNo = 'C01'
Visual Basic coding:
Private Sub Command1_Click()
dim Tqty as Double
Tqty=0
Myconn.Execute "Exec Test " & Tqty
Msgbox "Quantity = " & Tqty
End Sub
when i click command1 the result is 0.
Someone can tell me what wrong with my coding?
Because the Tqty is not being set anywhere...
Don't you have to pass variables as parameters for Sql Server?
Vince
Because the Tqty is not being set anywhere...
Don't you have to pass variables as parameters for Sql Server?
Vince
Dear hlynurj
Can you give me a sample of coding how to use Store Procedure?
I use SQL Server 2000 and Visual Basic 6.
And to open connection i use ADO.