Active Query Builder for .NET WinForms v3.5.xx.x

Released: Aug 25, 2019

v3.5.xx.x での更新項目


Updated Jan 13, 2020

  • Oracle: Minor bug in the QueryTransformer is fixed. Column prefixes for inner queries are preserved now.
  • SQL Formatting Options frames are added to the VB.NET Full-Featured MDI demo.


Updated Dec 31, 2019

  • SAP Hana & ANSI Standard SQL Syntax: Support for the standard TRIM(LEADING/TRAILING ...) builtin function is added.
  • Oracle: The bug with loading objects from the PUBLIC schema is fixed.
  • Oracle: Paging using the ROWNUM function in Oracle 11g and lower is fixed.
  • MySQL: Parsing of the MATCH full-text search expression is fixed.


Updated Dec 13, 2019

  • The new helper method QueryColumnListItem.CreateAliasIdentifier has been added to get a column name from the alias.
  • Query Column List: The 'Sort Order' column name has been corrected.
  • The Null Reference Exception on loading OR conditions with brackets has been eliminated.
  • Auto Syntax Provider: The Null Reference Exception on disposing of referencing objects has been fixed.
  • Quotation of aliases and other identifiers with alternate quotation symbols has been corrected.
  • The bug with adding HAVING conditions using the QueryColumnList.AddCondition helper has been fixed.


Updated Nov 22, 2019

  • References to DevExpress assemblies have been updated to version 19.2.
  • Query Columns List: Handling of incomplete strings in expression cells has been improved.
  • The missing method ISqlTextEditor.GetOffsetFromPoint has been restored.
  • New helper method has been made to add conditions to WHERE or HAVING: UnionSubQuery.QueryColumnList.AddCondition(ConditionType conditionType, string condition).
  • PostgreSQL: Support for WITH clause in subqueries has been added.
  • MS SQL Server: Parsing of ordinal named parameters ("@0") has been restored.
  • DevExpress: DatabaseSchemaTree nodes expansion has been fixed.


Updated Nov 11, 2019

  • The new helper is made to get the SQL text with custom formatting: The GetSQL(SQLGenerationOptions) method is added to QueryBuilder, SQLQuery, and QueryRoot objects.
  • The structure of conditions in the query is preserved better now after the parsing.
  • The UNIQUE keyword is now recognized and saved correctly.


Updated Nov 1, 2019

  • Saved Queries widget: The bug with items deletion has been fixed.
  • Full-Featured MDI Demo: Metadata filter editor has been fixed.


Updated Oct 29, 2019

  • The bug with quoted names in "simple" metadata filters has been fixed.


Updated Oct 22, 2019

  • PostgreSQL: Support for the "DISTINCT ON ()" clause has been added.
  • VistaDB: The new metadata provider for VistaDB 6 has been added.
  • Usage of one MetadataStructure as an item in another MetadataStructure is possible now. This allows building a tree with objects from different database connections.
  • Generic Syntax Provider: Datasource loading has been sped-up.
  • Informix: Support for sub-queries has been fixed.
  • Generic Syntax Provider: loads metadata from Oracle fine now.


Updated Oct 12, 2019

  • Database Schema Tree: The expansion of nodes with many children has been sped up.
  • Informix: Support for new built-in functions (LEFT, RIGHT) has been added.
  • Informix: Support for derived tables for IDS11+ has been made.
  • PostgreSQL: Comparison operators precedence has been corrected.


Updated Oct 1, 2019

  • References to DevExpress assemblies are updated to v.19.1.6.
  • PostgreSQL: Handling of "partial" expressions like "=1" is improved.


Updated Sep 25, 2019

  • Informix: Objects from all schemas can be used without schema prefix.
  • The bug with extra fields for materialized views has been fixed.
  • The new Alt+Enter shortcut has been added to open the Expression Editor from the Query Column List Control (the previous Shift+F2 shortcut still works).
  • QueryColumnListItemChanging and QueryColumnListItemChanged events are fired now for new items too.
  • Editor for the deprecated DefaultExpandLevel property has been removed from all Basic demos.
  • Scaling fixes have been made.


Updated Aug 25, 2019

  • Metadata Container Editor: A tooltip and a button are added to show/hide the metadata structure tree.
  • Metadata Container Editor: Minor fixes are made.
  • The Favourites folder node is not removed now from the Metadata Structure tree on clearing.
  • Metadata Container Editor: The bug with loading metadata from Oracle is fixed.