|
Active Query Builder Standard ActiveX Edition
Active Query Builder ActiveX Edition is a visual query builder component
suite that allows your end-users to build complex SQL queries with unions
and subqueries via an intuitive visual interface.
The interface of Active Query Builder is similar to either MS-Access or
SQL Server query construction interface, but has much more possibilities
than any other similar component. Such unique features of Active Query
Builder like building queries with unions and sub-queries make it the
best solution for professional tasks.
The component may be integrated with your application with just few lines
of code. Unlike many other query building solutions, Active Query Builder
does not force the programmer to use embedded data grid, SQL editor or
something else. Instead, it allows to integrate any accompanying functionality
as quickly and easy as possible.
Software Information |
System Requirements |
Version: |
1.9 |
- Windows 98/ME/NT/2000/XP/Vista
- 256 MB RAM
- Pentium II CPU
|
License: | Free to try, $295.00 to buy |
File Size: |
3.37 MB |
Screenshot : |
View Screenshot |
Rating : | |
Key Features:
Completely visual building of complex SQL queries
- Visual building of sub-queries
- Visual building of unions
- Columns pane allowing to define grouping, sorting, and constructing criteria
- Tree pane to browse and navigate query tree
- Database objects tree pane to add objects to query
- Visual criteria constructing tool for Where and Having clauses (Forecast)
Powerful programming interface
- Configuring the layout of generated SQL code
- Retrieving the list of parameters found in the query
- Retrieving extended information about parameters: datatype, related field, operator
- Ability to alter metadata information
- Ability to define alternate user-friendly names for database objects and fields
- Ability to build queries with objects from different databases
- Pre-filtering of database objects to speed up metadata loading
- Ability to work without live database connection
- Saving and loading all metadata information to XML format
Support for various SQL Dialects
- ANSI SQL/92
- Microsoft SQL Server
- Oracle
- Microsoft Access
- MySQL
- InterBase
- Firebird
- IBM DB2
- Sybase
- PostgreSQL
- Informix
- SQLite
- ANSI SQL/89
- ANSI SQL/2003
Several visual representation modes
- MS Access style
- SQL Server Enterprise Manager style
Miscellaneous options
- SQL Formatter: Plain text output filter to customize SQL code the way you like it
- Ability to detect SQL Syntax dialect automatically
- Ability to translate interface of Active Query Builder to any language
- Ability to switch languages in run-time
- Full Unicode support
RELATED SOFTWARE DOWNLOADS FOR ACTIVE QUERY BUILDER STANDARD ACTIVEX EDITION
- Quick Query
It provides a simple way to perform SQL based queries on the fly, without the need to create and save a query using the standard MS Access interface.
- Visual SQL-Designer
is a program for visual constructing hard SQL-query for any database and write it
- Visual Open DB
is a generic data analysing application that allows you to query any valid data source
- 4TOPS Query Tree Editor for MS Access
is an add-in for MS Access for query development,edit and run queries from a tree dialog
- RazorSQL 4.X
is an SQL query tool, Navigator database, SQL editor, and database administration tool.
- Active Query Builder Standard .NET Edition
is a visual SQL query builder component that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily.
- ODBC DAC Standard Edition
component set for Delphi/C++Builder to access any database via ODBC interface directly
- ASP/Barcode
is a server side COM component that allows web developers to add barcodes to their applications.
- Database Reporting ActiveX Control
is an abstract solution and hence general solution to all reporting problems.
- Multi-DB Querier
is database SQL tool, which allows running SQL queries on multiple databases with similar structure
- SQL2GSM
can simply configure almost any SQL query that might be processed if preconfigured SMS is received
|
|