Downloads

Active Query Builder 3 WinForms Edition History

February 12, 2018

Active Query Builder 3 WinForms 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.
- The bug with the scroll bar in SQL Text Editor 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 WinForms 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.
- Closing the sub-query navigation popup after clicking on one of the 
  ellipsis action buttons has been fixed.
- Numerous fixes and improvements in the demo projects have been made.

January 26, 2018

Active Query Builder 3 WinForms Edition v.3.4.3.1078

+ Tooltip on the datasource caption is now displaying the description for
  database objects or the beginning of sub-query text for sub-queries.
= Expression Editor: The SQLFormattingOptions is a reference property now,
  not a contained object.
! SubQuery: Setting the LimitCount and LimitOffset properties is temporarily
  turned off.
- 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 WinForms Edition v.3.4.2.1077

+ Better visual style for the database schema tree has been made.
+ 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 WinForms 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.
= Properties panel: Captions for multiline editors are placed above the
  editor.
= Properties panel: Wrapping by words is turned on for multiline SQL
  expression editors.
- Database Schema Tree: The selection rectangle and focus frame around the
  focused node text, not around entire row
- Fields are checked on KeyDown now, not on KeyUp.
- The internal notification popup doesn't blink on startup anymore.
- Resizing of the Query Column List Control has been speeded up.
- SQL Text Editor: Black background at the bottom has been eliminated.
- .csproj files in the source code have been fixed.

January 03, 2018

Active Query Builder 3 WinForms 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 WinForms 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.
- Minor localizer bug has been fixed.
- SQL Text Editor: The bug with Undo operation has been fixed.

December 13, 2017

Active Query Builder 3 WinForms 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.
- Incorrect re-ordering of rows by drag'n'drop in the Query Columns Grid 
  has been fixed.

November 30, 2017

Active Query Builder 3 WinForms 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.
- The bug with black background in cell editors of the Query Column List on
  certain systems has been fixed.

November 27, 2017

Active Query Builder 3 WinForms Edition v.3.3.24.1071

- Restoring layout of datasources in the query after manual changing the
  query has been fixed.
+ The new "Go To Expression" context menu item has been added for 
  sub-queries in expressions.
+ New properties have been added to the AddObjectWindowOptions group: 
  Width, Height, Position, Location, ImageIndices.
= Query Column List: Conditions recognition and correction has been
  improved.
- User Queries Structure assignment has been fixed.
= The QueryStatistics.IsStatisticsValid flag has been hidden. 
+ Oracle: Batch fields and relations loading has speeded up metadata
  loading.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Firebird: Parsing of Aggregate functions has been fixed.
- The bug with dragging CTE from the query navigation bar to the Design 
  Pane has been fixed.
= References to DevExpress controls have been updated to the version 17.2.3.
- Other improvements and bug fixes have been made.