Downloads

Active Query Builder 3 WPF Edition History

February 17, 2018

Active Query Builder 3 WPF Edition v.3.4.5.1081

= The new field QueryColumnListControl.HitTest.ConditionIndex has been added. 
  It allows determining the corresponding item in the query object model.
- Criteria Builder: Minor fixes and improvements have been made.
- SQL Text Editor: The bug with deleting the text next to a parenthesis has 
  been fixed.
- Bounds and collapsed state in the layout data are saved correctly now.
- Metadata Structure: The bug with grouping items by database object type has
  been fixed.
- Teradata: Addition of datasources to design pane has been speeded up.
- MySQL: Support of STDDEV function has been fixed.

February 12, 2018

Active Query Builder 3 WPF Edition v.3.4.4.1080

+ The abilities to display the text and preview result of the currently
  active sub-query have been added to all of the Full-featured demo
  projects.
= Numerous fixes in the Full-featured and General demo projects have been
  made.
= Direct references to third-party assemblies have been replaced with
  appropriate Nuget packages where it was possible.
+ The new properties have been added to the DatabaseSchemaViewOptions to
  tune the look of Database Schema Tree: DrawTreeLines,
  ImageIndices.ExpandedNodeImageIndex, ImageIndices.CollapsedNodeImageIndex.
= The new property SqlTextEditor.ChangeFontSizeByMouseWheel has been added
  to allow changing the font size by mouse wheel while holding the Ctrl key
  down. It is set to True by default.
- The bug with restoring layout for non-existing elements has been fixed.
- Computation of primary and foreign keys field lists has been fixed.
- The bug with deserializing complex metadata structure has been fixed.
- The bug with grouping database objects in the tree by types has been
  fixed.
= Batch metadata loading is now more intelligent to avoid delays on getting
  the list of fields for the first requested table.
- The bug in Expression Editor with scrollbars always visible has been
  fixed.

January 31, 2018

Active Query Builder 3 WPF Edition v.3.4.3.1079

= The new QueryBuilder.GetDataSourceCaptionToolTipText event has been added.
= Properties Bar: Size of property editing controls is corrected to suit the
  container panel better.
- Properties Bar: NRE on setting invalid link expression has been
  eliminated.
- The bug with displaying namespaces twice in the combo-box in the Add
  Object Window has been fixed.
- Numerous fixes and improvements in the demo projects have been made.

January 26, 2018

Active Query Builder 3 WPF Edition v.3.4.3.1078

+ Tooltip on datasource caption displaying the description for database
  object or the beginning of sub-query text for sub-queries.
= It is now possible ability to resize datasources on Design Pane by
  dragging their left and top borders.
- The bug with eating the first mouse click on the Design Pane has been
  fixed.
= Expression Editor: The SQLFormattingOptions is a reference property now,
  not a contained object.
! SubQuery: Setting the LimitCount and LimitOffset properties is temporarily
  turned off.
- The bug on clicking the suggestion window hint has been fixed.
- Search in the Database Schema View with custom metadata structure has been
  fixed.
- Sub-queries from the "IN (SELECT ...)" conditions are displayed on the
  Query Navigation Bar now.
- The ConditionalOperatorsFormat.NewLineBeforeWhen property has been fixed.
= PostgreSQL parser has been optimized.
- Several minor bugs have been fixed.

January 22, 2018

Active Query Builder 3 WPF Edition v.3.4.2.1077

+ The new property QueryBuilder.DatabaseSchemaViewOptions.DrawTreeLines
  controls drawing of tree lines between nodes of the database schema tree.
+ The component is now asking for deleting sub-queries. 
= Various SQL expression error reporting improvements have been made.
+ The new UserInterfaceOptions property group has been added to the 
  QueryView and QueryBuilder classes.
  The QueryBuilder.UserInterfaceOptions.ConfirmSubQueryDeletion property
  prescribes to display the confirmation dialog on deleting a sub-query.
  The QueryBuilder.UserInterfaceOptions.WarnAboutSQLExpressionErrors 
  property instructs to display popup window when the user makes a syntax
  error in SQL expression.
+ Expression Editor: SQL expressions are formatted now according to the 
  settings of the new SQLFormattingOptions property.
= Expression Editor: Monospace font is used by default now.
= Index numbers in ORDER BY are converted to corresponding expressions now.
- Numerous fixes and improvements to the Query Properties Bar and SQL Text 
  Editor have been made.
+ Oracle: Loading of stored procedure parameters from the server system 
  catalog is supported now.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= New and missing localizable strings have been added.
- Localization fixes have been made.

January 12, 2018

Active Query Builder 3 WPF Edition v.3.4.1.1076

= SubQuery.Caption property returns localized caption for the main query.
= Default namespaces aren't shown in datasource captions now.
- Metadata Structure: Grouping by types at the top level has been fixed.
= Only the simple WHERE clause conditions like "field1 = field2" are loaded
  as links now.
- Generation of offset in the LIMIT expression has been fixed.
- Loading of reusable queries has been fixed.
- Properties panel: Properties for the focused query element weren't shown
  on the first activation. Fixed now.
- Auto-scroll of Design Pane on clicking a datasource has been corrected.
- Mouse capture of the Query Column List cells with combo box editor has
  been fixed.
- Mouse click on checkboxes in the Query Columns List has been fixed.
- Popup error message in demo projects doesn't stay on top after switching
  to another application.
- The Clear button is greyed now if there's no text in the Search textbox 
  of Database Schema View.
- .csproj files in the source code have been fixed.

January 03, 2018

Active Query Builder 3 WPF Edition v.3.4.0.1075

+ SQL expressions error handling.
+ Query inconsistency alerts.
+ Easy addition of linked objects to the query.
+ Search and filtration in field list of objects on Design Pane.
+ Keyboard shortcuts in Design Pane.
+ Metadata loading acceleration.
+ Other improvements.

December 29, 2017

Active Query Builder 3 WPF Edition v.3.3.26.1074

	
+ On-demand metadata loading improvements have been made to speed up field
  list retrieval when adding a new object to the query.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- SQL Text Editor: The bug with Undo operation has been fixed.

December 13, 2017

Active Query Builder 3 WPF Edition v.3.3.25.1073

+ Sybase: Support for window functions has been added.
= User Queries: Exception is thrown now if query expression has output
  column names conflicts.
= Teradata: Minor metadata loading improvements have been made.
- SQL Text Editor: The bug with caret position after removing a character
  and scrolling has been fixed.
- SQL Text Editor: The bug with the content of suggestion window not taking
  the last input character into account has been fixed.
- Loading of stored procedure parameters from metadata XML files has been
  fixed.
= Fields in datasources can be checked with the space key now.

November 30, 2017

Active Query Builder 3 WPF Edition v.3.3.24.1072

- Query Transformer: Applying both pagination and sort order has been fixed.
= SQL Text Editor: "Dual" has been added to the list of suggestions for
  Oracle.