Perform SQL command on Disconnected ADO Recordset
A recordset is the result of a query, so you can't really query it. You will
need to use code to extract the values you need (or to step through and
calculate your aggregates). This is a bit of a hassle, but not too bad. The
Filter property can help here, as well as the Find method. Then a simple
loop through the recordset can retrieve or add or otherwise manipulate the
values.
"R Avery" wrote:
I have an ADO recordset that I created by declaring it as new and
adding all of the columns and data manually. I want to be able to
perform a SQL string on it to do aggregation and other things that SQL
provides. Is there anyway to do this?
|