|
Active Query Builder now available!
The new component for Delphi and C++ Builder gives end-users the ability to build complex SQL queries visually.
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 functionality 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.
SQL Server, MySQL, PostgreSQL, Interbase/Firebird, and ANSI-92 SQL dialects support.
- Microsoft SQL Server. Active Query Builder supports various Transact SQL extensions, such as the TOP clause that limits the number of rows, table and join hints used by the query optimizer, the COMPUTE BY clause to generate summary.
- SQL Server 2005 support: the WITH clause to specify a temporary named result set (CTE), new types of query combinations, except UNION, EXCEPT and INTERSECT.
- PostgreSQL. Active Query Builder supports expressions with dollar-quoted strings, user defined data types, standard and user defined operators.
- MySQL. Active Query Builder supports all MySQL extensions, such as the Limit clause that limits the number of rows, the SELECT INTO OUTFILE/DUMPFILE forms, query options, locking definitions, subqueries for MySQL server version starting from 4.1.
Oracle, DB2, Informix, Sybase and even more dialects will be implemented next month.
Active Query Builder is a special component.
It wasn't created for some internal needs, it was made to meet customer needs. This is a component that was made by a team of enthusiast programmers to express their vision of the visual query building. All your comments and suggestions will be taken into consideration because we really want to make it the best tool possible.
Pricing and Availability
Active Query Builder Standard Edition has an estimated price of US$249 per license (with source included) or US$149 per license (without source included). There is also a freeware edition which is fully functional, but supports only the ANSI-92 SQL dialect. The information about other licensing options, as well as further details on pricing, upgrade and support policies, is available online at www.activequerybuilder.com.
About Active Database Software
Active Database Software, Ltd. is a privately owned software development company headquartered in Chelyabinsk, Russia. Established in 2005, Active Database Software offers solutions for professional database developers. We are a professional software-development company and we are highly concerned with the quality of our software and services. Moreover, our team constantly works at developing and improving our service performance to satisfy our customers and maintain long-term cooperation with them. We hope that all of our customers and partners are satisfied with the quality of our products and services. As our client you will appreciate the high quality of our software!
|
Company: Active Database Software
| Related press releases |
Active Query Builder ActiveX Edition now available! [2005-12-05 00:00:00]
The new COM/ActiveX component gives end-users the ability to build complex SQL queries visually.
Yekaterinburg, Russia (November 26, 2005) - Active Database Software, a company that offers solutions ...
|
|
Active Query Builder now available! [2005-09-26 00:00:00]
The new component for Delphi and C++ Builder gives end-users the ability to build complex SQL queries visually.
Yekaterinburg, Russia (September 26, 2005) - Active Database Software, a company that o...
|
|
FastQueryBuilder (FQB) is a visual query builder. You can use FQB in your applic... [2005-09-16 00:00:00]
FastQueryBuilder Is The Answer To SQL Query Development
Fast Report, Inc., a leader in the production of programming tools for Borland Delphi Environment and C++, introduces FastQueryBuilder, a visua...
|
|
Advanced Soccer Stats Query System for Scoring Soccer Players [2004-02-05 00:00:00]
web-based databank, ScoringSoccer.com, has been developed for the soccer industry to record, store, query, and retrieve data quickly.
February 5, 2004 -- A web-based databank, ScoringSoccer.com, ha...
|
|
Resource Builder [2005-08-20 00:00:00]
August, 2005 for Immediate Release
SiComponents Releases Resource Builder 2.3.3
New developer tool creates, edits, imports and compiles resource files in seconds.
Resource Builder is a toolset that ...
|
|
Aspose.AdHoc 1.3 released! [2005-07-25 00:00:00]
Aspose.AdHoc is a ASP.Net component. With the Ad Hoc Query Builder component you can quickly and easily add ad hoc capabilities to you ASP.Net application. The ad hoc component can be used for a varie...
|
|
Wondershare Flash Slideshow Builder V1.8.0 [2005-12-19 00:00:00]
Dec. 19, 2005 - Wondershare Corporation announced the release of Flash slideshow Builder 1.8.0, a new update to the company's popular slide show presentation software. Flash slideshow Software 1.8.0 b...
|
|
Unity Delivers UTB a New Query Tool [2004-09-24 00:00:00]
Unity announces the launch of the UTB (Universal Table Browser) a ODBC based graphical query tool. The UTB has been optimised to cater for the largest of databases which can have thousands of tables t...
|
|
OpenGate Software Inexpensive Business Intelligence for Microsoft® Access with ... [2008-03-03 02:46:29]
Denver, CO, February 28, 2008 - OpenGate Software, provider of Microsoft Access application tools, announced today the general availability of Dashboard Builder, which offers Microsoft Access users a ...
|
|
Wondershare DVD Slideshow Builder 3.5.0 with 3D transition effects featured [2007-09-03 16:19:23]
Wondershare DVD Slideshow Builder 3.5.0 with 3D transition effects featured
Sep. 1st, 2007 Wondershare Inc., the global award-winning provider of multimedia software for digital photographic & vid...
|
|
|
|
| DDQM |
 Excellent Query Management tool for DBISAM 4 Users. Complete with Categorization, Syntax Coloring, Live Result Editing, One-Click Export to MS Excel, and much, much, more. |
|
| NET Reports Server PRO |
 NET Reports 2.0 Server - a Internet ready application; Fast Query & Report solution for Ms.Sql Server, Oracle, PostGreSql, MySql, Interbase, Firebird, MS. VFP. Sybase, MS. Access; Free client software from http://www.net-reports.net/downloads.html |
|
| Amara Flash Intro and Banner Builder |
 Amara Flash Intro and Banner Builder is the ultimate Flash text effect tool to help the web designer create and design flash animations. |
|
| MP3 EZlib Music Library/Playlist Manager |
 EZlib is a Free MP3 Music Library/Playlist Manager featuring custom-query on 14 ID3v2 tag fields and file dates; single and mass ID3v2 Tag updating; 4 user-defined custom ID3v2 fields; add/delete pictures; runtime playlist tweaking; automatic lyrics |
|
| Pure SEO CMS |
 Fast, powerful, SEO website builder, optimized CMS, CSS compliant. Fast, client side XML to html engine. Beginners enter content and select design. Experts use their own templates and save time building high quality sites . No online server required. |
|
|
Latest press releases
