Active Query Builder News

February 22, 2006

Active Query Builder ActiveX Edition 1.3 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 the Active Query Builder ActiveX Edition version 1.3?

  • The new LayoutSQL property is added to store layout of currently builded query (position of database objects within the Query building area) in XML format. Read this property to retrieve SQL and its layout from the component; write back to this property to restore previously saved XML.
  • The new Clear method is added to empty currently builded SQL query at a time.
  • We have speeded up the process of retrieving fields of database objects.
  • Predictive input is implemented for all inplace combo-box editors in the Columns pane.
  • Now properties TableNodeVisible, ViewNodeVisible and ProcedureNodeVisible have an effect on tabs of the Add Object Window.
  • The new ColumnWidthExpression property is added to define initial width of columns in the Columns pane.
  • Fixed bug with impossibility to register OCX on chineese Windows edition.
  • Fixed bug in VB6 with multiple messages "Cannot focus to disabled or invisible window".
  • Fixed AV on assigning incorrect SQL statement to the SQL property.
  • Removing a table from the Query building area didn't lead to removing corresponding rows in the Columns pane. Fixed now.
  • Other 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+