Downloads  »  Active Query Builder 3 WinForms Edition History

April 12, 2019

Active Query Builder 3 WinForms Edition v.3.5.14.1126

Below is the list of fixes and improvements in Active Query Builder 3 WinForms Edition v.3.5.14.1126.

+ Query Columns List: A drop-down button is displayed now in Criteria column
  cells to suggest allowed logical operators to start building a condition.
= Query Columns List: The drop-down list for empty or fully selected Expression
  cells is now filled with fields from tables in the current sub-query, grouped
  by tables.
+ Query Columns List: When object or namespace is selected from the suggestion
  list in Expression cell *by mouse*, a dot is added automatically, so another
  suggestion is shown right after that for easier field selection of fields by 
  mouse.
= Query Columns List: Multiple rows selection by mouse and reordering of rows
  by drag'n'drop made easier now.
= Design Pane: Double click on a named query datasource header now switches
  the Design Pane to this named query.
= Subquery Navigation Bar: Minor usability fixes in managing subqueries joined
  with set operators (unions) are made.
= SQL formatting fixes and improvements have been made.
- The bug with incorrect saving of collapsed objects via the LayoutSQL
  property has been fixed.
- Pervasive: The bug with parsing of some built-in functions has been fixed.
= MS SQL Server: The UseObjectNamesAsDefaultAliases attribute is turned on.
  This has allowed for less-qualified fields names generation.
+ SQL Text Editor: The new SqlTextEditor.FillCustomSuggestions event has been
  added to add own suggestions before the list gets populated in a usual way.
= The SqlTextEditor.ActiveUnionSubQuery property is renamed to
  ExpessionContext.
= SQLQuery: The AddForeignKeyLinksForObject and AddLinkedObjectsFor methods
  are made public. The first method joins the specified datasource to existing
  objects in subquery if foreign key relationships exist between them.
  It returns the number of created joins. The second method adds intermediary
  objects to the subquery to get the specified datasource joined with the
  others and joins them appropriately.
- The bug with scrolling the PropertiesBar control has been fixed.
- The bug with drawing links for foreign key-based joins if alternate names 
  are used has been fixed.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder 3 WinForms Edition at the download page.

» Full Active Query Builder 3 WinForms Edition history