Active Query Builder 1.0 now available!
Posted on 2005-09-29
Posted by firstname.lastname@example.org
Yekaterinburg, Russia (September 26, 2005)
Database Software, a company that offers solutions for
professional database developers, announced today the release
of the new visual query builder component suite for Borland
Delphi and C++ Builder that allows your end-users to build
complex SQL queries via the intuitive visual interface. 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 graphical engine that allows you to build queries
involving unions, nested joins and subqueries.
MS-Access style and SQL Server style query building visual
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
subqueries make it the best solution for professional
Integration with Delphi or C++ Builder applications is
achieved by setting a few properties or writing a few lines of
The component may be integrated into a Delphi or C++ Builder
application with just a few lines of code. Unlike many other
query building solutions for Delphi, Active Query Builder does
not force the programmer to use the embedded data grid, SQL
editor or anything else. Instead, it allows you to integrate
any accompanying tools into your application as quickly and
easily as possible.
Sophisticated SQL parser will translate any valid SQL
statement into its visual representation.
Active Query Builder gives you full control over the SQL query
- you can easily navigate it using the internal query builder
objects tree that represents all parts of the SQL query. Also
you can edit existing queries or create new SQL queries using
these objects in run-time.
Full line of database connectivity Delphi components and
generic event-driven driver.
We are planning to create metadata providers for all popular
database connectivity components but, of course, we cannot
cover them all. Thus we created the generic event-driven
metadata provider. You can use it to provide metadata
information from any data source. It's quite simple and has
just a few events to implement. Using the generic event-driven
metadata provider you can work disconnected providing all
necessary metadata information by yourself.
Text, RTF and HTML export filters.
Using the Active Query Builder output filters you can transform
SQL code into the format you need, customized 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.
Learn more at www.activequerybuilder.com