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)
 stored procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-13 : 08:22:11
Carl Rempel writes "I just submitted a question about an hour ago...i've been
working on the problem all day. Right after sending you
the question, I discovered the mystery...how I found the
answer is unclear because I was reading ODBC documentation related to recordsets that looked promising and potentially
the same as ADO...and my intuition was right.

the solution: I had to use ADO and I had to use this magic line
of code...set rst = rst.nextrecordset...That's it.

By the way, that would be an useful article -- multiple result
sets in stored procedures."
   

- Advertisement -