Downloads

Active Query Builder 3 WPF Edition History

April 09, 2018

Active Query Builder 3 WPF Edition v.3.4.9.1086

- SQL Text Editor: The bug with incorrect word wrapping has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins now results in the
  parsing error.
- IBM DB2: NULL is parsed now as a constant, not as an identifier.
- MS SQL Server: Parsing of qualified names with skipped components has 
  been fixed.
- MS SQL Server: Loading of fields for linked servers without database or
  schema has been fixed.

April 02, 2018

Active Query Builder 3 WPF Edition v.3.4.8.1085

+ The new property DataSourceOptions.CheckboxesVisible lets turn off
  checkboxes in datasource field lists.
= Expression Editor: Focus is now set into the text editor after insertion
  from suggestion lists.
= Support of theming has been improved.
- Several unhandled exceptions have been eliminated.

March 07, 2018

Active Query Builder 3 WPF Edition v.3.4.7.1084

= Sqlite: Keywords list has been filled.
= Full-featured demo projects: SQL Syntax detection and changing is 
  possible now for ODBC and OLE DB connections.
= Detection of installed OLE DB providers suitable to work with MS Access
  has been made.
= The new Expression Editor Demo has been added to the trial installation
  package.
= The General Demo has been renamed to Basic Demo.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
- Criteria Builder: The bug with creating filter items for empty general
  conditions has been fixed.
- SQL Text Editor: Minor suggestion list fixes have been made.
- Minor bugs and improvements in the Query Column List control have been
  made.

March 02, 2018

Active Query Builder 3 WPF Edition v.3.4.6.1083

+ The new Expression Editor demo project has been added. It demonstrates
  the internal structure of the ExpressionEditor component.  
= SQL Text Editor: Minor auto-completion improvements have been made.
= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
- The bug with displaying multiline string literals on a single line has
  been fixed.
= Logging of the stored procedure params loading has been improved.
- Query Column List Control is responsible now with the first mouse click.
- The NullPointerException when leaving empty condition item in  the Query
  Columns List has been fixed.
- Expression Editor: Minor visual fixes and improvements have been made.

February 19, 2018

Active Query Builder 3 WPF Edition v.3.4.5.1082

- Minor fixes have been made.

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.