Full Feature Matrix: Active Query Builder VCL Edition
| VCL Edition | ||
|---|---|---|
| Free Version | Full Version | |
Completely visual building of complex SQL queries |
||
| Visual building of unions, sub-queries, derived tables and CTE | yes |
yes |
| Design Pane to join tables in the query visually | yes |
yes |
| Expressions Grid to define criteria, grouping and sorting | yes |
yes |
| Query Structure Pane to browse and navigate complex queries quickly | yes |
yes |
| Database Objects Pane to add objects and fields to the query | yes |
yes |
| Datasource, Link and Query Properties dialogs to define various options | yes |
yes |
| Field Lists with ability to display data type and description | no |
yes! |
Powerful programming interface |
||
| Customizing generated SQL query text layout (SQL text formatter) | yes |
yes |
| Substituting real database object and field names with user-friendly aliases | no |
yes! |
| Retrieving the list of parameters found in the query and useful information them: datatype, related field, operator | no |
yes! |
| Altering metadata information (relationships between tables, field and table descriptions) | no |
yes! |
| Removing unwanted database objects from the list of selectable objects | no |
yes! |
| Preventing execution of queries with unwanted objects | no |
yes! |
| Adding complex expressions and sub-queries as ordinary fields ("Virtual fields") | no |
yes! |
| Adding SQL queries to the list of database objects ("Virtual database objects") | no |
yes! |
| Pre-filtering of database objects to speed up metadata loading | no |
yes! |
| Working without live database connection ("Offline mode") | no |
yes! |
| Saving all metadata information to XML file for future modification and faster loading | no |
yes! |
| Getting access to internal query representation objects for SQL query analysis and modification | no |
yes! |
Support for various SQL Dialects |
||
| ANSI SQL/92 | yes |
yes |
| Microsoft SQL Server | no |
yes! |
| Oracle | no |
yes! |
| Microsoft Access | no |
yes! |
| MySQL | no |
yes! |
| InterBase | no |
yes! |
| Firebird | no |
yes! |
| IBM DB2 | no |
yes! |
| Sybase ASA/ASE | no |
yes! |
| PostgreSQL | no |
yes! |
| Informix | no |
yes! |
| SQLite | no |
yes! |
| Mimer SQL | no |
yes! |
| ANSI SQL/89 | no |
yes! |
| ANSI SQL/2003 | no |
yes! |
Several visual representation modes |
||
| MS Access style | yes |
yes |
| SQL Server Enterprise Manager style | yes |
yes |
Miscellaneous options |
||
| Ability to translate interface of Active Query Builder to any language | yes |
yes |
| Ability to switch languages in run-time | yes |
yes |
| Ability to detect SQL Syntax dialect automatically | no |
yes! |
| Full Unicode support
The ability to use Unicode-enabled visual controls from TNT Library is available for the customers of Standard version with Source Code only as far as requires re-compilation with the third party source code.
|
yes |
yes |
Full set of database connectivity options |
||
| BDE (Borland Database Engine) | yes |
yes |
| dbExpress | yes |
yes |
| InterBase Express | yes |
yes |
| Zeos DBO (www.sourceforge.net/projects/zeoslib) MySQL, PostgreSQL, InterBase/Firebird, MS SQL, Sybase, Oracle, DB2 |
no |
yes! |
| SQLDirect BDE Replacement components (www.sqldirect-soft.com) DB2, Informix, IB/FB, MS SQL, MySQL, Oracle, PostgreSQL, Sybase |
no |
yes! |
| Allround Automations DAO (www.allroundautomations.com/doa.html) | no |
yes! |
| AidAim Accuracer Database System (www.accuracer.com) | no |
yes! |
| AidAim EasyTable BDE Replacement (www.aidaim.com) | no |
yes! |
| DBISAM Embedded Database Engine (www.elevatesoft.com) | no |
yes! |
| ElevateDB Embedded Database Engine (www.elevatesoft.com) | no |
yes! |
| Absolute Database (www.componentace.com) | no |
yes! |
| Advantage Database Server (www.advantagedatabase.com) | no |
yes! |
| MicroOLAP DAC for MySQL (www.microolap.com) | no |
yes! |
| MicroOLAP PostgresDAC (www.microolap.com) | no |
yes! |
| ODBC Express (www.odbcexpress.com) | no |
yes! |
| SoftVector ODBC DAC (www.softvector.com) | no |
yes! |
| Vista DB 2.1 Embedded SQL Database (www.vistadb.net) | no |
yes! |
| RemObjects Data Abstract framework (www.remobjects.com) | no |
yes! |
| DevArt Oracle DAC (www.devart.com/odac) | no |
yes! |
| DevArt MySQL DAC (www.devart.com/mydac) | no |
yes! |
| DevArt SQL Server DAC (www.devart.com/sdac) | no |
yes! |
| DevArt InterBase DAC (www.devart.com/ibdac) | no |
yes! |
| DevArt PostgreSQL DAC (www.devart.com/pgdac) | no |
yes! |
| DevArt Universal DAC (www.devart.com/unidac) | no |
yes! |
| Fast InterBase Plus (FIBPlus) (www.devrace.com/en/fibplus) | no |
yes! |
| IB Objects (by Jason Warton) (www.ibobjects.com) | no |
yes! |
| Luxena Informix DAC (www.luxena.com) | no |
yes! |
| DA-Soft AnyDAC (www.da-soft.com) | no |
yes! |
| Liodden Data NativeDB (www.nativedb.com) | no |
yes! |
| Generic event-driven metadata provider | yes |
yes |
Learn more about Active Query Builder
News
- 07/23/2010
Active Query Builder ASP.NET Edition 0.2 Beta is released.
Many bugs are fixed, initialization is advanced, UI performance is improved. - 06/11/2010
The new SQL Text Editor and Expression Editor for .NET is available now.
Windows.Forms text editing control with code completion, syntax highlighting and much more. - 06/11/2010
Active Query Builder ASP.NET Edition is available for purchasing now.
- 06/11/2010
Active Query Builder .NET Professional Subscription is released
It guarantees access to all ActiveDBSoft products for .NET Framework at minimal price. - » All news
- Subscribe
Testimonial
With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.
Thanks to all the team involved. Please keep up the good work.
Thanks to all the team involved. Please keep up the good work.
Duncan Deacon
