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 - 2001-02-09 : 16:37:31
|
Richard writes "Ok, in my application I have 2 COM objects. One designing to do all the ado stuff and the other to do the normal work (Search Engine).
From the ADO COM, I have a function that return value is a recordset but, I'm working with page, so I would like to pass the current page I want and to get back only this page in the recorset instead of the entire recordset. I haven't found any technique at this time to do it, so I pass the entirely recordset and after that, in the other COM, transformed only the current page into an xml string. So, they're a lot of unused data here.(The ado can't send back xml string because in other situation I need a recordset and not an xml string).
I wanna know if it is possible to send to my ADO COM a Page number and received only this current page in the recordset and not all the recordset!
Thx
Richard
SQL Server 7 and Windows 2000 Professional with all service pack up to February 9" |
|
|
|
|
|
Returning part of a recordset as a recordset