Rowsets

Alan Gamboa <[email protected]> Mon, 3 Feb 2003 10:32:23 -0500
Newsgroups gmane.comp.windows.devel.oledb.devel
Message-ID <[email protected]>
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2CB99.727C0380
Content-Type: text/plain;
        charset="iso-8859-1"

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.

------_=_NextPart_001_01C2CB99.727C0380
Content-Type: text/html;
        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Rowsets</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>I have a query:</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>select f1,f2,f3 from t1 where f1 = 1</FONT>
</P>

<P><FONT SIZE=2>this query returns a rowset of 50 records.</FONT>
</P>

<P><FONT SIZE=2>I want create a new rowset that contains some of the records in the above rowset, what is the best way to do this?</FONT>
</P>

<P><FONT SIZE=2>thanks.</FONT>
</P>

<P><FONT SIZE=2>Alan Gamboa</FONT>
<BR><FONT SIZE=2>CCG Systems, Inc.</FONT>
</P>

</BODY>
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.
</HTML>
------_=_NextPart_001_01C2CB99.727C0380--