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

Click to enlarge
|
15 Latest Releases in Development - Delphi |
|
PlotLab VCL
Delphi/C++ Builder VCL/FMX components library for very fast Data Visualization.
|
|
VisioForge Video Edit SDK Delphi
Delphi control for video editing.
|
|
AMRandom
Generate Random Numbers to fit Probability Distribution - Full Delphi Source
|
|
SignalLab VCL
Set of VCL/FireMonkey(FMX) fast, easy Digital Signal Processing(DSP) components.
|
|
Delphi Spell Checker PRO
Award-winning Spell Checker for Delphi. Check Spelling in forms, hints, captions
|
|
VideoLab VCL
Delphi/C++ Builder VCL/FMX components for fast video capture and processing.
|
|
Firebird Metadata Synchronizer
Simplifies migration of Firebird SQL Metadata between databases
|
|
Delphi Code Library
Multi-language source code library and clipboard extender for Windows
|
|
OEExplorer
Framework for programs that have to work with Outlook Express messages, folders
|
|
Barcode VCL Components
Generate, draw, and print most popular barcode symbologies.
|