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?