Execute SQL queries on ADO Recordsets
EditByBSEditor: Execute SQL queries on ADO Recordsets as though they existed as Tables in a Database. Query-A-Recordset allows you to perform full SQL queries on ADO Recordsets and return the results to your application. No more complex filter and find routines. No more expensive round trips to the Server to obtain a subset of data that already exists. New for v1.2 - Dramatically Improve the performance of all subsequent queries performed on previously returned ADO Recordset results.
Using the Component couldnt be easier, just add the ADO Recordsets that you wish to query, Declare an alias for each Recordset for identification, decide on the Cursor and Lock Types, add your SQL (MS Jet SQL Syntax) and execute the query. Successful Execution of the query will return a disconnected ADO Recordset representing the query results that will reflect the Cursor and Lock Types as defined. Thats all there is to it. you can free download Query-A-Recordset 2.0 now.