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 |
|
charlesmorris
Starting Member
11 Posts |
 Posted - 2001-07-26 : 20:30:48
|
| I have a SP that I wrote to calculate some shipping costs. Simple. a few variables in, a small result set out. Works great in Enterprise Manager.My problem is that several programs i use regularly for development throw a Cursor Error when trying to initialize this SP.After a bit of research, it seems that these MFC apps think that the first select statement, the one inserting data into the temp table, is the 'real' statement, not the last SELECT statment. Then they throw a cursor error because the pointer that was used on that first temp table gets destroyed.I would assume this is pretty commonplace. I have only found one reference in relation to it. Heres the link on MS's site... http://support.microsoft.com/support/kb/articles/Q190/7/62.ASPTThis seems like what is happening, but as opposed to wanting a return parameter, i wish to get my results set. (the last SELECT STATEMENT executed)Has anyone run into this? If so have you got around it? Or any ideas where I might read more?TIA,Charles |
|
|
|
|
|
ASP Cursor Error using SP with Multiple SELECT