Yekaterinburg, Russia (September 26, 2005) - Active 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 interface.
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 developers.
Integration with Delphi or C++ Builder applications is achieved by setting a few properties or writing a few lines of code.
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.
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.