Downloads

Active Query Builder History History

April 23, 2014

Active Query Builder History v.1.23.0

+ Asyncronous metadata loading support is made.
+ MS SQL Server: MS SQL Server 2014 is supported.

- MS SQL Server: method call chain parsing is fixed.
= MS SQL Server: keywords list is updated.
+ PostgreSQL: WITH clause support is made.
= PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object
  columns (formerly used "LIMIT 1").
+ Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed.
+ Oracle: Interval expressions are supported now.
= DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are
  supported now.
= DB2: Short object names are used in case of SYSTEM naming convention.
- MySQL: DATE and TIME types parsing ambuiguities fixed.

April 23, 2014

Active Query Builder History v.1.23.0

+ RAD Studio XE6 support is added.
+ Connection cloning and asyncronous SQL execution is possible now.
+ Asyncronous metadata loading support is made.
+ MS SQL Server: MS SQL Server 2014 is supported.

- MS SQL Server: method call chain parsing is fixed.
= MS SQL Server: keywords list is updated.
+ PostgreSQL: WITH clause support is made.
= PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object
  columns (formerly used "LIMIT 1").
+ Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed.
+ Oracle: Interval expressions are supported now.
= DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are
  supported now.
= DB2: Short object names are used in case of SYSTEM naming convention.
- MySQL: DATE and TIME types parsing ambuiguities fixed.

April 21, 2014

Active Query Builder History v.2.3.0

+ Keyboard navigation over the web controls is possible now.
  To turn on, link the "accessibility.css" and "accessibility.js" files from
  the "web-parts" folder to your web page.
  Use the "1" to "5" keys to switch between main parts of the component:
  database schema tree, sub-query navigation bar, design pane, query columns
  grid and query text editor. Use Tab and Shift-Tab keys to navigate over the
  controls. Use Enter to step into the sub-items of complex controls: datasource
  field lists, and cells of the query columns grid.
+ Accessibility demo is added.
- CSS compatibility with jQueryUI themes is improved.

April 16, 2014

Active Query Builder History v.2.8.0.649

+ It is now possible to set different color for focused links using the
  QueryBuilder.DesignPaneOptions.LinkStyle.LinkColorFocused property.
= Virtual objects now obey UseAltNames property on virtual fields expansion phase.
= The source code of Query Modification Demo project is refactored.

April 14, 2014

Active Query Builder History v.2.2.8

- The Client Events Handling demo project is fixed.
- Drag'n'drop from the structure tree is improved
- Reconnect mechanism in the MultipleQueriesPerSession mode is improved.
= ActiveDatabaseSoftware.ActiveQueryBuilder2.dll is updated to v.2.8.0.647. 

April 11, 2014

Active Query Builder History v.2.8.0.647

+ Support for MS SQL Server 2014 is added.
+ The tool to conver metadata XML from the old v.1.x format to new is 
  available as .NET assembly ActiveDatabaseSoftware.MetadataXmlConverter.dll.
+ Quick Search in the Database Schema Tree is now able to search by field 
  names. Use the new property DatabaseSchemaTreeOptions.SearchFields to enable
  this feature.
= Database Schema Tree now emphasizes the search string with underscore.
- Add Object Form: The Enter key press response in the object list is fixed.
- DevExpress Controls Factory: Non-default tree sorting modes are fixed.
- OLE DB Metadata Provider: MetadataField.FieldType loading is fixed.
- MS SQL Server syntax: Parsing of method call chain is fixed.
- MySQL: DATE and TIME types parsing ambuiguities are eliminated.
- DB2, MySQL, PostgreSQL and ANSI SQL standards: DATE, TIME and TIMESTAMP
  literals are supported now.

April 09, 2014

Active Query Builder History v.2.2.7

- The bug with updating joins is fixed.
+ ActiveDatabaseSoftware.ActiveQueryBuilder.MetadataXmlConverter.dll is
  added to let programmatic conversion of old v.1.x metadata XML schema to
  the new format.

April 02, 2014

Active Query Builder History v.2.7.5.645

+ The new BehaviorOptions.NotifyOnLinksCreatedAutomatically property is added 
  to let track addition of automatically created links (by foreign keys or by
  identical field names) using the LinkCreated event.

April 01, 2014

Active Query Builder History v.2.7.4.644

- OLE DB Metadata Provider: Incorrect column order when loading metadata from
  Excel file via Microsoft ACE 12.0 OLE DB Provider is fixed.
= Documentation is updated.

April 01, 2014

Active Query Builder History v.2.2.6

= Diagram links drawing is improved.
- Minor GUI bug is fixed.

Product Summary

 Active Query Builder WinForms .NET Edition:


 Active Query Builder WPF .NET Edition:


 Active Query Builder ASP.NET Edition:


 Active Query Builder Java Edition:


 Active Query Builder ActiveX Edition:


 Active Query Builder VCL Edition:

News

Tweets

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks