Problem returning results from an sp 
Author Message
 Problem returning results from an sp

I have a problem obtaining a result from the following sp:

AS





BEGIN  



        BEGIN


                IF EXISTS (SELECT mtr_key FROM clymtr WHERE

                BEGIN

                End
                Else
                BEGIN
                        INSERT CLYMTR (mtr_rsn, mtr_name, mtr_key,
mtr_cly)  




                END
        END
END
ELSE
BEGIN  
        INSERT clymtr (mtr_rsn, mtr_name, mtr_cly, mtr_key)



END


BEGIN

End
Else
BEGIN



End

And sending it



If I run this in SQL I get

9294 NEWEST1

But if I run it from VB I get 9294 and then 'ADO could not find the
corresponding object'

I'm runnning and sending the same thing - any ideas?

Thanks Jane



Mon, 01 Jan 2001 03:00:00 GMT
 Problem returning results from an sp

Jane,
What does the ADO look like?
The select at the end of your stored procedure will produce a recordset.
It is not necessary to do this since the output will be
returned to the ADO command.parameters of type adOutput.
--
Bill Wunder
SQL Server DBA tutorials and sample code
http://www.nyx.net/~bwunder


Mon, 01 Jan 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Returning a result set from a SP from a SP

2. Problem with results and SP calling SP in VB

3. SQL run as query vs SP returns different results

4. How can SP return records from the last query results

5. urgent - thread active after SP returning result set

6. Newbie- Returning a value from SP based on query result

7. Returning a result from select to a variable in a SP

8. How to process result sets returned by SP

9. Return a result set in a file from a SP

10. No Result Set Returned from SP in ASP Page

11. Returning Result Set In a SP

12. SP to return result set of dates


 
Powered by phpBB® Forum Software