sp: OUTPUT: can't get the value in vb

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

sp: OUTPUT: can't get the value in vb

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-02 : 19:06:43

Edi writes "Hi sql-team

you really do a good job, even on page 'stored procedures: returning data' and I think the page 'Make ADO Work Faster Using Output Parameters in Your Stored Procedures' contains all the answers to my questions concerning how to catch the return value in my vb project but calling this page all I get was 'host not found'.

Please help me by sending me an email with the contents or activating the page again!!!

Thanks for all your great sites and your special help in this case!!!

Greetings from munic!

Your Edi Weinberger

PS: two samples: Iwant to catch the result:
------------------------------------------------------
CREATE PROCEDURE spEdi_add_ret
@m1 int,
@m2 int
AS

declare @result int

set @result = @m1 +@m2
return @result

/*

-- Aufruf: query analyzer

declare @intReturn int

exec @intReturn = spEdi_add_ret 1,2
select @intReturn

*/
-------------------------------------------------------
CREATE PROCEDURE spEdi_add
@m1 int,
@m2 int,
@result int OUTPUT
AS

select @result = @m1 +@m2

/*
-- Aufruf: query analyzer

declare @a int
declare @result int

exec spEdi_add @m1=3,@m2=2,@result=@a OUTPUT

select @a

*/"

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-12-02 : 22:22:21

Some of the article links point to articles that are on other web sites. You'll notice that they have a small icon of a globe with an arrow pointing away.

Here's a link for searching articles: [url]http://www.sqlteam.com/SearchResults.asp?SearchTerms=Output+Parameters[/url]

You might also search the Forums (different search page). There have been several threads in the last few months on this topic as well.

-------------------
It's a SQL thing...

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2001-12-03 : 01:33:28

Actually I should have posted with this. Pinnacle Publishing always provides a free article when they publish their newsletters. Unfortunately the articles don't stay free. I had 13 links up to articles that used to be available but aren't any more. I took down the links.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources