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 |
|
wharden
Starting Member
4 Posts |
 Posted - 2004-05-19 : 16:26:50
|
| I'm calling a COM component from a SP (usiing sp_oa) and I'm able to return individual property and method results as a single value, but would like to return a recordset to the SP -- is this possible? |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-05-21 : 10:54:46
|
| No, you can only pass scalar values. |
 |
|
|
wharden
Starting Member
4 Posts |
Posted - 2004-05-21 : 12:04:14
|
| Thanks, sorry if these are basic questions. Then would it be possible to pass the recordset one field at a time, and build a rowset in a SP? |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-05-21 : 13:19:47
|
| This is possible. Another option if you must remote out is to allow COM to perform the intire functionality in one call (i.e. let COM build the rowset into a table located in your DB and return bool indicator when complete). |
|
|
|
wharden
Starting Member
4 Posts |
Posted - 2004-05-21 : 15:21:33
|
| Building moving the rowset into the DB sounds good. I just have to see if the client will go for leaving the error checking in the COM object rather than doing it themselves. |
|
|
|
|
|
|
Handling result set from COM