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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 RS Querying

Author  Topic 

jesus4u
Posting Yak Master

204 Posts

Posted - 2002-08-12 : 14:11:18
IF I have an existing recordset, can I execute SQL statements against that RS?

Thanks



robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-08-12 : 14:33:55
ADO recordset objects have some features for filtering and sorting, but that's about it. You *can* change the Source property, but it is, in effect, a completely different query; it will execute the SQL against the server again.

If you need improve performance on a recordset you can always use GetRows to dump the recordset into an array and work with it instead.

Go to Top of Page
   

- Advertisement -