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.
Active Query Builder Delphi VCL Edition is a free trial software application from the Delphi subcategory, part of the Development category.
The app is currently available in English, ChineseSimplified, Czech, Italian, Spanish and it was last updated on 2009-08-03. The program can be installed on Win95, Win98, WinME, WinNT 4.x, WinXP, Windows2000, Windows2003.
Active Query Builder Delphi VCL Edition (version 1.13) has a file size of 10.02 MB and is available for download from our website.
Just click the green Download button above to start. Until now the program was downloaded 108 times.
We already checked that the download link to be safe, however for your own protection we recommend that you scan the downloaded software with your antivirus.