I am doing an sql query on a database that has 4 columns. (using sql server)
column names:
Date [smalldatetime],Varnum [smallint],Value [float],TextValue [nvarchar](50).

so I make a stored procedure to run this query, here is the stored procedure:
Code:
CREATE PROCEDURE [dbo].[seek]
	(@Date 	[smalldatetime],
	 @VarNum 	[smallint],
	 @Value 	[float] OUTPUT,
	 @TextValue 	[nvarchar](50) OUTPUT
	)
 AS
SELECT @Value=Value, @TextValue=TextValue
FROM datatbl
WHERE Date=@Date and VarNum=@VarNum

RETURN
GO
now, I call this stored procedure in the sql query analyzer like this:
Code:
declare @value [float], @textvalue [nvarchar](50)
execute seek @varnum=1, @date='1/1/2001', @value=1, @textvalue=''
print @value
print @textvalue
but the values that I have print out of the variables (last 2 lines) are nothing.
Does anyone know how to get the output variables when calling a stored procedure? If not in sql, then how do I do it in VB?