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

Released: Aug 25, 2019

v3.5.x での更新項目


Updated Mar 20, 2020

  • Users can now apply conditions to expression values (in the WHERE clause) for an aggregated column. (choose "For values" in the "Criteria for" column).
  • The "Grouping" flag is no longer set for a newly added column on adding it to the query by double-clicking on a field in the Design Pane.
  • Fixed the bug with not displaying the link creation buttons in datasources in the Design Pane when fields are custom-drawn using the FieldListDrawItem event.
  • Query Transformer: Fixed the bug with not quoting column aliases when needed.
  • Fixed the bug with adding an incorrect CTE item from the Sub-query Navigation panel.
  • SAP Hana: Added support for the PLACEHOLDER clause.
  • SAP Hana: Corrected the TRIM function syntax.


Updated Mar 8, 2020

  • Added the missing Japanese localization.
  • Added new MetadataItem.Connection property to support the work with MetadataContainer consolidating items from different DB connections.


Updated Feb 28, 2020

  • SQLite: Support for window functions, analytic expressions, and the FILTER clause has been added.
  • PostgreSQL: Support for the FILTER clause is added and the bug with the PRECEDING clause is fixed.
  • SQL Text Editor: The missing methods ShowSuggestionWindow and HideSuggestionWindow are added.
  • Teradata, ANSI SQL/89: Keywords and functions are added to the suggestion list in the SQL Text Editor.
  • SQLite, Teradata, Generic: Support for the REPLACE function is added.
  • The QueryColumnListItem.AddExpression method now fires an exception on adding an incorrect SQL expression instead of displaying an error to the user.
  • The Ctrl+Alt+Insert hotkey command in the Query Column List control has been fixed.
  • The bug with displaying field names on the design pane in the right-to-left mode has been fixed.
  • Other minor bugs are fixed.


Updated Feb 14, 2020

  • SAP Hana: Filters are now applied to the metadata fetching process.
  • Server version is detected by default now for Oracle, SQL Server, MySQL, Sybase, and Informix.
  • SAP Hana: The list of keywords has been updated.
  • Oracle: Metadata loading has been sped up.
  • Oracle: Stored procedure fields are correctly loaded from the server now.
  • Duplicated GROUP BY items are handled correctly now.
  • DevExpress: The exception arose by deleting a data source from the Design pane has been eliminated.


Updated Feb 5, 2020

  • SAP Hana: Support for TOP clause has been added.
  • SAP Hana: Parsing of CURRENT_UTC* constants is fixed.
  • The Basic demo has been improved.
  • The new type of namespace has been added: Connection.
  • The new ConsolidatedMetadataContainer demo is made to provide sample of loading objects from several DB connections.
  • Installer: It is now possible not to uninstall the previous version.
  • Installer: The request to elevate rights emerges now.
  • Database Schema View: Database Exceptions on expanding nodes are properly handled now and displayed to the user.
  • Database Schema View: The wait label is now displayed during the load of search results.
  • Database Schema View: The bug on adding an object to Favorites from the search results has been fixed.
  • ODBC metadata properties form: Properties are applied correctly now.
  • Other minor bugs are fixed.


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.