Return Record Set - SQL Server Forums

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

Transact-SQL (2000)

Return Record Set

Author

Topic

nlbnalin
Starting Member

6 Posts

Posted - 2004-09-20 : 07:09:25

I want to return recodset from stored procedure and one parameter as well using VB6.

Eitehr record set or parameter can be returned. But both cannot returnd. Please help me.

The syntax of the SP is
-----------------------

CREATE PROCEDURE SP_FINDER

@p_outRSStatus char(1) OUTPUT

AS

begin
set @p_outRSStatus = 'V'
select * from tblErrEmailMaintain
end
GO

AND THE SYNTAX OF VB6 IS
------------------------
Set rstRecSet = cmd.Execute
strRSStatus = p_outRSStatus

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-21 : 02:09:57

you could write a function instead of a stored procedure, then call this from vb6

for function references, see BOL
for vb6, see msdn or post your snippet here

have fun learning...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources