download25.com

Your free TOP 25 download source!

Featured Software

 IconActive Query Builder Delphi VCL Edition
True two-way visual SQL Query Builder component for Delphi and C++ Builder
aqb_.zip

 IconEMS Data Import for DB2
Import data from MS Excel, MS Access, DBF, TXT, CSV and XML files to DB2 tables.
db2import.zip

 IconEMS Data Export for SQL Server
Program to export data from MS SQL databases into the most popular formats.
msexport.zip

 IconEMS Data Comparer for SQL Server
Powerful and easy-to-use tool for SQL Server data comparison and synchronization
msdatacomparer.zip

 IconSQL Diagrams
Don't spend hours trying to understand your database, see it with SQL Diagrams
SQLDiagrams.exe

Active Query Builder Delphi VCL Edition 1.13

True two-way visual SQL Query Builder component for Delphi and C++ Builder
Publisher: Active Database Software
Category: Databases & Networks
Version: 1.13
License: commercial
Cost: 195$
Size: 9.56 MB
Updated: 25 Jan 2016
Review
Active Query Builder is a true two-way visual query builder component for Delphi and C++ Builder that allows your end-users to build complex SQL queries via an intuitive visual interface similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, to construct criteria in a simple and direct way. Each union and sub-query has its own working area where it could be built visually as easy as single query.

Active Query Builder supports Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, and other SQL dialects. The sophisticated SQL parser with full Unicode support can translate any valid SQL statement into it's visual representation. SQL Formatter will allow you to customize the SQL code layout the way you like it.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects. Also you can modify existing SQL queries and create new queries programmatically. Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.

You might want to deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. Using the Active Query Builder, you can do it easily. Building a query via a visual interface, you can hide undesirable objects and fields of your database. Ability to retrieve various information about the query, such as lists of tables and fields that were used in the query, allows you to prevent execution of unauthorized queries.

The latest version of our component allows you to replace real table and field names with the user-friendly aliases.

Active Query Builder VCL Edition may be compiled with DevExpress controls and Uniclde-enabled TnT library.


Changelog:
Version: 1.13(03 Aug 2009)
- Firebird 2.5 support is added.
- Embarcadero RAD Studio 2010 is supported now.
Version: 1.10.5(10 Oct 2008)
- Support of Embarcadero Delphi 2009 IDE is implemented.
- Ability to compile the component with DevExpress controls is added.
- Customization of datasource's field lists at the query building area is made.
- Other minor improvements and bug fixes are made.
Version: 1.10(25 Jul 2008) - aqb_.zip
- Customization of datasource's field lists at the query building area is made.
- Field lists are retrieved now through the database server specific queries.
- Building queries with grouping is much simpler now.
- Other minor improvements and bug fixes are made.
Version: 1.9(02 Apr 2008)
- Compilation of the component with TNT and TMS Unicode visual library.
- Firebird syntax: common table expressions are supported now.
- AnyDAC, ODBC Express and NativeDB connectivity packages are added.
- The new Universal Syntax Provider is added to the Free version.
Version: 1.7.9(27 Mar 2007)
- Chinese, Czech and Italian localizations are added.
- Support of Synonyms and Analytic Functions in Oracle, Join Object Hints, Ranking and Aggregate Window Functions in MS SQL Server, more precise erroneous token reporting, other SQL parsing improvements.
- Many other bugfixes and improvements.
Version: 1.7.7(08 Jan 2007) - aqb_fr.zip
- Added support for C++ Builder 5 IDE and BDS 2006 C++ Builder personality.
- Ability to convert queries between dialects is implemented.
- Spanish localization is added.
Version: 1.5.5 - aqb_de?.zip

download (aqb_.zip - 9.56 MB)