Search:
Have you ever wanted to execute SQL Queries on ADO Recordsets as if they existed as Tables in a Database, perform SQL Joins between Recordsets or Group and Aggregate fields in a Recordset? Now you can.
With the QARv2 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 QARv2 dll component couldn't 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 Access 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. That's all there is to it.
Requirements:
Windows 95/98/Me/NT/2000/XP/2003 Server, Microsoft Jet 4.0, MDAC 2.5