Hoplite

Hello,

I was curious if anyone knew of a way to query an ADO recordset.

I have a disconnected ADO recordset that my program works with. I would like to run a SQL query against that recordset and populate the results into another recordset.

This is entirely in VB. I want to avoid using temp tables in our DB. Can it be done?

Akim

You can use Filter property on your existing recordset, if that's what you need.

Hoplite

I can do a lot of what I need with .Filter and .Sort, but is there a way to pull out some of the aggregate functions (Sum(), Max(), etc.). It seems to me there should be a better way than looping through the entire recordset tallying or comparing values.

Akim

You can't execute SQL against your existing disconnected recordset. The only thing you can do is to re-query your database and run your aggregate functions against your database (obviously, SQL statements executed on the database side).
Or you can loop through your recordset to achieve the same result.