Query-A-Recordset

Query ADO Recordsets with this tool
The Query-A-Recordset component performs full SQL queries on ADO recordsets and returns the results to applications. SQL queries can be executed on ADO recordsets as though they existed as tables in a database. Add the ADO recordsets that are to be queried, declare an alias for each recordset for identification, select the cursor and lock types, add the SQL (Microsoft 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.

Query-A-Recordset - Features

The Query-A-Recordset component performs full SQL queries on ADO recordsets and returns the results to applications. SQL queries can be executed on ADO recordsets as though they existed as tables in a database. Add the ADO recordsets that are to be queried, declare an alias for each recordset for identification, select the cursor and lock types, add the SQL (Microsoft 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.

It is compatible with the following containers:

• Microsoft Visual Studio .NET 2003, .NET, 6.0 and 97
• Microsoft Visual Basic .NET 2003, .NET, 6.0 and 5.0
• Microsoft Visual C++ .NET 2003, .NET and 6.0
• Microsoft Office XP, 2000 and 97
• Microsoft Access 2002, 2000 and 97
• .NET Common Language Runtime 1.1 and 1.0.

Features include:

• Obtain a subset of the original data in an ADO recordset
• Limit the number of round trips to the database server by using data that are available to the client
• Obviates the need for complex nested queries
• Obtain an aggregated result of data that exists in an ADO recordset
• Join data if the data source can be represented in an ADO recordset
• Join data from different databases or non-database sources such as text and application-derived data
• Disconnected data source
• External data are not contained in a database
• Provide SQL querying capabilities to an application without a database
• Use the component in an application that uses application derived data or a mixture of database and application derived data that requires querying capabilities to construct ADO recordsets consumed by the application.

Query-A-Recordset - System Requirements

• Microsoft Windows 95, 98, NT 3.51 or 4.0, 2000, ME or XP
• Microsoft Jet 4.0 or MDAC 2.5 or higher
• 64 MB RAM
• 9 MB available hard disk space.