Home | 10% - Off! | New | VCL | DB-Aware | Tools | DB Tools | Apps | Samples | .NET | .NET DB-Aware | .NET Tools | .NET Samples | Kylix | Docs | Bold | Discussion | Sites | Tips | DPFL | Authors | Uploads | RSS | Store | Advertisement | About
What's New

Last 7 days
  Applications
  Samples
  Components
  DB-Aware
  .NET
  DB Tools

7 - 14 days ago
  Components
  DB-Aware

 

What's New > DB-Aware Components > Last 7 days  

Companies News:

New FastReport VCL 5.2 released
New FastReport VCL 5.2 released

    We've added new export filter to SVG format. Now you can also reset properties to parents in inherited report – with a whole report or a single object. PDF export became transparent.

    Report designer gained a selection mode and became more flexible. We've also added multi-selection for data tree and ability to drag whole dataset.

    Even more – here

Want to know more ?

 

02 Jul 2015

DB-Aware Components > Visual > Visual Queries
Active Query Builder v.1.25.1C 57448 k NEW
02 Jul 2015
By Active Database Software. 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.

Active Query Builder - is all that you need to work with SQL queries.
 
Partially restricted
Source: On purchase/registration
Price: $195
Source Price: $395

Download: C2k10 C2k6 C2k7 C2k9 CB5 CB6 CB64 CBXE CBXE2 CBXE3 CBXE4 CBXE5 CBXE6 CBXE7 CBXE8 D2005 D2006 D2007 D2009 D2010 D5 D6 D7 DXE DXE2 DXE3 DXE4 DXE5 DXE6 DXE64 DXE7 DXE8  Register NowHomepage


News from our Sponsors

  Stellar Phoenix Database Repair for MySQL
Stellar Phoenix Database Repair for MySQL is professional yet simple utility to recover data from damaged or corrupt InnoDB tables and MyISAM tables of MySQL databases. The software efficiently recovers tables and other important objects of MySQL database such as queries of views, relations, primary keys, etc. The tool can perform recovery on Linux platform as well. With its interactive GUI, this software supports MySQL 6.x, 5.x, 4.x, and 3.x more... Buy now!


  Bring fresh look to your applications!
ThemeEngine is a library of components which allows to change visual appearance and behavior of your application with use of the powerful set of tools including visual components, convenient designers, easy-to-use non-visual components, the optimized graphic algorithms and a set of ready themes. ThemeEngine can add themes to forms, to the menu and to the elements of the management. 150+ stable easy to use components and 1000+ free skins. more... Buy now!

Advertising on Torry's Delphi Pages

 

Quick Search
Exact phrase
Title
Description


Advertising on Torry's Delphi Pages

Guest Book
Guest Book

Subscribe to news in RSS 2.0 format!Subscribe to news in RSS 2.0 format!
Bookmark and Share
Up | Home | 10% - Off! | New | VCL | DB-Aware | Tools | DB Tools | Apps | Samples | .NET | .NET DB-Aware | .NET Tools | .NET Samples | Kylix | Docs | Bold | Discussion | Sites | Tips | DPFL | Authors | Uploads | RSS | Store | Advertisement | About
Copyright © Torry's Delphi Pages Torry's Delphi Pages Maintained by Torry Team. Notes? Comments? Feel free to send...

The Ultimate Source of Object Pascal and Delphi Programming Knowledge.

Copyright © 1996-2015
All trademarks are the sole property of their respective owners
Privacy Policy