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