Store Procedure Help !!!

[Long]

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?

[Ecniv]

Because the Tqty is not being set anywhere...

Don't you have to pass variables as parameters for Sql Server?


Vince

[Ecniv]

Because the Tqty is not being set anywhere...

Don't you have to pass variables as parameters for Sql Server?


Vince

[Long]

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.

[Mongo]

http://www.vbforums.com/showthread.p...ht=stored+proc