Active Query Builder VCL Edition (1.7.9.31)


Product Type:VCL Function Type:DataBase Develop Language:ASP,C++ Builder,Delphi,Visual Basic 6.0,Visual C++ 6.0


0 submitted comments View Comment | Add Comment

Active Query Builder is a Delphi and C++ Builder visual query building component to make complex SQL queries with unions and sub-queries easily. Its user-friendly interface and unique query research capabilities provide optimized results and is sure to increase the number of potential users of your product. Active Query Builder is a true two-way query builder; a perfect choice for both SQL beginners and experienced query writers.


Current Release on 2007-07-11    1 people download

Pricing & Licensing

$195     

Standard VCL Edition without sources

$345     

Standard VCL Edition with sources

Overview

Main Features:

  • Completely visual building of complex SQL queries
  • MS Access and SQL Server style visual interface
  • Tree pane to browse and navigate query tree
  • Database objects tree pane to add objects to query
  • Sophisticated SQL parser translating any valid SQL statement into its visual representation (true two-way query builder)
  • Support of Oracle, MS SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, InterBase, Firebird and other SQL dialects.
  • Retrieving extended information about parameters: datatype, related object, field and operator
  • Building queries with objects from different databases
  • Pre-filtering of database objects to speed up metadata loading
  • Saving and loading all metadata information to XML format
  • Working in offline mode using metadata from XML file
  • Configuring the layout of generated SQL code
  • Localizing the component and Switching languages in run-time

  • Active Query Builder is a true two visual query builder component for Delphi and C++ Builder that allows your end-users to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful and user-friendly interface that allows you to build queries involving unions and sub-queries.
    The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and sub-queries make it the best solution for professional developers.
    Active Query Builder supports Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, and ANSI-92 SQL dialects.
    The sophisticated SQL parser with full Unicode support can translate any valid SQL statement into it's visual representation. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source.
    Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects. Using Active Query Builder you'll be able to retrieve various information about parsed query like lists of tables and fields used in the query. 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.
    Using the Active SQL Query Builder you can customize SQL code the way you like it.
    There are two editions available: the Standard Edition and the Free Edition. The Free Edition is fully functional, but supports only the ANSI-92 SQL dialect.

    Evals & Downloads

    download counts: 0

    Active Query Builder VCL Free Edition

    download counts: 1

    Active Query Builder Demo Application

    Send a question to Vendor