|
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.

Keywords: Not Established
|

|
15 Latest Releases in Development - Delphi |
|
1D Barcode VCL Components
Generate, draw, and print most popular barcode symbologies.
|
|
BusinessSkinForm
Create cool application with skins support!
|
|
DynamicSkinForm
Create cool application with skins support!
|
|
2D Barcode FMX Components
A set of FireMonkey components designed for generating 2D barcode symbols.
|
|
2D Barcode VCL Components
Generate most popular matrix and stacked 2D barcode symbologies.
|
|
PostgresDAC
PostgreSQL BDE replacement for Borland Delphi/C++Builder.
|
|
novaPDF SDK
Easily integrate PDF creation support in your application using novaPDF SDK.
|
|
AudioLab VCL
Delphi/C++ Builder VCL/FMX components for fast audio capture and processing.
|
|
ESBPCS-Dates for VCL
Delphi Components and Routines for Calendars and Date/Time Manipulation.
|
|
Addict
Spell checking and thesaurus component suite for Delphi and C++ Builder.
|