Features:

• Ad hoc query functionality at run time, not design time -ComponentOne Query collects end-user input and generates an SQL query or an ADO Filter condition at run time. Now you can add ad hoc query functionality to your applications and make it directly available to end-users, instead of preparing all imaginable queries beforehand at design time. Plus, you can shield your end-users from the complexities of database structure. They can construct queries using convenient names and business concepts they already know. Your users don't require any special skills in order to use ComponentOne Query in an application or even need to be aware that the tool was used to create the application
• Query engine and schema designer - ComponentOne Query works with a schema containing database structure information and all the additional data necessary to generate SQL queries, such as joins and relationships between tables. The Schema Designer can import database structure from any OLE DB data source and create a complete schema for you, which can then be customized. You can also create a schema manually, without connecting to a database
• SQL database support - SQL queries generated by ComponentOne Query can run in every database supporting SQL. You can execute them using any database access engine available in MicrosoftWindows: ADO/OLEDB, DAO, ODBC, and native database interfaces. You can customize the resulting SQL syntax, adjusting it to your database requirements
• Simple DataSource mode - If your queries don't span multiple tables (a common case in many applications), using ComponentOne Query becomes a matter of "point and click." It can be bound to any ADO/OLE DB data source, just like any data-aware control, and will instantly be able to receive user input and generate queries without using the Schema Designer
• Built-in, customizable user interface - Use the intuitive, visually appealing interface as is or use templates or script to easily customize colors, fonts, words and phrases used in query display, and virtually all other aspects of the interface