Downloads

Active Query Builder History History

February 17, 2018

Active Query Builder History 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.
- Custom context menu is displayed now for condition cells of the 
  Query Columns Grid.
- DevExpress: Cell context menu is now displayed in the proper position.

February 17, 2018

Active Query Builder History 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 History v.3.4.4.1080

= Direct references to third-party assemblies have been replaced with
  appropriate Nuget packages where it was possible.
- 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.

February 12, 2018

Active Query Builder History 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.

February 12, 2018

Active Query Builder History 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.

February 12, 2018

Active Query Builder History v.3.0.4

= The new client events AQB.Web.onQueryBuilderReady and
  AQB.Web.onCriteriaBuilderReady are added to replace the
  onApplicationReady event.
= The QueryBuilder.Logger and AqbHandler.Logger properties have been 
  renamed to Log.
= All configuration properties (getters) that must be defined through 
  the configuration file have been moved from the SessionStore class to 
  the appropriate handlers (BaseHandler, AqbHandler, ResourceHandler).
= Lots of minor fixes and improvements in HTML code and demo projects 
  have been made.
= Direct references to third-party assemblies have been replaced with
  appropriate Nuget packages where it was possible.
= Batch metadata loading is now more intelligent to avoid delays on getting
  the list of fields for the first requested table.
- 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.
- Several visual glitches have been addressed.
- Server memory leaks have been eliminated.

January 31, 2018

Active Query Builder History v.3.4.3.1079

= Code refactoring and clean-up has been made.

January 31, 2018

Active Query Builder History 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 31, 2018

Active Query Builder History 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 27, 2018

Active Query Builder History v.1.28.4

= Index numbers in ORDER BY are converted to corresponding expressions now.
= PostgreSQL parser has been optimized.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= FireDAC: Fetching of databases and schemas is supported now.
+ FireDAC The new TacFireDACMetadataProvider.LoadStoredProcedures property
  (default false) has been added. It instructs to load stored procedures
  from the driver. Turn it on only for the database servers which support
  using them in the FROM clause of the SELECT statement.