read http://www.developerfusion.com/show/91/2/

>Hi,
>
>I have a stored procedure that has an I want to return a value.
>
>Trimmed down sproc.
>
>CREATE PROCEDURE TEST
>
>@Val1 as varchar(50),
>@RetVal as varchar(50) OUTPUT
>
>AS
>
>GO
>
>I want to be able to use VB to return @RetVal.
>
>Not entirely sure how to do this with the Dataenvironment.
>I have tried this.
>
>de.dbo_Test Param1
>
>I get an error when I try this though.
>Any ideas?
>
>
>Thanks a bunch,
>
>Alvin