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
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com