Active Query Builder v.1.28
Commercial
11 Oct 2017
In category
DB-Aware Components > Visual > Visual Queries
Description
Active Query Builder is a visual SQL query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface.- Completely visual building of complex SQL queries: Each union and sub-query has its own working area where it could be built visually as easy a single query.
- MS Access style visual query building UI: The interface is similar to either MS Access query construction interface, but is much more powerful compared to other similar components.
- User-friendly interface with drag & drop support. Complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way.
- Powerful means of working with parameters: Active Query Builder can get various information about parsed query like lists of tables and fields used in the query. You can learn parameter names and data types, and discover to what database objects and fields they related to.
- Working in offline mode: In case direct connection to the database is not possible, save database schema to XML file in advance, then load metadata from this file.
- Limiting access to unwanted objects: Deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. You can also check your queries on the presence of unwanted objects before their execution.
- User-friendly query building environment: Active Query Builder allows for substitution of the user-friendly aliases for unintelligible names of your DB tables and fields. Though, your end-users can still build SQL scripts by hand: all the aliases used in query text will be automatically replaced with the real names in the result query text.
- Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite, Teradata, Netezza and ANSI SQL/92, 89 and 2003 dialects SQL syntax. Using Active Query Builder you can determine the currently used database server automatically.
- SQL Formatter: Using the Active SQL Query Builder you can customize SQL code the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.
- Localization: It is possible to localize Active Query Builder completely and to switch between available languages in run-time. Dozens of localizations are ready to use.
The Professional version additionally includes the Advanced SQL Text Editor with code completion and syntax highlighting.
Active Query Builder - is all that you need to work with SQL queries.
Informations
- Status: Partially restricted
- Source: C
- Price: $195
- Source price: $395
- Size: 81 034 608kB
Platforms:
- C++ Builder 10
- CBuilder 10.1 Berlin
- CBuilder 10.2 Tokyo
- C++ Builder 2010
- C++ Builder 2006
- C++ Builder 2007
- CBuilder 2009
- C++ Builder 5
- C++ Builder 6
- C++ Builder XE3 64-b
- C++ Builder XE
- C++ Builder XE2
- C++ Builder XE3
- C++ Builder XE4
- C++ Builder XE5
- C++ Builder XE6
- C++ Builder XE7
- C++ Builder XE8
- Delphi 10
- Delphi 10.1 Berlin
- Delphi 10.2 Tokyo
- Delphi 2005 (VCL)
- Delphi 2006 (Win32)
- Delphi 2007 (VCL)
- Delphi 2009
- Delphi 2010
- Delphi 5
- Delphi 6
- Delphi 7
- Delphi XE
- Delphi XE 2
- Delphi XE3
- Delphi XE4
- Delphi XE5
- Delphi XE6
- Delphi XE2 64-bit
- Delphi XE7
- Delphi XE8
Downloads