Active Query Builder Delphi VCL Edition 1.13
Active Query Builder is a Delphi VCL component to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
Download
9.56 MB · aqb_free.zip
1.5Kdownloads
0this week
$195Commercial
0reviews
About Active Query Builder Delphi VCL Edition
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 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.
| Requirements | CodeGear Developer Studio, Borland Delphi or C++ Builder |
|---|---|
| Release info | Major Update on Aug 03, 2009 |
| Release notes | - Firebird 2.5 support is added. - Embarcadero RAD Studio 2010 is supported now. |
| Related tags | sql query builder visual delphi |
Reviews
No reviews yet. Be the first to review Active Query Builder Delphi VCL Edition.
Used Active Query Builder Delphi VCL Edition? Tell other visitors what you thought.
Log in to write a reviewOther products by this publisher
-
Active Query Builder ActiveX Edition 1.13
Active Query builder is a .Net-ready ActiveX control to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
-
Active Query Builder for .NET 2.1
Active Query Builder for .NET is a component to create SQL queries easily. True two-way query builder with powerful user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
-
FlySpeed Data Export 5.1
Try FlySpeed Data Export and you will see that it's the appropriate data export tool to use, whether exporting from a database or document. Allowing even complex queries to be applied to the export, this tool will save you precious time.
-
FlySpeed DB Migrate to MySQL 2.4
FlySpeed DB Migrate to MySQL enables rapid migration of MySQL structure and data to another database server, or transfer the data to the structure that already exists. It supports ADO, ODBC, Unicode and offers unprecedented control over migration.
-
FlySpeed DB Migrate to SQL Server 2.4
FlySpeed DB Migrate to SQL Server enables rapid migration of MS SQL db structure and data to another database server, or transfer the data to the structure that already exists. It supports ADO, ODBC and offers unprecedented control over migration.
Most viewed Windows Delphi Components
- 1 ComPort 3.9 Delphi and C++ Builder component for serial communication for Windows. Communication with devices connected to serial port. Easy of use and very powerful. Uses multithreading and overlapping for maximum performance.
- 2 TRichView for Delphi 16.13.3 Delphi/C++Builder components for displaying, editing and printing rich hypertext documents. Various text formatting, tables, images, textured background, HTML, DocX export, RTF import and export, data-aware versions, printing with scalable preview.
-
3
Advanced WiFi-Manager 5.5
Advanced WiFi-Manager is a developer tool that allows you to manage wireless networks and settings in Windows 2000, 2003, XP and Vista using one set of API functions.
-
4
Absolute Database 7.30
Single file Delphi database with comprehensive SQL support, strong encryption, BLOBs and multiuser mode support. This BDE alternative is fully compatible with standard and third-party db-aware components and reporting engines.
-
5
Luxand FaceSDK 8.0
Real-time precision face recognition and identification SDK for C++, C#, Objective C, Swift, Java, VB, Delphi, Python. FaceSDK enables developers to build web, Windows, Linux, MacOS X, iOS and Android applications with face recognition functionality.
-
6
DAC for MySQL 3.1.0
DAC for MySQL (also known as MySQLDAC) is the most powerful component suite for Delphi/C++Builder/ MySQL. It allows you to create Delphi/BCB applications with direct access to MySQL DB without BDE/ODBC. A MySQL library is not required.
-
7
hbTapi Components 10.2
hbTapi Components is a collection of Delphi VCL components allowing object-based access to Microsoft's Telephony API (TAPI). It supports multiple phones, lines, addresses and calls. DTMF handling and wave playback/recording is included.
-
8
TeeChart Pro VCL / FMX 2018
TeeChart VCL/FMX charting components library offers full set of Graph styles in 2D and 3D for data visualization, 50+ financial and statistical indicators for you to choose from together with an unlimited number of axes and 30 Palette components.
-
9
Email Validator .NET Component 6.0
Ultimate Email Validator is a .NET class library that adds powerful and comprehensive address validation to your .NET app without sending e-mails to recipients. You can easily validate bulk e-mails loaded from many sources with a single line of code
-
10
Advanced Data Export VCL 4.2
Advanced Data Export VCL is a component suite for Delphi and C++ Builder that will allow you to save your data in the most popular data formats for the future viewing, modification, printing or web publication.
Most downloaded Windows Delphi Components
- 1 ComPort 3.9 Delphi and C++ Builder component for serial communication for Windows. Communication with devices connected to serial port. Easy of use and very powerful. Uses multithreading and overlapping for maximum performance.
-
2
Absolute Database 7.30
Single file Delphi database with comprehensive SQL support, strong encryption, BLOBs and multiuser mode support. This BDE alternative is fully compatible with standard and third-party db-aware components and reporting engines.
-
3
jDoji Candlestick Pattern Recognition Engine DEMO
jDoji Pattern Recognition Engine is a high performance pattern recognition engine with pre-built candlestick pattern library included.
- 4 Demo toolbar for Microsoft Outlook (MSODemoToolbar). 1.1 This demo program allows to add a toolbar into Microsoft Outlook. Developers can use the source code as a framework for their own toolbars.
- 5 TRichView for Delphi 16.13.3 Delphi/C++Builder components for displaying, editing and printing rich hypertext documents. Various text formatting, tables, images, textured background, HTML, DocX export, RTF import and export, data-aware versions, printing with scalable preview.
-
6
DAC for MySQL 3.1.0
DAC for MySQL (also known as MySQLDAC) is the most powerful component suite for Delphi/C++Builder/ MySQL. It allows you to create Delphi/BCB applications with direct access to MySQL DB without BDE/ODBC. A MySQL library is not required.
- 7 Demo toolbar for Internet Explorer x64 1.0 Demo toolbar for Internet Explorer x64
-
8
Active Query Builder Delphi VCL Edition 1.13
Active Query Builder is a Delphi VCL component to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
-
9
Object Inspector 1.592
Object Inspector is a component suite containing inspectors that allow you to change anything in your application at runtime.
-
10
hbTapi Components 10.2
hbTapi Components is a collection of Delphi VCL components allowing object-based access to Microsoft's Telephony API (TAPI). It supports multiple phones, lines, addresses and calls. DTMF handling and wave playback/recording is included.