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 |
|
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. |
 |
|
|
|
|
|