Re: Rowsets

Hi, Alan:
   Are you still looking for a way to solve your
problem. If so, I hope my following suggestion is
somewhat helpful to you.
   First open a rowset with MS Client cursor engine.
Then get the interface IRowsetView. You'd better use
TView with help of chapter by setting filter and sort
to create a new chapter rowset from an original
rowset. This can be very efficient because you don't
have to resend a query to a backend database. For how
to do it, see the sample FilterSort in OleDBPro.

Regards,

Yuancai (Charlie) Ye



--- Alan Gamboa <[email protected]> wrote:
> I have a query:
>
>         select f1,f2,f3 from t1 where f1 = 1
>
> this query returns a rowset of 50 records.
>
> I want create a new rowset that contains some of the
> records in the above
> rowset, what is the best way to do this?
>
> thanks.
>
> Alan Gamboa
> CCG Systems, Inc.
>
> You can read messages from the OLEDB_DEV archive,
> unsubscribe from OLEDB_DEV,
> or subscribe to other DevelopMentor lists at
> http://discuss.develop.com.
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.