Active Query Builder News

October 24, 2005

Active Query Builder 1.1 released

We're glad to announce the new minor version of Active Query Builder. You can download the newest version from the download page.

What's new in Active Query Builder 1.1?

  • Oracle dialect supported (versions from 7 to 10) (TacOracleSyntaxProvider).
  • New metadata provider for Core Lab Oracle DAC added (www.crlab.com/odac).
  • New metadata provider for Core Lab MySQL DAC added (www.crlab.com/mydac).
  • Added optimization of arrangement of tables within the FROM clause to avoid CROSS JOINs.
  • Fixed bug with wrong quotation of SQL Server function names.
  • MySQL InnoDB tables weren't linked automatically. Fixed now.
  • Several minor bugfixes and improvements.
» All Active Query Builder news

Tweets

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.

Screenshots

Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.


Active Query Builder Screenshots

Social networks

Active Query Builderon Google+