Query-A-Recordset 1.1

Execute SQL queries on ADO Recordsets as though they existed as Tables in a Database. With the QueryARecordset dll component you can perform full SQL queries on any ADO Recordsets and return the results to your application. No more complex filter and find routines or writing data to temporary tables. No more expensive round trips to the Server to obtain a subset of data that already exists saving on valuable Connection and Server resources.

Using the QueryARecordset dll 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.