Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Environment and Stored Procedure Return Values
Message
From
30/01/2003 14:03:57
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Visual Basic
Category:
SQL Server
Title:
Data Environment and Stored Procedure Return Values
Miscellaneous
Thread ID:
00747306
Message ID:
00747306
Views:
42
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,
Reply
Map
View

Click here to load this message in the networking platform