Re: Rowsets
Yuancai Ye <[email protected]> Tue, 4 Feb 2003 06:41:22 -0800
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi, See the site www.udaparts.com Regards, Yuancai (Charlie) Ye --- Alan Gamboa <[email protected]> wrote: > What is OleDBPro? > > thanks, > > Alan > > -----Original Message----- > From: Yuancai Ye [mailto:[email protected]] > Sent: Tuesday, February 04, 2003 9:31 AM > To: [email protected] > Subject: Re: [OLEDB_DEV] 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. > > 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.