Active Query Builder 3 WinForms Edition History

June 23, 2017

Active Query Builder 3 WinForms Edition v.3.3.11.1058

+ SQL Text Editor: The new LoadMetadataOnCodeCompletion property has been
  added. It prescribes to load metadata if it hasn't been loaded yet on
  displaying the suggestion popup list.
! The bug with loading of conditions joined with OR has been fixed.
  They were converted to AND in some cases.
- Query Transformer: The bug on transforming the query with a stored 
  procedure has been fixed.
- Loading of foreign keys has been fixed.
- Other minor bugs have been fixed.

June 16, 2017

Active Query Builder 3 WinForms Edition v.3.3.10.1057

! The bug that caused slow initialization of the component, especially on
  the large database schema has been fixed. 
= The MetadataItem.FindItems(filter, type) method now takes
  the filter.ObjectType property into account.
= MetadataObject.Expression property setter now checks expression for
  recursion loops. 
- The bug with quotation of incorrect SQL expressions with double quotes
  instead of apostrophes has been fixed.

June 09, 2017

Active Query Builder 3 WinForms Edition v.3.3.9.1056

+ The new events are added to track addition and removal of items in the
  Query Columns List. 
  QueryColumnListControl: ItemAdded and ItemRemoving;
  QueryBuilder: QueryColumnListItemAdded, QueryColumnsListItemRemoving.
- Commands for adding and managing sub-queries in expressions are moved to
  the context menu of appropriate cells. The ellipsis button now immediately
  displays the Expression Editor.
- IBM DB2: Database objects are now loaded from the server if loading from
  driver fails.

June 02, 2017

Active Query Builder 3 WinForms Edition v.3.3.8.1055

- The critical bug with loading of top-level AND conditions has been fixed. 
+ The new DisableQueryNavigationBarPopup property has been added to the
  QueryBuilder.PanesConfigurationOptions group.
+ The new IDatabaseSchemaView.SQLGenerationOptions property has been added
  to alter displaying of object names in the tree. 
+ Database connection logging is possible now.
- Hiding of columns in the Query Transformer hadn't get applied immediately.
  Fixed now. 
- MS SQL Server: Object name is now used as default alias for objects from
  linked servers. 
- The MetadataStructureItem.GetDisplayCaption method has been speeded up.

May 26, 2017

Active Query Builder 3 WinForms Edition v.3.3.7.1054

= Conditions for the same left part joined using the OR operator are merged
  into a single cell now.
- IBM DB2: The method to retrieve the list of schemas now falls back to SQL
  query if loading from driver returns no schemas.
- Referencing objects for User Queries aren't loaded now.

April 28, 2017

Active Query Builder 3 WinForms Edition v.3.3.6.1053

= ODBC Metadata Provider: Better detection of servers that don't support
  schemas has been made.
= SQL 92 Syntax Provider allows empty schema names now.

April 25, 2017

Active Query Builder 3 WinForms Edition v.3.3.6.1042

- Dependent options in the properties sidebar panel are correctly enabled
  now upon changing the main property.
- The bug with incorrect caret position, when word wrapping is turned on,
  has been fixed.

April 18, 2017

Active Query Builder 3 WinForms Edition v.3.3.5.1041

- SQL Text Editor: The ValidateContextMenu event has been fixed.
+ MySQL: Support of MATCH full-text search operator has been made.
= IBM DB2: The new DB2SyntaxProvider.ObeySchemaListFromDriver property has
  been added to ensure the priority of the list of objects received from 
  the metadata provider (True by default).
- IBM DB2: The bug with selecting table schema instead of table owner 
  for schema name has been fixed.
- The reference to MySql.Data assembly in MySQL metadata provider has been 
  updated to the version 6.9.9.

March 24, 2017

Active Query Builder 3 WinForms Edition v.3.3.4.1040

+ Captions on the Criteria Builder UI have been improved.
- DevExpress UI: After dragging a table object onto the Design Pane, a box
  flashed at two separate locations before the table object is positioned
  where it is dropped. Fixed now.
- DevExpress UI: The Link properties dialog drawing problem has been fixed.
- DevExpress UI: Dragging columns up and down in the Query Columns List has
  been fixed.
- DevExpress UI: The problem with drawing of SQL Text Editor background has
  been fixed.

March 21, 2017

Active Query Builder 3 WinForms Edition v.3.3.3.1039

= Database Schema view in the Expression Editor is now grouped by database
  and schema.
- The bug with grouping database objects by type has been fixed.
- Properties dialogs were inoperable if there's no Properties sidebar on 
  the form. Fixed now.
- DevExpress UI: The bug with the folder icons in the Database Schema Tree
  disappearing after collapsing has been fixed.
- DevExpress UI: Background color in the SQL Text Editor has been fixed.
- DevExpress UI: Renaming of user queries has been fixed.
- DevExpress UI: Keyboard shortcuts in the Query Columns Grid have been
  fixed.
- The DevExpress Separated Components demo project has been fixed and
  improved.

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:

Tweets