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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-19 : 07:32:35
|
| Parvaneh writes "I connect to COM Object and get the count of the records by:exec @handle = sp_OAGetProperty @object, 'GetCount', @property outselect @handle as handle, @property as 'GetCount'OUTPUT IS:handle GetCount ----------- ----------- 0 4It gives me 4 which is correct. I want to get result set ofone of the columns which should give me 4 but I get one. Here is the satement exec @handle = sp_OAMethod @object, 'TaxTypeCode' or exec @handle = sp_OAGetProperty @object, 'TaxTypeCode'OUTPUT IS:Column1 ------- CTHow do I get all four values? Thank you,Parvaneh " |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-19 : 14:07:10
|
| Well it depends on what methods/properties the com object has but I would guess you would have to execute a nextrow method or give it some row identifier and loop though the rows.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 06/19/2003 14:31:15 |
 |
|
|
|
|
|
Get result set from a COM Object