Active Query Builder VCL Free Edition 1.12.0.0 Description:

Active Query Builder is a query builder component suite for Borland Delphi 6, 7, 2005 and C++ Builder 6 that allows your end-users to build complex SQL queries via an intuitive visual interface.

IActive Query Builder VCL differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax.

Active Query Builder Standard Edition is a useful utility that allows you to produce SQL queries.

The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and sub-queries make it the best solution for professional developers.

Active Query Builder supports SQL Server, Oracle*, MySQL, PostgreSQL, Interbase/Firebird, SQLite, and ANSI-92 SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation. You can use BDE, ADO and ZeosDBO database connectivity components and Generic event-driven metadata provider to get metadata information from any data source.

The component may be integrated into a Delphi or C++ Builder application with just a few lines of code. Unlike many other query building solutions for Delphi, Active Query Builder does not force the programmer to use the embedded data grid, SQL editor or anything else.

Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible. The product is shipped with a detailed help system and a demo application to help you quickly master the product.

Active Query Builder VCL Free Edition 1.12.0.0 Features:

Here are some key features of "Active Query Builder Standard Edition":

· Completely visual building of complex SQL queries.
The unique features of Active SQL Query Builder such as the ability to build queries with unions and subqueries make it the best solution for professional developers. Each union and sub-query has its own working area where it could be built visually as easy a single query.

· MS Access style and SQL Server style visual query building interface.
The interface of Active SQL Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. Active SQL Query Builder allows you to tune all parameters of each single part of a query with the dialog window.

· User-friendly interface with drag & drop support.
Working with Active SQL Query Builder you can access each union and subquery in one-touch; complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way.

· The component gives an opportunity to set most frequently used query properties visually, such as DISTICT, TOP (LIMIT), etc.

· Powerful means of working with parameters.
One of the most exciting features of Active Query Builder is ability to retrieve various information about parsed query like lists of tables and fields used in the query. 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.

· Working in offline mode, storing metadata in XML files.
In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.

· Delicate handling of user queries.
We care about keeping user queries in the same form as they entered in the SQL query text. None of conditions and options will be lost after query parsing because we understand how important they could be in result.

· Restricting access to unwanted objects
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 except undesirable objects and fields of your DB. You can also check your queries on the presence of unwanted objects before their execution.

· Designing user-friendly query building environment
The latest version of our component allows you to substitute the user-friendly aliases for unintelligible names of your DB tables and fields. Though, your end-users can still build SQL scripts by hand: all the aliases used in query text will be automatically replaced with the real names in the resultant query.

· Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQLite and ANSI SQL/92, 89 and 2003 dialects SQL syntax.
By claiming full support of these SQL dialects, we mean the possibility of a parsing of almost any valid SQL query for the given database server and keeping of every single clause during a query modification process without any losses. Generated from the improved CoCo/R Compiler Generator, Active SQL Parser with full Unicode support correctly handles multiple nested joins and other fine points found in some SQL dialects.

· Using Active Query Builder you can determine the currently used database server automatically, in case it cannot be defined in advance.

· SQL Formatter.
Using the Active SQL Query Builder you can customize SQL code the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.

· Localization.
Now it is possible to localize Active Query Builder completely and to switch between available languages in run-time.

· Active Query Builder is a special component.
It wasn't created for some internal needs, it was made to meet customer needs. This component was made by a team of enthusiast programmers to express their vision of the visual query building. All your comments and suggestions will be taken into consideration because we really want to make it the best tool possible.

Active Query Builder VCL Free Edition 1.12.0.0 Requirements:

· Borland Delphi 5, 6, 7, 2005 or C++ Builder 5, 6

Active Query Builder VCL Free Edition 1.12.0.0 Limitations:

· the Free Edition is limited in functionality: only the ANSI-92 SQL dialect parser is included.

Related searches:

active query builder activex edition - active query builder net edition - active screensaver builder

Active Query Builder VCL Free Edition security information

You cannot download any crack or serial number for Active Query Builder VCL Free Edition on this page. Every software that you are able to download on our site is legal. There is no crack, serial number, hack or activation key for Active Query Builder VCL Free Edition present here. Our collection also doesn't contain any keygens, because keygen programs are being used in illegal ways which we do not support. All software that you can find here is freely downloadable and legal.

Active Query Builder VCL Free Edition installation package is prepared to be downloaded from our fast download servers. It is checked for possible viruses and is proven to be 100% clean and safe. Various leading antiviruses have been used to test Active Query Builder VCL Free Edition, if it contains any viruses. No infections have been found and downloading Active Query Builder VCL Free Edition is completelly problem free because of that reason. Our experts on malware detection tested Active Query Builder VCL Free Edition with various spyware and malware detection programs, including fyxm.net custom malware and spyware detection, and absolutelly no malware or spyware was found in Active Query Builder VCL Free Edition.

All software that you can find on our servers, including Active Query Builder VCL Free Edition, is either freeware, shareware or open-source, some of the software packages are demo, trial or patch versions and if possible (public domain licence), we also host official full versions of software.

Because we want to be one of the fastest download sites on the web, we host all the software including Active Query Builder VCL Free Edition on our servers. You cannot find here any torrents or download links that would lead you to dangerous sites.

Fyxm.net does support free software, however we do not support warez or illegal downloads. Warez is harming producers of the software.

Enjoy!