ComponentOne Query

ComponentOne Query 8.0 is an ActiveX control that provides everything you need to offer powerful ad hoc querying in your applications, without the need for your end-users to learn new skills-in fact, they don't even need to know that ComponentOne Query 8.0 was used at all! ComponentOne Query 8.0 is an elegant solution for ad hoc querying. Until now, developers wishing to incorporate ad hoc querying into applications faced challenges ranging from how to develop all imaginable queries in advance to working with a rigid user interface. Those problems can be eliminated with ComponentOne Query.

Latest News about ComponentOne Query

Individual Sales of this component are no longer available - you must purchase as part of suite - posted 5/21/2007

Starting 5/21/07, renewal skus for individual products and individual studios are no longer offered except under special circumstances. This is the final phase of ComponentOne's year-long transition from single components to exclusively offering the ComponentOne Studio Enterprise suite of developer tools. For more information, ComponentOne Studio Enterprise


Image Gallery - Click Image to Enlarge

Call or mail for pricing and product availability.

---

Detailed Product Description

Do Your Users Require Access to the Database?

Well, of course they do - it's their data! The problem is most end users don't know beans about SQL, not to mention a tidy normalized database, so you're always "running a quick query for this" or "writing a quick report" for that. Wouldn't it be nice just to give them one tool that they could use for all their ad hoc inquiries? Well, now you can - ComponentOne Query does exactly that in one neat ActiveX component.

Oh Schema, My Schema...

The hardest part about end user query tools is setting up an easy-to-understand database schema. ComponentOne Query gets you on your way by importing the schema of an existing database for you to use or customize. You can also enter the schema by hand. ComponentOne Query generates standard SQL that you can use with any backend database. Since every database has its quirks, you can customize and optimize the generated SQL as needed.

UI Heaven

Many components claim to have an easy-to-modify UI. ComponentOne Query achieves this goal by using HTML templates rather than the standard blizzard of properties and methods, so you can reconfigure the look and feel just by changing a few HTML snippets. You can even replace the standard UI with your own custom one, so the UI can look exactly the way you want.

• Generates standard SQL but allows customization for specific database platforms
• Works with any backend database
• Fully customizable UI

---

Features:

Ad hoc query functionality at run time, not design time
ComponentOne Query 8.0 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 8.0 in an application or even need to be aware that the tool was used to create the application. ComponentOne Query 8.0 can be used with Visual Basic^® 6.0; Visual C++^® 6.0; Delphi^™ 5.0; C++ Builder^™ 5.0; Internet Explorer^®; and other environments supporting ActiveX^® controls.

Query engine and schema designer
ComponentOne Query 8.0 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 Microsoft^® Windows: 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.

• Customizing with templates: Every visual aspect of the user interface can be customized using HTML templates and simple HTML snippets to specify how you want to render conditions and other query elements. HTML is used exclusively for UI customization. Because ComponentOne Query is an ActiveX^® control, it can be used in Visual Basic^® and any other ActiveX-enabled environment-without HTML pages-and template customization will still be available.
• Customizing with scripts: You can customize the user interface even further, replacing the general display layout with a completely different one. With the help of a special script, you can change the layout as your query appears on display. One of the tutorials shows you how to do it by presenting a sample script that makes the query display look like a formula with parentheses instead of a default row outline. End-user interaction remains fully functional, although the query layout is completely changed.
• Customizing by replacing the built-in UI: If you prefer, you can even substitute the built-in, customizable user interface with one of your own that you create on a Visual Basic form (or create using any other means). You can still benefit from the powerful Query Engine! The ComponentOne Query object model allows you to programmatically set the fields and conditions specified by your users and generate the SQL statement from them.

Hierarchical folder structure
The interface exposes fields to your end-users in the form of a hierarchical folder structure. This enables you to name and organize query fields according to the customer business domain, rather than deal with database table and column names.

Value editing
When your end-users enter constant values in queries, they can use convenient, built-in editors for types like date/time (with dropdown calendar!), numeric, etc.

Lookup lists
You can specify "lookup data source" for a field and ComponentOne Query will present end-users with a lookup combo or menu (for example, users can select a product from a list of products, instead of entering a cryptic ID). Adding a lookup is as easy as calling a method specifying the data source and the names of the fields in the lookup. And it's fully customizable—you can create fixed lookup lists in schema or you can retrieve them from a database or fill them programmatically in a special event.

Custom editors
You can use the default edit and lookup facilities included with ComponentOne Query or you can specify any ActiveX control as an editor for a constant value in a query. This way, you can implement custom editing and custom lookup.

Multi-table views
You can create multi-table views combining information stored in different tables with the Schema Designer.

Calculated fields
Calculated fields can be added to schema views so that users can query these fields as if they were stored in the database.

Join relationships
The ComponentOne Query schema contains relationships between tables. The Query Engine uses relationships to join tables in the generated SQL query.

Join groups
As a simplified method of joining tables, ComponentOne Query allows you to assign fields to join groups. Fields belonging to the same join group can be used by the Query Engine to join tables in the generated SQL query.

Custom condition relationships
The Schema Designer allows you to specify arbitrary SQL conditions that are automatically applied (added to the generated SQL) once certain views (tables) appear in the query.

Free run time distribution
ComponentOne Query applications can be distributed with no run time royalty fees.