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.
| Author |
Topic |
|
brubaker
Starting Member
15 Posts |
 Posted - 2002-07-25 : 22:59:01
|
| Anyone have any luck getting Ultradev to recognize stored procedures that return multiple recordsets? I can only get it to recognize the first recordset.Thanks, |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-07-26 : 00:01:13
|
| I haven't had any problems. Post your code and let us look at it.Jeremy |
 |
|
|
brubaker
Starting Member
15 Posts |
Posted - 2002-07-26 : 14:47:41
|
| I don't think I explained the problem properly. I'm using Dreamweaver MX (was using Ultradev) to execute a stored procedure. I do this using the command window. All of my stored procedures are available, however when I test one that returns 2 or more recordsets, it only returns the first recordset. They still work (i.e. no errors), but recordsets 2+ are simply ignored by Dreamweaver and the code that it builds.Therefore, there is no code to post, because I've never made it out of the command window. I guess this is more of a DMX question rather than an ASP or SQL question, so I apologize if this is in the wrong place. |
|
|
|
|
|
|
Ultradev and Stored Procedures