Softpedia >Windows >Programming >Components & Libraries >Active Query Builder .NET Edition >  Changelog

Active Query Builder .NET Edition Changelog

What's new in Active Query Builder .NET Edition 3.11.3 Build 2252

Apr 26, 2024
  • MS SQL Server: Inappropriate functions are removed from suggestion list.
  • The crash on completing a suggestion with the Tab key at the end of the text is eliminated.

New in Active Query Builder .NET Edition 3.11.2 Build 2251 (Mar 25, 2024)

  • Text Editor: Exceptions on pasting text from the clipboard are suppressed now.
  • Text Editor: Exceptions on copying text to the clipboard are suppressed now.

New in Active Query Builder .NET Edition 3.11.0 Build 2249 (Mar 14, 2024)

  • Edition-based suffixes are added to NuGet package names to prevent unintended upgrade to new Trial edition packages from nuget.org site.
  • Trial: (no suffix), Standard: ".Std", Professional: ".Pro", Corporate: ".Corp". Please update package references according to the edition you use in your vbproj/csproj file.
  • Restoring the Collapsed property when user loads the LayoutSQL is fixed.

New in Active Query Builder .NET Edition 3.9.12 Build 2244 (Jul 15, 2023)

  • PostgreSQL: Partitioned tables are fetched now on schema load.
  • Duplicate alias detection for case-sensitive SQL syntaxes is corrected.

New in Active Query Builder .NET Edition 3.9.11 Build 2263 (May 17, 2023)

  • Only one link is created now on adding a new datasource to the design pane.
  • SAP Hana: Parsing of the STRING_AGG function with the ORDER BY clause is fixed.
  • MS SQL Server: Parsing of the AT identifier is fixed.
  • PostgreSQL: The bug on parsing the AT TIME ZONE operator is fixed.
  • The crash on loading stored procedure parameters to the properties editor if there's no metadata for this procedure is eliminated.

New in Active Query Builder .NET Edition 3.9.9 Build 2241 (Apr 16, 2023)

  • MySQL: The bug with parsing some of Group_Concat variants is fixed.

New in Active Query Builder .NET Edition 3.9.8 Build 2240 (Mar 11, 2023)

  • DevExpress UI assembly: Net46 target framework is added.
  • MS SQL Server: The bug with table hints parsing is fixed.
  • Oracle: The query to load objects now sorts objects by name alphabetically.

New in Active Query Builder .NET Edition 3.9.7 Build 2239 (Feb 19, 2023)

  • Creating links from foreign keys with many columns works fine now.
  • The new method MetadataItem.AddAggregate is added to add custom aggregates.
  • PostgreSQL: Support for custom aggregate functions is added.
  • MS SQL Server: Alias is made required for table-valued functions to distinct them from tables with hints.
  • MS SQL Server: The ambiguity on parsing a JOIN without join type is fixed.
  • High-DPI settings for demo-projects are corrected.

New in Active Query Builder .NET Edition 3.9.6 Build 2238 (Jan 8, 2023)

  • Re-ordering datasources in inner groups of the FROM clause is possible now.
  • MS SQL Server: Alias for table-valued functions is required now.
  • Printing of unrecognized aggregates is fixed.
  • Oracle: Support for VALIDATE_CONVERSION built-in function is corrected.

New in Active Query Builder .NET Edition 3.9.5 Build 2237 (Oct 25, 2022)

  • DataSourceGroup: The new method SetNewDataSourcesOrder is added to reorder datasources within a group.
  • DB2: "TABLE_NAME" and "TABLE_SCHEMA" functions from metadata queries as they don't exist in older DB2 versions.
  • The bug with restoring UserQueries is fixed.
  • Minor high-DPI fixes are made.
  • Design Pane: Objects drag-n-drop is fixed.
  • Design Pane: The bug with selecting fields in datasources with the Ctrl key is fixed.

New in Active Query Builder .NET Edition 3.9.4 Build 2236 (Sep 20, 2022)

  • SAP Hana: Support for CHAR builtin function is added.
  • Query Column List: visual artifacts are eliminated.
  • Query Column List: the invisible checkbox column is fixed.

New in Active Query Builder .NET Edition 3.9.2 Build 2234 (Aug 29, 2022)

  • Wrapping into a derived table for queries with CTE is fixed.

New in Active Query Builder .NET Edition 3.9.1 Build 2233 (Aug 22, 2022)

  • DB2: The query to load objects is optimized.
  • DevExpress: Theming support is improved.
  • DevExpress: Borders colors for DataSource Control is fixed.
  • Oracle: Non-default scale for numeric fields is shown.
  • Wrapping into a derived table is corrected.
  • SQL Text Editor: The paint of suggestion items is improved.

New in Active Query Builder .NET Edition 3.9.0 Build 2232 (Jul 16, 2022)

  • The new "Wrap into derived table" action is added to the datasource context menu to pack one or several datasources in a new derived table preserving the joins and conditions in the current subquery.
  • The new BehaviorOptions.GenerateWhereConditionsForAggregates property is added to set the "for values" option for aggregated query column list items by default.
  • Pervasive: SQL parser ambiguity in datetime functions is eliminated.
  • Now it's possible to select multiple datasources in the Design Pane in different ways:
  • Select all datasources in a rectangular area with the mouse,
  • Select individual datasources while holding the Ctrl key,
  • Select all the intermediate datasources between the given two ones (by joins) holding the Shift key.

New in Active Query Builder .NET Edition 3.8.29 Build 2230 (Jul 6, 2022)

  • The bug with selecting table.* elements in sub-queries is fixed.

New in Active Query Builder .NET Edition 3.8.28 Build 2229 (Jul 2, 2022)

  • References to DevExpress assembiles are updated to v.22.1.3.
  • The bug on loading fields with Alternate Names is fixed.

New in Active Query Builder .NET Edition 3.8.27 Build 2228 (Jun 29, 2022)

  • The bug in SubQuery.CanMoveCTETo for CTEs with subqueries is fixed.
  • Design Pane: Scroll bars painting and visibility is fixed.
  • The NRE on moving CTE on the Subquery Navigation Bar is eliminated.
  • Field list calculation for subqeries with alternate names is fixed.

New in Active Query Builder .NET Edition 3.8.26 Build 2227 (Jun 17, 2022)

  • Per-monitor scaling is improved.
  • Subquery Navigation Bar: Usability is improved.
  • Derived table and CTE context menus are revised.
  • Subquery fields list calculation using AltNames is fixed.
  • The loading of links with OUTER joins is fixed.
  • Serialization of MetadataStructureItem.MetadataName is fixed.

New in Active Query Builder .NET Edition 3.8.25 Build 2226 (Jun 5, 2022)

  • BaseSyntaxProvider: The OnCalcExpressionType is converted from property to event. This change may require manual editing of *.Designer.cs files to remove lines like "OnCalcExpressionType = null;"
  • MySQL: Support for JSON extraction operators is added.
  • Oracle: Precision for the NUMBER type is displayed now.
  • New methods to collect and resolve object name conflicts are added.
  • The bug with unchecking datasource fields is fixed.

New in Active Query Builder .NET Edition 3.8.23 Build 2224 (May 6, 2022)

  • Portuguese (Brazilian) localization is updated.
  • DevExpress UI: DataSource control painting, closing and resizing are fixed.
  • The bug with SQL layout loading in Trial version is fixed.
  • The "queryElement is not null" error on saving query layout in some cases
  • is fixed.

New in Active Query Builder .NET Edition 3.8.22 Build 2223 (Apr 29, 2022)

  • SQL Text Editor: The bug with large line height is fixed.
  • DevExpress: The bug with scrolling in the subquery navigation bar is fixed.

New in Active Query Builder .NET Edition 3.8.20 Build 2222 (Apr 24, 2022)

  • The object reference error on using comparison operators in join statements is fixed.

New in Active Query Builder .NET Edition 3.8.19 Build 2221 (Apr 22, 2022)

  • DevExpress: Per-monitor HiDPI scaling is improved.
  • DevExpress Basic demo: Criteria Builder is added.
  • References to DevExpress assemblies are updated to v.21.2.7.
  • Query Columns List: Logical expressions such as EXISTS subqueries aren't set as visible automatically, but used for filtration purposes by default.
  • The bug with not printing aliased object names is fixed.
  • Criteria Builder: The display of condition values is fixed.
  • MS SQL Server: Support for "FOR JSON" clause is added.
  • MS SQL Server: Support JOIN without a type prefix is made.
  • PostgreSQL: The bug with loading referencing objects list is fixed.
  • Oracle: Support for default value clause for conversion functions is added.
  • SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.

New in Active Query Builder .NET Edition 3.8.16 Build 2218 (Jan 27, 2022)

  • SAP Hana: Support for analytic expressions is made.
  • Design Pane: The hidden fields counter is displayed now on the datasource search panel.
  • The bug on double-clicking on the datasource control title is fixed.
  • SQL Text Editor: Suggestions are shown without a delay and blinking now.
  • SQL Text Editor: PageUp and PageDown keys now scroll the content of the suggestion popup.
  • Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
  • References to DevExpress assemblies are updated to v.21.2.5.
  • DevExpress: The height of suggestion popup items is corrected.
  • DevExpress: Datasource control context menu location on multi-monitor systems is fixed.
  • The Null Reference Exception in the trial version is fixed.

New in Active Query Builder .NET Edition 3.8.15 Build 2217 (Jan 15, 2022)

  • The new property QueryBuilder.DesignPaneOptions.ActionsPaneVisible is added to hide the top-right panel with quick actions on the Design Pane.
  • The new sample PreserveInitialQueryFormatting is added to give an idea of how to preserve the initial SQL query text formatting on load or manual change.
  • Exporting data to MS Excel using FlexCel library is added to the Full-Featured MDI Demo project.
  • Target framework for all C# demos is switched to 4.72. Code clean-up is made.
  • Object Properties: Value validator is now called in property setters.
  • SQL Text Editor: The insertion of special symbols via the ALTGR+key and ALT+code key combinations is fixed.
  • Informix: Parsing of queries with fields named like keywords is fixed.
  • Query Transformer: Correct field references in the WHERE clause is generated for wrapped queries with the DISTINCT option.
  • Pervasive DB: The IF builtin function parsing is fixed.

New in Active Query Builder .NET Edition 3.8.12 Build 2210 (Nov 10, 2021)

  • Support for Visual Studio 2022 is added.
  • Column aliases that are valid identifiers aren't quoted now.
  • The new BehaviorOptions.AlwaysQuoteColumnAliases property is added. Default is false.
  • References to DevExpress assemblies are updated to v.21.2.3.
  • MySQL: Fields are fetched sorted by ORDINAL_POSITION.
  • MySQL: The ANSI_QUOTES flag is detected during the server version autodetection.

New in Active Query Builder .NET Edition 3.8.10 Build 2208 (Sep 23, 2021)

  • The new property is added to determine the case of built-in functions and variables: SQLGenerationOptions.BuiltinFormat.
  • Design Pane: In the field list context menu, the Sorting item is moved to the root of the menu, the HAVING item is shown if a query has grouping.
  • The SQLFormattingOptions.KeywordFormat property is moved to the SQLGenerationOptions class.
  • IBM DB2, Informix: Metadata providers are compiled in the AnyCPU mode. Make sure that you have the required version of the DB client installed.
  • Syntax provider settings forms: The 'Deny INTO clause' option is not shown anymore.

New in Active Query Builder .NET Edition 3.8.9 Build 2207 (Sep 1, 2021)

  • The field context menu in DataSource controls on the Design Pane has been improved when grouping is applied, and the field is used in the query several times.
  • The field sorting icon is fixed in DataSource controls on the Design Pane when the field is mentioned in the ORDER BY several times.
  • SQL Text Editor: Search and replace functionality has been fixed.
  • SQL Text Editor: Pressing the Ctrl+Backspace key combination removes the whole word at the left of the cursor. The Shift+Backspace now acts as the Backspace key.

New in Active Query Builder .NET Edition 3.8.8 Build 2206 (Aug 19, 2021)

  • Design Pane diagram painting has been speeded up.
  • GrapeCity reports module can be activated in the Full-Featured MDI Demo by turning on the EnableActiveReportsSupport property in the Samples
  • Directory.Build.props file.
  • The keyboard arrow-keys navigation in the Query Column List (move left in the Criteria column) has been fixed.
  • The bug with SQL text generation for objects and fields with empty alternate names when the UseAltNames property is true has been fixed.

New in Active Query Builder .NET Edition 3.8.7 Build 2205 (Aug 19, 2021)

  • The methods to serialize/deserialize query builder option groups are moved from the View to Core assembly.
  • The bug with SQL query generation with alternate names for servers supporting object names as a default alias has been fixed.

New in Active Query Builder .NET Edition 3.8.6 Build 2204 (Jul 14, 2021)

  • MS SQL Server: Support for TRY_CAST and TRY_CONVERT built-in functions has been added.
  • Objects in the search results are expandable now.
  • Query model optimization has been made. Datasources aren't reordered now if
  • not needed.
  • Query Columns List: Grouping and aggregate icons in checkboxes are updated.
  • Expression Editor: The Query Context panel content is generated correctly
  • now.
  • The NRE on the component disposal for some complex queries has been
  • eliminated.
  • Query Columns List: The bug with displaying the 'Or' column before the
  • Criteria' column has been fixed.

New in Active Query Builder .NET Edition 3.8.4 Build 2200 (Jun 21, 2021)

  • The alignment of links on design pane control has been fixed.
  • The execution of pre-compiled demos and the compilation of sample projects have been fixed.
  • DevExpress: The unnecessary dependency from System.Resource.Extension assembly has been eliminated.

New in Active Query Builder .NET Edition 3.8.1 Build 1197 (May 20, 2021)

  • The minimal initial datasource height on Design Pane is limited to fit three fields
  • The null reference exception on removing the last CTE from subqueries is fixed.

New in Active Query Builder .NET Edition 3.7.18 Build 1193 (Apr 30, 2021)

  • When the last CTE reference is removed, a prompt to remove from the query the CTE itself contains the link to switch to it.
  • Query Structure Demo: The dumping of the WHERE clause is improved.
  • Pervasive SQL: The parsing of the IF built-in function is fixed.

New in Active Query Builder .NET Edition 3.7.17 Build 1192 (Mar 22, 2021)

  • The bug with focusing on a wrong property on clicking the "Fix issue" anchor is fixed.
  • Minor localization and other fixes are made.

New in Active Query Builder .NET Edition 3.7.15 Build 1190 (Mar 10, 2021)

  • The length of automatically generated aliases for single-word names is limited to 3 characters.
  • The ObjectNamesNormalization property set to False doesn't lead to the full qualification of names added by code and visually.
  • MySQL: "POSITION" is added to the list of valid identifiers.
  • DevExpress: The bug with clicking on checkboxes next to datasource fields on the Design Pane has been fixed.
  • The location of buttons to show/hide unused fields on the Design Pane has been fixed.

New in Active Query Builder .NET Edition 3.7.14 Build 1189 (Feb 22, 2021)

  • The length of autogenerated aliases is limited by 5 characters.
  • Design Pane: Visibility of PK and FK fields on hiding fields has been fixed.
  • SQL Text Editor: The crash on showing the suggestion list after user input has been fixed.

New in Active Query Builder .NET Edition 3.7.13 Build 1188 (Feb 8, 2021)

  • Usage of alternate names in column prefixes has been fixed.
  • The default value of BehaviorOptions.GenerateShortObjectAliases is set to false.
  • SQL Text Editor: An exception on showing the suggestion popup has been fixed.

New in Active Query Builder .NET Edition 3.7.11 Build 1186 (Jan 21, 2021)

  • MySQL: Support for UTC_* functions has been added.
  • SQL Text Editor: Showing and hiding of suggestion popup has been fixed.
  • The bug on clicking on an empty condition cell has been fixed.
  • Other minor bugs are fixed.

New in Active Query Builder .NET Edition 3.7.6 Build 1181 (Dec 14, 2020)

  • Two methods are added to save and restore widths of columns set by the user: QueryBuilder.QueryColumnListControl.SaveLayout and RestoreLayout.
  • It is now always possible to change the PERCENT and WITH TIES options even if the TOP clause is not defined.
  • References to DevExpress assemblies are updated to v.20.2.
  • Informix: Support for the LIMIT clause is added.
  • Generic SQL syntax: Support for ABS built-in function is added.
  • Minor parsing errors are fixed.
  • Oracle: The bug with parsing names containing the PACKAGE component is fixed.
  • DevExpress: The Add Object dialog is fixed.
  • Add Object Dialog: Slow loading of tables and views is fixed.

New in Active Query Builder .NET Edition 3.7.3 Build 1176 (Oct 23, 2020)

  • SQL query loading and query statistics calculation have been speeded up.
  • Oracle: Schema list loading has been speeded up.
  • PostgreSQL: Support for parenthesized subqueries has been added.
  • Query Transformer: Queries with DISTINCT aren't wrapped in a subquery now
  • if the WHERE clause is empty.
  • The bug with showing UserQuery fields in the Database Schema Tree after the
  • search has been fixed.
  • Numerous minor user interface bugs were fixed.

New in Active Query Builder .NET Edition 3.7.2 Build 1175 (Oct 14, 2020)

  • The installer creates local NuGet source with Active Query Builder packages.
  • The bug with saving reusable queries has been fixed.
  • Minor bugs have been fixed.

New in Active Query Builder .NET Edition 3.7.1 Build 1174 (Sep 7, 2020)

  • Support for .Net Core 2.2 and 3.1 support has been added.
  • Snowflake SQL: LIMIT is treated as a valid identifier now.
  • Metadata calculation for virtual objects has been fixed.
  • The drawing of the DockPanel caption in large-scaling modes has been corrected.
  • Snowflake SQL: "POSITION" is removed from the keywords list.
  • Snowflake SQL: The ambiguity in the parsing of complex comparison expressions has been fixed.

New in Active Query Builder .NET Edition 3.6.7 Build 1165 (Jul 3, 2020)

  • The BehaviorOptions.LinkManipulations property is taken into account when creating a new link using datasource context menus, notification events are fired correctly then.
  • On trying to link a table to itself, a copy of that table is added to the query and linked accordingly.
  • The bug with multiline field descriptions drawn on the same line is fixed.

New in Active Query Builder .NET Edition 3.6.6 Build 1164 (Jun 27, 2020)

  • Users now can create links from UI separately indicating fields to
  • start and finish a new link via the datasource field context menu.
  • Three new events are added to the CriteriaBuilder control:
  • NeedEditorForValue, NeedCustomLookupButton, NeedCustomLookupControl.
  • They allow for using custom editors for values of specific fields or
  • data types.
  • The new demo project CriteriaBuilderCustomize is added to illustrate
  • the way how one can use custom editors, buttons and controls in the
  • CriteriaBuilder control.
  • Source code of the Metadata Container Editor is included in a set of
  • demo projects for Trial and Professional versions.
  • Criteria Builder: minor fixes and improvements are made.
  • QuickBooks: Support for square-brackets quoted identifiers has been added.
  • The bug with checking/unchecking an asterisk item in datasources is fixed.

New in Active Query Builder .NET Edition 3.6.1 Build 1160 (May 9, 2020)

  • Query Navigation Bar: The new way to display the path to subqueries is made. Now when you switch to a subquery, a breadcrumb displaying the path from the main query to the current subquery is drawn; subqueries that don't belong to the current subquery are hidden. This mode is turned on by default. You can switch it off by setting the QueryBuilder.QueryNavBarOptions. ShowPathToCurrentSubQuery property to False.
  • The Metadata Container Editor executable is included in the Professional and Trial installation packages.
  • Existing object is linked when creating a new join rather than adding a new object, but only if it's not yet linked in another way.
  • Predefined SQL expressions are indicated with their names instead of SQL expression texts in the field context menu.
  • It is now easy to add more than one folder to the root.
  • "Object" is not displayed as a field data type anymore when it's not possible to determine it.
  • Syntax providers: The new property QueryToLoadFieldsTemplate allows for customizing the query to load the list of fields for an object.
  • Metadata providers: The new property CommandTimeout allows for changing the timeout for metadata loading queries.
  • Scaling in the WinForms and DevExpress controls UI is fixed.
  • The default value of MetadataStructureOptions.GroupByTypes property is changed to True.
  • Oracle: Objects of excluded types (tables, views, procedures, synonyms)aren't loaded to the MetadataContainer anymore.
  • Oracle: Synonyms for objects that are not loaded to the metadata container aren't hidden now to speed-up a load of synonyms.
  • Consolidated Metadata Container demo: The "Show DataSources stats" button is added.

New in Active Query Builder .NET Edition 3.5.38 Build 1156 (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 onadding 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.

New in Active Query Builder .NET Edition 3.5.36 Build 1154 (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.

New in Active Query Builder .NET Edition 3.5.35 Build 1153 (Jan 14, 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.

New in Active Query Builder .NET Edition 3.5.34 Build 1152 (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.

New in Active Query Builder .NET Edition 3.5.33 Build 1150 (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.

New in Active Query Builder .NET Edition 3.5.32 Build 1149 (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.

New in Active Query Builder .NET Edition 3.5.30 Build 1147 (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 recognized and saved correctly now.

New in Active Query Builder .NET Edition 3.5.20 Build 1133 (Jun 3, 2019)

  • MySQL: Support for window functions and WINDOW clause have been added.
  • PostgreSQL: Support for window functions and WINDOW clause have been added.
  • Serialization of the Query Column List to the LayoutSQL has been improved.
  • Subquery Navigation Popup closing after a click on the SELECT button has
  • been fixed.

New in Active Query Builder .NET Edition 3.5.19 Build 1132 (May 28, 2019)

  • The bug with applying localization to the columns of the Query Columns
  • Grid has been fixed.
  • We highly recommend removing the following values stored in ".Designer.cs"
  • files if you didn't redefine column captions using these properties:
  • This.queryBuilder1.QueryColumnListOptions.ColumnsOptions.*Column.Caption

New in Active Query Builder .NET Edition 3.5.17 Build 1129 (May 23, 2019)

  • The new Chinese (Simplified) localization has been added.
  • DevExpress UI: Support for version 2019.1 has been made.
  • Query Transformer: The ability to add grouping (GROUP BY section) to the
  • Initial query has been made.
  • Now it is possible to pass not only aggregates but also columns and
  • Expressions to the QueryTransformer.Aggregates.Add() method.
  • The problem with design-time ColumnsOptions.Caption serialization has been
  • Solved.
  • Trial version: The bug with displaying the trial notification form if
  • QueryBuilder is already disposed, has been fixed.
  • Query Transformer: The bug with incorrect SQL generation for initial
  • Queries with DISTINCT has been fixed.

New in Active Query Builder .NET Edition 3.5.16 Build 1128 (May 9, 2019)

  • Minor bugs are fixed.

New in Active Query Builder .NET Edition 3.5.15 Build 1127 (May 1, 2019)

  • Visual Studio 2017/2019: WinForms and WPF controls are automatically registered now in the Toolbox.
  • Query Columns List: "= false" and "= true" are suggested now in condition columns for logical expressions like EXISTS subqueries.
  • Query Columns List: It is possible now to drag the last empty row to arbitrary position to form a new query column there.
  • Query Columns List: Removal and reorder of selected rows is possible now using the appropriate context menu commands.
  • Query Columns List: It is possible now to insert a new row above or below the current row using the "Insert after/berfore" context menu commands.
  • Query Columns List: multiple fixes and improvements in the process of reordering rows by drag'n'drop.
  • LayoutSQL: Restoring layout for queries with virtual objects has been fixed.
  • PostgreSQL: "table.*" is accepted as an ordinary SELECT item expression term.
  • SAP Hana: Support for (REPLACE/SUBSTR/OCCURRENCES)_REGEXPR, LEFT and RIGHt functions has been added.

New in Active Query Builder .NET Edition 3.5.14 Build 1126 (Apr 12, 2019)

  • 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.
  • 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.

New in Active Query Builder .NET Edition 3.5.13 Build 1125 (Mar 13, 2019)

  • The Unicode "no-break space" symbol is added to the list of ignored chars.
  • The indication of command shortcuts in context menus has been corrected.
  • Unhandled exception on app closing if the focus is in the Query Column List has
  • been eliminated.
  • The bug with the layout restoration on some queries has been fixed.

New in Active Query Builder .NET Edition 3.5.13 Build 1124 (Mar 7, 2019)

  • Support for the .NET Standard 2.0 for non-visual assemblies has been made.
  • SQL Text Editor: On-demand metadata loading for suggestions has been improved;
  • the default value of LoadMetadataOnCodeCompletion property has been changed to
  • true.
  • The default value of MetadataStructureOptions.AllowFavourites property has been
  • changed to true.
  • Query Columns List Control: Keyboard shortcuts have been changed and fixed.
  • Shift+up/down: multiple rows selection;
  • Ctrl+up/down: grid scrolling;
  • Alt+down: display drop-down list in appropriate columns;
  • Ctrl+Enter, Shift+F2: Open the multiline expression editor where it is possible.
  • Ctrl+Alt+up/down: movement of selected columns up and down.
  • Displaying of alternate names in the Database Schema Tree now obeys the
  • QueryBuilder.SQLFormattingOptions.UseAltNames property.
  • ODBC: loading fields from the driver for AdvantageDB has been fixed.
  • Other minor improvements and bugfixes have been made.

New in Active Query Builder .NET Edition 3.5.9 Build 1116 (Dec 24, 2018)

  • Mistyped or incomplete conditions detection has been improved.
  • VistaDB: References to the client library is updated to the latest
  • version.

New in Active Query Builder .NET Edition 3.5.8 Build 1115 (Dec 14, 2018)

  • SQL text generation and parsing have been speeded up.
  • PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE have been eliminated.
  • DevExpress: The bug with SQL expression property editor has been fixed.
  • The notification about SQL expression errors in conditions has been corrected.

New in Active Query Builder .NET Edition 3.5.6 Build 1113 (Dec 2, 2018)

  • Main localizations have been updated.
  • MS SQL Server: Support for SQL 2017 specific syntax of CONCAT_WS,
  • TRANSLATE, and TRIM functions and query hints has been added.
  • Stored procedure parameter values validation in the Properties bar has
  • Been fixed.
  • The bug with disposing of custom Query Column List Control cells has
  • Been fixed.

New in Active Query Builder .NET Edition 3.5.6 Build 1112 (Nov 26, 2018)

  • References to DevExpress assemblies are updated to version 18.2.
  • MS SQL Server: Column aliases for functions are allowed now.
  • The Add Object dialog has been fixed.
  • The problem with join expressions in the WHERE clause in correlated subqueries has been fixed.
  • SQL Text Editor: Caret positioning by mouse has been made more accurate.
  • The notification about errors in Criteria expressions has been fixed.

New in Active Query Builder .NET Edition 3.5.5 Build 1111 (Nov 4, 2018)

  • Memory leaks for undisposed AstNode objects have been eliminated. Took
  • place when you have a long-life SQLContext object and use it to process
  • multiple SQLQuery objects.
  • DevExpress: The source code to compile the DevExpress GUI assembly has
  • been corrected.

New in Active Query Builder .NET Edition 3.5.5 Build 1110 (Nov 2, 2018)

  • The new DatabaseSchemaViewOptions.DefaultExpandFolderNodes property has
  • been added to control the initial expansion of nodes which aren't tied
  • o a specific MetadataItem object. Default value: False.
  • An error is displayed now in Properties dialogs preventing the dialog
  • close on clicking the OK button when incorrect SQL expression is entered
  • for one of the properties.
  • Query Columns List: The Shift+F2 shortcut is added now to call the
  • Expression Editor in Expression and Criteria cells.
  • Query Column List: The Alt+Down shortcut now opens drop-down list in
  • appropriate cells.
  • Minor Properties Bar fixes have been made, Tab key navigation has been
  • fixed.
  • Emptying Link Expression now results in displaying a specific error
  • message.
  • SQL Text Editor: Appliance of the font to the suggestion window has been
  • fixed.
  • SQL Text Editor: The Replace text functionality is back.
  • The problem with a black rectangle at the bottom of datasources on the
  • Design Pane has been fixed.
  • MS SQL Server: The bug with retrieving primary key when a table contains
  • Clustered Index has been fixed.
  • PostgreSQL: Parsing of the AT TIME ZONE operator has been fixed.
  • Memory leaks when QueryBuilder component hasn't disposed have been
  • eliminated.

New in Active Query Builder .NET Edition 3.5.4 Build 1109 (Oct 18, 2018)

  • The regression in the case of the Database Schema Tree re-initialization introduced in the previous build has been eliminated.

New in Active Query Builder .NET Edition 3.5.4 Build 1108 (Oct 18, 2018)

  • The bug with applying the DefaultExpandMetadataType property on
  • initializing the Database Schema Tree has been fixed.
  • SQL Text Editor: The bug with positioning the cursor by mouse in the case
  • of the large text padding has been fixed.
  • The collapse search panel button style has been reverted to the previous.
  • The bug with localizing context menu in the Reusable Queries View has been
  • fixed.

New in Active Query Builder .NET Edition 3.5.2 Build 1106 (Sep 20, 2018)

  • Confirmation dialog has been beautified.
  • Filter Item control: "OK" and "Cancel" buttons have been added.
  • Standard version demos: The editor for the DefaultExpandMetadataType has
  • been added to the Properties form.
  • DevExpress: Theme colors are applied correctly to Properties sidebar now.
  • DevExpress: Properties bar: The properties container growing has been
  • fixed.
  • Properties bar: The missing Criteria column has been restored in the
  • Query Column List properties editor.
  • Properties bar: Boolean editor cropping fixed.
  • Properties bar: Showing/hiding and resizing descriptions has been fixed.
  • MS SQL Server: The bug with disabled editors for "Percent" and "With ties"
  • properties has been fixed.
  • Query Columns List: Appliance of the default width to "Or" columns has
  • been fixed.
  • The bug with duplication of the column list for objects in the query
  • which weren't uniquely identified has been fixed.
  • OLE DB Metadata Provider: Loading of the PrimaryKey flag from the Indexes
  • collection has been fixed.
  • Multi-thread concurrent execution issue has been fixed.

New in Active Query Builder .NET Edition 3.5.2 Build 1105 (Sep 12, 2018)

  • Metadata Editor and Metadata Loading Wizard usability improvements and
  • minor bugfixes have been made.
  • SQL Text Editor: The new property LineHeight has been added.
  • New params for the SubQuery.GetSqlForDataPreview function instruct to add
  • a row limitation clause to the returned query. Default values prescribe
  • not to add this clause (int skip = 0, int count = -1).
  • Minor change to avoid inconsistent SQL query state by has been made.
  • Grouping is now automatically turned on for the column turned visible if
  • there is grouping or aggregates in the sub-query.
  • Custom node images in the Database Schema View are updated correctly now
  • after the component initialization.
  • Minor fixes and improvements in demo projects have been made.
  • SQL Text Editor: The bug with corrupting selection after copying it to the
  • clipboard has been fixed.
  • MS SQL Server: Loading databases for linked servers has been fixed.
  • Design Pane: The manually changed Datasource height is preserved now.
  • Design Pane: Selecting fields from a Datasource with filtered fields is
  • performed correctly now.
  • Incorrect deprecation notice from the SqlTextEditor.TextColor property
  • has been removed.

New in Active Query Builder .NET Edition 3.5.0 Build 1104 (Sep 2, 2018)

  • SQL Text Editor: SQL-related properties are moved out to a separate group:
  • SqlTextEditor.SQLOptions, ExpressionEditor.TextEditorSQLOptions.
  • The behaviour of the DefaultExpandMetadataType property has been changed.
  • Now the types listed in this property will be expanded automatically.
  • The new default value is Database.
  • SQL expression error handling: Last good property value is reverted now
  • when the user closes the Error information panel. Minor bugfixes and
  • improvements have been made.
  • Localization files have been updated. Untranslated strings have been added
  • as commented nodes.
  • Full-featured MDI Demo: The connection parameters form has been improved.
  • SQL Text Editor: Minor fixes and improvements in suggestion list have been
  • made.
  • DevExpress references are updated to v.18.1.5.
  • New methods have been added to the MetadataStructure to save and load
  • objects marked by the user as favourites: ExportFavouritesToXML,
  • ImportFavouritesFromXML.
  • The new method MetadataStructureItem.LoadChildItemsRecursive(MetadataType
  • expandTypes) has been added.
  • The crash when erroneous expression typed in the Criteria and Expression
  • columns of the Query Columns Grid has been fixed.

New in Active Query Builder .NET Edition 3.5.0 Build 1103 (Aug 20, 2018)

  • The ability to mark database objects as favourites has been added. *
  • Displaying details about the database object selected in the Database
  • Schema View is made. *
  • Code completion in the Expression and Criteria cells is available now. *
  • Identifying and correcting errors in SQL expressions is now easier with
  • smart notifications.
  • The prompt for sub-query deletion doesn't block the user interface now.
  • The new Japanese localization is made.
  • Eight localizations are updated and proofread by professionals: German,
  • French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian,
  • Turkish, and Russian.
  • Main demo projects have been significantly re-worked.
  • Serialization of all component properties is possible now.
  • The completely re-made Metadata Container editor has been released.
  • The new Metadata Filter editor control has been added. *
  • Controls to edit the component properties have been made. *
  • Controls to edit properties of supported .NET DB connection libraries
  • have been made. *
  • The Simple Metadata Filter now accepts full qualified names in the Schemas
  • and Objects collections.
  • ! The new DatabaseSchemaTree.DefaultExpandMetadataType property supersedes
  • the DefaultExpandLevel property.
  • Items marked with an asterisk are available in the Professional version
  • only.

New in Active Query Builder .NET Edition 3.4.19 Build 1099 (Jul 1, 2018)

  • The current active sub-query is saved now in the XML structure of the LayoutSQL property.

New in Active Query Builder .NET Edition 3.4.19 Build 1098 (Jun 29, 2018)

  • Building the visual diagram for queries containing a large number of columns or when objects used in the query contain a large number of fields has been significantly speeded up.
  • The bug with the Design Pane control scrolling while dragging a field over it has been fixed.
  • The bug in the QueryTransformer with the WHERE clause corruption when Skip/Take is set which arose on the SQL Server 2005 and 2008 has been fixed.

New in Active Query Builder .NET Edition 3.4.17 Build 1097 (Jun 22, 2018)

  • SAP HANA: Detection of the default schema has been made.
  • SQL Server Compact Edition: The list of functions and keywords has been filled.
  • The "INTO"-related properties are hidden from the Properties bar now if the SyntaxProvider.DenyIntoClause is set to True.

New in Active Query Builder .NET Edition 3.4.17 Build 1096 (Jun 10, 2018)

  • Query Column List control now allows resizing of the "Grouping" column.
  • The bug with primary key links menu item captions has been fixed.
  • Captions of the "Or" columns are updated correctly now on changing the
  • language.

New in Active Query Builder .NET Edition 3.4.16 Build 1095 (Jun 9, 2018)

  • Initial support for SAP HANA has been added: metadata retrieval queries,
  • list of built-in functions.
  • The BaseSyntaxProvider.BuiltinFunctionNames property is public now.
  • The new helper method MetadataField.GetDataTypeName has been added to
  • get datatype string combining the ServerTypeName, Size and Precision
  • attributes.
  • Retrieval of referenced objects by foreign keys for unsupported servers
  • has been speeded up.
  • Hiding the information message when the reported problem is no longer
  • actual has been fixed.
  • The original Metadata Structure is preserved now after searching to keep
  • the assigned event handlers.
  • Minor scaling issues have been fixed.

New in Active Query Builder .NET Edition 3.4.16 Build 1094 (May 30, 2018)

  • SQL Text Editor: The bug with building the suggestion list for metadata
  • with loaded linked servers has been fixed.
  • Minor bug fixes have been fixed.

New in Active Query Builder .NET Edition 3.4.16 Build 1093 (May 28, 2018)

  • References to DevExpress have been updated to v.18.1.
  • Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
  • WinForms: Minor fixes and improvements for the Database Schema View have
  • been made (Border style, multi-select).
  • Teradata: The bug with autodetection of new versions has been fixed.

New in Active Query Builder .NET Edition 3.4.15 Build 1092 (May 21, 2018)

  • Logging improvements have been made.
  • Now trying to cut off garbage in the fields description while fetching metadata from ODBC driver. (a workaround for the bug in MS Access ODBC driver)
  • The bug with side panels visibility has been fixed.

New in Active Query Builder .NET Edition 3.4.14 Build 1091 (May 16, 2018)

  • The new DataSourceAddLinkedObject event has been added to the QueryBuilder, QueryView objects to override the default behaviour on adding a new object to the query which is linked to the existing one.
  • The new DataSourceOptions.ShowOptionsButton property has been added. It allows hiding the Datasource Options (hamburger) button.
  • Metadata loading: Field type doesn't get updated by the Metadata Provider now if it is already loaded (show type names instead of domain names).
  • The Null Reference Exception when asterisk item is hidden has been fixed.
  • The IAddObjectDialog.MetadataStructure property is now writeable.
  • Add Object Dialog: The bug with displaying folders in the drop-down list has been fixed.
  • DevExpress: Applying themes to the SQL Text Editor has been fixed.
  • DevExpress: The bug with displaying the suggestion popup has been fixed.
  • DevExpress: SqlTextEditor.BorderStyle property type has been changed from Windows.Forms.BorderStyle to DevExpress.XtraEditors.Controls.BorderStyles.

New in Active Query Builder .NET Edition 3.4.13 Build 1090 (May 9, 2018)

  • The new method is available now in the SQLQuery service to link a newly
  • added object to other objects having same named fields.
  • The LinkObjectBySameNamedFields accepts a DataSource as parameter as
  • returns a list of newly added Link objects.
  • The bug metadata filtration arising in some particular cases has been
  • fixed.
  • The Remove context menu item is not displayed for sub-queries in
  • expressions.
  • The "Image index out of range" error has been fixed.

New in Active Query Builder .NET Edition 3.4.12 Build 1089 (May 5, 2018)

  • SQL Text Editor: The first item in suggestion window is not selected now right after its opening. This eliminates the problem of unnecessary substitutions.

New in Active Query Builder .NET Edition 3.4.11 Build 1088 (May 5, 2018)

  • Pervasive: Support for Pervasive PSQL (Actian Zen) has been added.

New in Active Query Builder .NET Edition 3.4.10 Build 1087 (Apr 15, 2018)

  • The new method SubQuery.GetSqlForDataPreview has been added to retrieve the text of sub-query along with the referred named queries from the Common Table Expression to organize data preview for sub-queries.
  • Full-featured demos now use the GetSqlForDataPreview method for data preview.
  • The new CTEUnitVisible, UnionsUnitVisible properties have been added to the SubQueryNavBar and QueryNavigationBar controls.
  • Minor bug fixes and improvements have been made.

New in Active Query Builder .NET Edition 3.4.9 Build 1086 (Apr 10, 2018)

  • 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.
  • The bug with black cell background in the Query Column List Control has been fixed.
  • 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.

New in Active Query Builder .NET Edition 3.4.8 Build 1085 (Apr 3, 2018)

  • 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.
  • Native and DevExpress controls scaling issues have been fixed.

New in Active Query Builder .NET Edition 3.4.7.1084 (Mar 8, 2018)

  • 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.

New in Active Query Builder .NET Edition 3.4.6.1083 (Mar 3, 2018)

  • 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.
  • Logging of the stored procedure params loading has been improved.
  • 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.

New in Active Query Builder .NET Edition 3.4.5.1082 (Feb 20, 2018)

  • Minor fixes have been made.

New in Active Query Builder .NET Edition 3.4.5.1081 (Feb 18, 2018)

  • 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.

New in Active Query Builder .NET Edition 3.4.4.1080 (Feb 12, 2018)

  • 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.

New in Active Query Builder .NET Edition 3.4.3.1079 (Jan 31, 2018)

  • 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.

New in Active Query Builder .NET Edition 3.4.3.1078 (Jan 27, 2018)

  • Tooltip on the datasource caption is now displaying the description for
  • database objects or the beginning of sub-query text for sub-queries.
  • Expression Editor: The SQLFormattingOptions is a reference property now,
  • not a contained object.
  • SubQuery: Setting the LimitCount and LimitOffset properties is temporarily
  • turned off.
  • 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.

New in Active Query Builder .NET Edition 3.4.2.1077 (Jan 23, 2018)

  • Better visual style for the database schema tree has been made.
  • 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.

New in Active Query Builder .NET Edition 3.4.1.1076 (Jan 13, 2018)

  • SubQuery.Caption property returns localized caption for the main query.
  • Default namespaces aren't shown in datasource captions now.
  • Metadata Structure: Grouping by types at the top level has been fixed.
  • Only the simple WHERE clause conditions like "field1 = field2" are loaded
  • as links now.
  • Generation of offset in the LIMIT expression has been fixed.
  • Loading of reusable queries has been fixed.
  • Properties panel: Properties for the focused query element weren't shown
  • on the first activation. Fixed now.
  • Properties panel: Captions for multiline editors are placed above the
  • editor.
  • Properties panel: Wrapping by words is turned on for multiline SQL
  • expression editors.
  • Database Schema Tree: The selection rectangle and focus frame around the
  • focused node text, not around entire row
  • Fields are checked on KeyDown now, not on KeyUp.
  • The internal notification popup doesn't blink on startup anymore.
  • Resizing of the Query Column List Control has been speeded up.
  • SQL Text Editor: Black background at the bottom has been eliminated.
  • .csproj files in the source code have been fixed.

New in Active Query Builder .NET Edition 3.4.0.1075 (Jan 4, 2018)

  • SQL expressions error handling.
  • Query inconsistency alerts.
  • Easy addition of linked objects to the query.
  • Search and filtration in field list of objects on Design Pane.
  • Keyboard shortcuts in Design Pane.
  • Metadata loading acceleration.
  • Other improvements.

New in Active Query Builder .NET Edition 3.3.26.1074 (Dec 31, 2017)

  • On-demand metadata loading improvements have been made to speed up field
  • list retrieval when adding a new object to the query.
  • DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  • an arbitrary order has been fixed.
  • Minor localizer bug has been fixed.
  • SQL Text Editor: The bug with Undo operation has been fixed.

New in Active Query Builder .NET Edition 3.3.25.1073 (Dec 14, 2017)

  • Sybase: Support for window functions has been added.
  • User Queries: Exception is thrown now if query expression has output column names conflicts.
  • Teradata: Minor metadata loading improvements have been made.
  • SQL Text Editor: The bug with caret position after removing a character and scrolling has been fixed.
  • SQL Text Editor: The bug with the content of suggestion window not taking the last input character into account has been fixed.
  • Loading of stored procedure parameters from metadata XML files has been fixed.
  • Incorrect re-ordering of rows by drag'n'drop in the Query Columns Grid has been fixed.

New in Active Query Builder .NET Edition 3.3.24.1071 (Nov 28, 2017)

  • Restoring layout of datasources in the query after manual changing the query has been fixed.
  • The new "Go To Expression" context menu item has been added for sub-queries in expressions.
  • New properties have been added to the AddObjectWindowOptions group: Width, Height, Position, Location, ImageIndices.
  • Query Column List: Conditions recognition and correction has been improved.
  • User Queries Structure assignment has been fixed.
  • The QueryStatistics.IsStatisticsValid flag has been hidden.
  • Oracle: Batch fields and relations loading has speeded up metadata loading.
  • Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
  • Sybase: Detection of newer versions of SQL Anywhere has been fixed.
  • Sybase: Case-sensitive identifiers are implied for Sybase ASE.
  • Firebird: Parsing of Aggregate functions has been fixed.
  • The bug with dragging CTE from the query navigation bar to the Design Pane has been fixed.
  • References to DevExpress controls have been updated to the version 17.2.3.
  • Other improvements and bug fixes have been made.

New in Active Query Builder .NET Edition 3.3.23.1070 (Oct 18, 2017)

  • The bug with expanding custom metadata structure items has been fixed.
  • The crash on searching in the Database Schema Tree has been eliminated.
  • The bug with not clearing the ORDER BY clause on assigning new text to
  • a sub-query.

New in Active Query Builder .NET Edition 3.3.22.1069 (Oct 15, 2017)

  • Parsing of large Oracle SQL queries has been speeded up.
  • The new Link.ReferencedDataSources property has been added.
  • The new UserQueriesControl.SelectedItemChanged event has been added.
  • Creation of referencing loops of virtual objects is not possible now.
  • MySQL: Parsing of DateDiff function has been fixed.
  • The bug with localization of the Add Object Dialog has been fixed.
  • The new "Execute Query" action has been made in the Full-Featured MDI Demo project.

New in Active Query Builder .NET Edition 3.3.21.1068 (Sep 28, 2017)

  • MySQL: Some valid identifiers were erroneously treated as keywords. Fixed now.

New in Active Query Builder .NET Edition 3.3.20.1066 (Sep 22, 2017)

  • Oracle: set MAIN as valid identifier
  • MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been added.
  • Methods to save and load user queries to XML have been moved to the SQLContext class.
  • Minor bugfixes and improvements have been made.

New in Active Query Builder .NET Edition 3.3.19.1065 (Sep 14, 2017)

  • The new StatisticsField.IsDirectlyMentioned property has been added. It indicates whether a field is directly mentioned in the query or just appears in the query result as a result of the expansion of an asterisk item ("*") in the SELECT list.
  • User queries structure has been moved from the UserQueries control to the SQLContext.UserQueriesStructure property.
  • SQL Text Editor: Word wrapping has been fixed.

New in Active Query Builder .NET Edition 3.3.18.1065 (Aug 29, 2017)

  • MS SQL Server: Support for SELECT into local variable has been added.
  • (SELECT @localVar = ...)
  • The bug with resolving baseName.fieldName references for stored procedures
  • and table-valued functions has been fixed.
  • The bug with not refreshing fields for objects in the main query via
  • RefreshDatasourcesMetadata call has been fixed.
  • The bug with not allowing to expand object type grouping nodes (Tables,
  • Views, ...) in the Database Schema Tree has been fixed.

New in Active Query Builder .NET Edition 3.3.16.1063 (Aug 12, 2017)

  • The new IDatabaseSchemaView.ValidateItemContextMenu event has been made.
  • It lets customize context menu of the Database Schema Tree items.
  • The new IDatabaseSchemaView.ExpandItem has been made to expand the tree
  • down to the specified item and scroll down to it.
  • Position of an invalid object can be obtained from the SQLParsingException
  • on parsing a query when ParsingErrorOnUnknownObjects property is set to
  • True.
  • MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  • type only has been fixed.
  • SQL Text Editor: Apostrophes in quoted identifiers don't break the
  • highlighting now.
  • The QueryBuilder.LayoutSQL property now accept empty strings without
  • errors.

New in Active Query Builder .NET Edition 3.1.1.1028 (Oct 18, 2016)

  • SubQuery object does not store precalculated list of inner subqueries, but calcs it on demand
  • PostgreSQL: Date/time parts are added to the list of valid identifiers
  • PostgreSQL: Parsing of set operators is fixed

New in Active Query Builder .NET Edition 3.1.1.1026 (Oct 18, 2016)

  • The bug with aggregate functions with an asterisk parameter ("*") is fixed
  • Other minor bugs are fixed

New in Active Query Builder .NET Edition 3.1.1.1025 (Oct 18, 2016)

  • + Criteria Builder: BETWEEN operator is available for string values now
  • = DevExpress references are updated to v.16.1.5

New in Active Query Builder .NET Edition 2.10.5.786 (Sep 5, 2016)

  • The bug with aggregate functions with an asterisk parameter ("*") is fixed.

New in Active Query Builder .NET Edition 2.10.4.750 (Nov 25, 2015)

  • The bug that caused crash on right-clicking on the link when
  • BehaviorOptions.LinkManipulations is set to LinkManipulations. Deny is fixed.

New in Active Query Builder .NET Edition 2.10.4.748 (Nov 25, 2015)

  • Generation of Common Table Experssions (CTE) is corrected.
  • Inoperable CreateWhereJoinsByDefault property is fixed.
  • = Grouped expressions are loaded with default condition type "For values". SearchBox layout distortion when changing QueryBuilder font is fixed.
  • = Installer: Start Menu items are optimized to avoid menu littering on Windows 10.

New in Active Query Builder .NET Edition 2.10.3.747 (Oct 20, 2015)

  • Delay on opening the Add Object Form on large database schema is significantly reduced.

New in Active Query Builder .NET Edition 2.10.3.746 (Oct 20, 2015)

  • SQL Server: Indetermination on parsing of method call is fixed.
  • MySQL: Loading of referencing objects is corrected.

New in Active Query Builder .NET Edition 2.10.3.744 (Oct 20, 2015)

  • Oracle: CYCLE identifier parsing is fixed.
  • The exception in sub-query statistics is eliminated.
  • The exception in CTE queries when syntax provider is disposing is fixed.

New in Active Query Builder .NET Edition 2.10.3.742 (Oct 20, 2015)

  • Hotfix: Exception on adding the same table on the design pane twice is eliminated.

New in Active Query Builder .NET Edition 2.10.3.741 (Oct 20, 2015)

  • SQL Text Editor: Keywords and functions dictionaries for Netezza syntax are added.
  • Netezza: Automatic server detection is fixed.
  • Crash in the Query Structure Demo sample project is fixed.

New in Active Query Builder .NET Edition 2.10.3.739 (Oct 20, 2015)

  • Criteria Builder is significantly improved:
  • It is now syncronized with the QueryTransformer object both ways.
  • The new SQLUpdated event is added. It is fired after any change in the items when all items are valid.
  • The new "is empty" and "is not empty" operators are added for string columns.
  • Most of the string operators are applied to for columns with unknown data type.
  • Processing of LIKE-derived operators for columns with unknown types isfixed.
  • The ValidateDataType event was not fired for column with custom SQLexpression in some cases. Fixed now.
  • The Null reference exception when pressing the lookup button for column with custom SQL expression is eliminated.

New in Active Query Builder .NET Edition 2.10.2.735 (Oct 20, 2015)

  • New utility methods are added: QueryBuilder.ClearMetadata() and MetadataStructure.Clear().
  • Query Transformer: MySQL-specific issue with ORDER BY is fixed.

New in Active Query Builder .NET Edition 2.10.2.733 (Oct 20, 2015)

  • The QueryTransformer.ImportFromXML() method is fixed.
  • Criteria Builder: Parsing of columns with alternate names is fixed.

New in Active Query Builder .NET Edition 2.10.2.732 (Oct 20, 2015)

  • Custom draw for database schema tree nodes is restored.

New in Active Query Builder .NET Edition 2.10.2.730 (Oct 20, 2015)

  • Expression Editor and SQL Text Editor: Syntax suggestions and coloring did not work for Generic and Auto syntax providers. Fixed now.

New in Active Query Builder .NET Edition 2.10.1.726 (Aug 12, 2015)

  • Netezza: Parsing of fully qualified names from default schema is fixed.
  • Polish localization is updated.
  • Minor resource handles leaks are fixed.

New in Active Query Builder .NET Edition 2.10.1.725 (Aug 12, 2015)

  • Support for Visual Studio 2015 is added.
  • Query Structure Tree: Object names appearance is changed.
  • Query Column List: Output and Alias columns are renamed to Visible and
  • Column Name; Aggregate column is moved closer to Grouping.

New in Active Query Builder .NET Edition 2.10.0.723 (Aug 12, 2015)

  • Support for IBM Netezza SQL syntax is added.

New in Active Query Builder .NET Edition 2.9.7.721 (Aug 12, 2015)

  • Support for Advantage Database Server syntax is added.
  • DevExpress references are updated to 15.1.4.0.
  • PostgreSQL: Parsing of ANY, SOME, ALL predicates is fixed.
  • Query Statistics: The StatisticsField.Selected property is fixed.

New in Active Query Builder .NET Edition 2.9.6.720 (Aug 12, 2015)

  • The bug with odd fields references removed from derived table is fixed.
  • The bug with aliases in ORDER BY when SQL syntax doesn't support them is fixed.
  • The crash on displaying the derived query datasource object containing an expression without alias is eliminated.

New in Active Query Builder .NET Edition 2.9.6.717 (Aug 12, 2015)

  • Weird WinForms TreeView behaviour with very long internal painting operations on dispose is corrected.
  • Malformed foreign keys loaded from manually created XML files are ignored now.

New in Active Query Builder .NET Edition 2.9.6.716 (Aug 12, 2015)

  • The bug with odd HAVING clause when disabling grouping in the grid is fixed.

New in Active Query Builder .NET Edition 2.9.6.715 (Aug 12, 2015)

  • DB2: Fixed parsing of VALUES clause.

New in Active Query Builder .NET Edition 2.9.6.714 (Aug 12, 2015)

  • DataSourceFieldAdding and DataSourceFieldAdded events were not fired when
  • adding a field from the database schema tree with double click or drag and
  • drop. Fixed now.
  • QueryTransformer: Where, ResultOffset and ResultCount now checks given value
  • is valid expression.

New in Active Query Builder .NET Edition 2.9.6.712 (Aug 12, 2015)

  • All manually entered aliases are quoted by default now.
  • QueryTransformer.OrderBy: Check the param string is valid expression.
  • Applying limits for MS SQL Server 2014 is fixed now.

New in Active Query Builder .NET Edition 2.9.5.709 (Mar 24, 2015)

  • Parameter.CompareOperator is now set correctly for complex expressions compared with parameter using the Like operator.

New in Active Query Builder .NET Edition 2.9.5.708 (Feb 25, 2015)

  • DevExpress: Drawing of items in the dropdown of the QueryColumnListControl combobox for some themes is fixed.
  • MS SQL Server: Object name is now used as default alias for objects from linked servers.

New in Active Query Builder .NET Edition 2.9.5.705 (Feb 25, 2015)

  • Teradata: Loading of foreign keys is fixed.
  • Criteria Builder: The bug with decimal separator in value editor when separator in system regional settings it's not the dot is fixed.
  • Oracle: Parsing of the "REFERENCE" keyword is fixed.
  • Null exception on condition clearing is eliminated.
  • DevExpress references are updated to v.14.2.4.0.

New in Active Query Builder .NET Edition 2.9.5.704 (Feb 25, 2015)

  • The bug with adding FETCH FIRST clause using the Query Properties dialog is fixed.
  • DB2: Metadata objects loading is improved for older mainframes: fallback to QSYS2.SYSTABLES is made.

New in Active Query Builder .NET Edition 2.9.5.703 (Dec 18, 2014)

  • The MetadataContainer.AbortMetadataLoading() method is fixed. Use it in the metadata loading event handlers to cancel the process.
  • Dragging of brackets in the Union Navigation Bar is fixed.
  • MS SQL Azure: Metadata loading is improved.

New in Active Query Builder .NET Edition 2.9.4.701 (Dec 10, 2014)

  • VistaDB5MetadataProvider is added for VistaDB 5 database engine.
  • VistaDBMetadataProvider and VistaDB4MetadataProvider are discontinued, but available in source code by request.

New in Active Query Builder .NET Edition 2.9.0.700 (Nov 27, 2014)

  • Exception in discarded invisible controls is eliminated.

New in Active Query Builder .NET Edition 2.9.0.699 (Nov 13, 2014)

  • DevExpress UI: The bug with duplication of sub-menu items is fixed.

New in Active Query Builder .NET Edition 2.9.0.698 (Nov 12, 2014)

  • DevExpress: Context menus in all components are skinned now.
  • API change: Signature of the ValidateContextMenu event delegate is changed. see the updated Events Demo for menu modification example.
  • Swedish localization is updated.

New in Active Query Builder .NET Edition 2.9.0.697 (Nov 10, 2014)

  • MS Access: Type cast exception when using query limits is fixed.
  • The new MetadataLoadingOptions.IgnoreNumericPrecisionForNonNumericTypes property is added to extract informaiton about precision for non-numeric types even the value of this information is questionable (False by default).

New in Active Query Builder .NET Edition 2.9.0.695 (Nov 10, 2014)

  • The new events are added to track user search actions in the Database Schema Tree: QueryBuilder.BeforeQuickSearchStarted and QueryBuilder.QuickSearchFinished. The first event allows to cancel search action, the second event provides the number of found items.
  • SQL Text Editor: The new properties are added to allow changing colors of gutter area: GutterForeColor, GutterBackColor, GutterSeparatorColor.
  • Query Transformer: The new AlwaysWrapInSubQuery property prescribes to wrap user query in a sub-query in any case.
  • Precision and Scale properties of MetadataField aren't filled for non-numeric columns now.
  • Metadata Editor: Objects of UserQuery type are hidden now from the database schema tree.

New in Active Query Builder .NET Edition 2.9.0.694 (Oct 28, 2014)

  • The new MetadataStructureChanged event is added. It is fired on changing the value of MetadataStructure property. This happens automatically on changing of the Database Schema Tree search term.

New in Active Query Builder .NET Edition 2.9.0.693 (Oct 28, 2014)

  • Null Reference Exception that was raised with some databases using the "Type, Name (Except Fields)" sorting mode in the tree is eliminated.
  • Query Transformer and Criteria Builder: The new OutputColumn.DataType property is added to adjust the column datatype to change the editor type in Criteria Builder for this column.

New in Active Query Builder .NET Edition 2.9.0.692 (Oct 27, 2014)

  • CriteriaBuilder: AutoSize and Anchor properties conflict is resolved.
  • DevExpress: List sorting in the AddObjectForm is fixed.
  • The new MetadataContainer.Clear() method is added.

New in Active Query Builder .NET Edition 2.9.0.691 (Oct 27, 2014)

  • New overload is added for the ShowAddObjectForm() method with the MetadataStructure parameter allowing to customize metadata representation in the form.
  • The new QueryColumnListOptions.CreateColumnAliasesForUnnamedColumns property is added to instruct the component to add aliases for unnamed fields (expressions, aggregates) automatically. It's turned on by default.
  • SQLite: Support for Common Table Expressions (CTE) is made.
  • SQLite: Support for backtick-quoted identifiers is made.
  • Firebird: Support for the WEEK date part is added.
  • MySQL: Support for quoted characters in string literals is made.

New in Active Query Builder .NET Edition 2.9.0.690 (Oct 22, 2014)

  • The bug with hanging on foreign keys loading being connected through the ADO.NET provider which uses non-standart schema column names (like Devart.Data.Oracle provider) is fixed.

New in Active Query Builder .NET Edition 2.9.0.689 (Oct 16, 2014)

  • The bug on calling the QueryBuilder.Clear() in non-visual mode is fixed.
  • DevExpress: Sorting in the Database Schema Tree is fixed.
  • Query Transformer: The problem with duplicated column names is fixed.

New in Active Query Builder .NET Edition 2.9.0.685 (Oct 6, 2014)

  • Oracle: Expression parsing performance is improved.
  • The bug with incorrect column prefix for virtual objects in selected columns is fixed.

New in Active Query Builder .NET Edition 2.9.0.684 (Sep 29, 2014)

  • The new feature "User Queries" is added to allow for creation of reusable virtual objects containing a previously saved query.
  • The new "Reusable Queries" pane is added below the Database Schema Tree.
  • Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide this pane. To save and load ueser queries use import/export methods of the QueryBuilder.UserQueries object.
  • The Show Query By Parts demo is replaced with the improved SubQuery Results Preview demo.
  • Query Transformer now supports Skip() with ROW_NUMBER ranking function for DB2 and MS SQL Server 2005-2008.
  • MS Access: Query Transformer is able to use Limit() with MS Access now.
  • MS SQL Server: The mistyped DATETIMEOFFSETFROMPARTS function name is corrected.
  • DevExpress: Crash on Delete command of the CTE tab context menu is fixed.
  • The bug on closing last datasource in CTE is fixed.

New in Active Query Builder .NET Edition 2.8.3.682 (Sep 18, 2014)

  • DevExpress: Painting of focused items in some controls is corrected.
  • A fix for the problem with some types of recursive CTE is made.

New in Active Query Builder .NET Edition 2.8.3.680 (Sep 10, 2014)

  • DevExpress: The bug with quotation of fields when creating link between data sources by drag and drop is fixed.
  • Now using case-insensitive comparison to detect datasource alias conflicts.

New in Active Query Builder .NET Edition 2.8.3.677 (Sep 10, 2014)

  • The database schema tree crash on schema containing no objects is fixed.
  • PostgreSQL: Minor fix in schema list loading is made.
  • PostgreSQL: Support for RECURSIVE keyword in WITH clause is added.

New in Active Query Builder .NET Edition 2.8.3.676 (Sep 3, 2014)

  • The DevExpress Demo source code sample project is added for C# and VB.NET.
  • DevExpress references are updated to v.14.1.6.0.
  • The distributed DevExpressControlFactory module source code is fixed.

New in Active Query Builder .NET Edition 2.8.1.673 (Aug 27, 2014)

  • Oracle: Support for SEARCH and CYCLE clauses in CTE subqueries is made.
  • DB2: Foreign keys duplication is fixed.

New in Active Query Builder .NET Edition 2.8.1.672 (Aug 14, 2014)

  • MS SQL Server: OFFSET-FETCH clause is supported by Query Transformer.
  • Vertica: Information about foreign keys can be extracted using native DB connection.

New in Active Query Builder .NET Edition 2.8.1.671 (Aug 14, 2014)

  • MS SQL Server: IIF function and "WITHIN GROUP" clause are supported now.

New in Active Query Builder .NET Edition 2.8.1.670 (Aug 14, 2014)

  • MS SQL Server: Loading of foreign keys for SQL Server 2000 and earlier is fixed.
  • DevExpress references are updated to v.14.1.5.0.

New in Active Query Builder .NET Edition 2.8.1.669 (Aug 14, 2014)

  • Oracle: Loading of foreign keys and user aggregates by unprivileged user is fixed.

New in Active Query Builder .NET Edition 2.8.1.668 (Aug 5, 2014)

  • Dialling of the Add Object form while using the DevExpress UI is fixed.

New in Active Query Builder .NET Edition 2.8.1.667 (Aug 4, 2014)

  • PostgreSQL: Improper field names quoting for automatic links is fixed.

New in Active Query Builder .NET Edition 2.8.1.666 (Jul 30, 2014)

  • MS SQL Server: New MSSQL 2012 analytic functions are added.
  • Universal Metadata Provider: Support for Vertica ADO.NET client is made.

New in Active Query Builder .NET Edition 2.8.1.665 (Jul 29, 2014)

  • Professional version: User interface of Advanced Expression Editor, SQL Text Editor and Criteria Builder is available in DevExpress controls.
  • Database Schema Tree performance is improved.
  • PostgreSQL: Parsing of ROW clause is speeded up.
  • PostgreSQL: Metadata loading is speeded up.
  • Criteria Builder: Database lookup is fixed.

New in Active Query Builder .NET Edition 2.8.1.664 (Jul 29, 2014)

  • Parsing of long qualified names for some SQL syntaxes is fixed.

New in Active Query Builder .NET Edition 2.8.1.663 (Jul 28, 2014)

  • Loading of LayoutSQL property values created in version 1.x is fixed.
  • Oracle: Database links are fixed.

New in Active Query Builder .NET Edition 2.8.1.662 (Jul 28, 2014)

  • The height of datasources stored in LayoutSQL was lost on restoring the layout. Fixed now.

New in Active Query Builder .NET Edition 2.8.1.661 (Jul 28, 2014)

  • The DataSourceGroup.FindTablesByDBName() method is fixed.

New in Active Query Builder .NET Edition 2.8.1.660 (Jul 28, 2014)

  • Cross-thread InvalidOperationException caused by Quick Search is fixed.

New in Active Query Builder .NET Edition 2.8.1.659 (Jul 4, 2014)

  • Identifiers quotation in datasource captions is removed.

New in Active Query Builder .NET Edition 2.8.1.658 (Jul 4, 2014)

  • DevExpress references are updated to v.14.1.4.0.

New in Active Query Builder .NET Edition 2.8.1.657 (Jun 19, 2014)

  • Fixed loss of MetadataItem.UserData when MetadataItem is copied.

New in Active Query Builder .NET Edition 2.8.1.656 (Jun 19, 2014)

  • DevExpress references are updated to v.14.1.3.0

New in Active Query Builder .NET Edition 2.8.1.655 (Jun 19, 2014)

  • The new MetadataItem.UserData property is added to allow storing custom data for any metadata object.

New in Active Query Builder .NET Edition 2.8.1.654 (Jun 19, 2014)

  • MS Access: The parser now accepts identifiers quoted with backticks and convert them to square brackets.
  • PostgreSQL: Parsing of common table expressions (CTE) is fixed.
  • The crash on clicking on the Linked Objects button of sub-query data source is fixed.
  • The Linked Objects menu now shows "No linked objects" item if no linked objects were found.

New in Active Query Builder .NET Edition 2.8.0.653 (Jun 19, 2014)

  • MS SQL Server Compact Edition: Version autodetection is fixed.
  • Full-Featured Demo: Support of alternate names is added.
  • Link expressions were not updated on metadata changes. Fixed now.

New in Active Query Builder .NET Edition 2.8.0.652 (Jun 19, 2014)

  • Generic Syntax Provider: Microsoft SQL Server Compact Edition autodetection is fixed.
  • Empty brackets in datasource captions in some cases are fixed.

New in Active Query Builder .NET Edition 2.8.0.650 (Jun 19, 2014)

  • MS SQL Server: Parsing of aggregated functions is fixed.
  • DB2: Parsing of Hex, Graphics and Unicode string literals is fixed.
  • MS Access: Built-in functions list is fixed.
  • Minor fix in language files is made.

New in Active Query Builder .NET Edition 2.8.0.649 (Apr 17, 2014)

  • Major improvements:
  • Support for MS SQL Server 2014 is added.
  • Quick Search in the Database Schema Tree is now able to search by field names. Use the new property DatabaseSchemaTreeOptions.SearchFields to enable this feature.
  • Quick Search now respects alternate object names if available.
  • Database Schema Tree now emphasizes the search string with underscore.
  • The Add Linked Objects menu now has separate items for each link if there are multiple links to the linked object.
  • Add Object Form: The "Show all objects..." item is shown among with the list of metadata structure nodes (usually namespaces). Double clicking on it displays flat list of all underlying objects.
  • Minor improvements and API changes:
  • Query Column List Control now commits changes when you getting the QueryBuilder.SQL property.
  • CTE column aliases list is updated now when the underlying sub-query is changed by the user.
  • The new BehaviorOptions.NotifyOnLinksCreatedAutomatically property is added to let track addition of automatically created links (by foreign keys or by identical field names) using the LinkCreated event.
  • Generic Syntax Provider: Ability to define custom user-defined SQL generation rules (quotation symbols, case sensitivity of identifiers, etc.) is made.
  • The new properties are added to control description tooltips over the datasources and database schema tree. The ShowDescriptionTooltips and DescriptionTooltipsDelay properties are added to the DataSourceOptions and DatabaseSchemaTreeOptions groups.

New in Active Query Builder .NET Edition 2.6.1.618 (Dec 20, 2013)

  • Criteria Builder: Referenced table lookup is made.
  • Criteria Builder: Filtration of lookup list values by text from the text box is made.
  • Criteria Builder: Database lookup for handy value selection is made.
  • Query Transformer: Hiding of output values and setting the type of select statement (DISTINCT, ALL) is possible now.
  • Installer: Support for Visual Studio 2013 is made.

New in Active Query Builder .NET Edition 2.5.1.599 (Oct 4, 2013)

  • The new button is now shown at the right of the focused datasource on Design pane to allow easy adding of linked objects to the query.
  • Criteria Builder is significantly improved:
  • Criteria Builder can be localized now.
  • Data type validation is made.
  • Ability to work with general conditions is added.
  • UI is improved.
  • Query layout is now preserved after parsing of the modified query.
  • The new DesignPaneLayoutChanged event is added.
  • Generic and ANSI SQL syntaxes now detect support of database and schema namespaces automatically.
  • Alternate Names now obey server identifier case sensitivity rules.
  • Table hints are updated according to the SQL Server 2012 specification.
  • Metadata loading from MS SQL Server Azure is fixed.
  • Usage of aliases in ORDER BY is corrected.
  • Other minor fixes and improvements are made.

New in Active Query Builder .NET Edition 2.4.0.580 (Jul 19, 2013)

  • The new CriteriaBuilder control is made for visual composing of criteria.

New in Active Query Builder .NET Edition 2.3.1.575 (Jun 19, 2013)

  • The new QueryTransformer component is added. It is intended to easily programmatically modify sorting, add filtration, aggregation and limits to SQL queries.
  • SQL Text Editor: The new properties are added to improve usability of the code completion feature and to prioritize the content of suggestion lists:
  • The ShowSuggestionAfterCharCount property determines number of chars that should be typed before the suggestion list will popup;
  • The SuggestionListContent property allows to filter the content of suggestion list (keywords, SQL functions and metadata objects);
  • The KeepMetadataObjectsOnTopOfSuggestionList property being set to True instructs to act exactly what is written.
  • SQL Text Editor: The WordWrap property is added.
  • SQL Text Editor: Performance is improved.
  • The new MetadataContainer.ConnectionIdle event is added. It allows for closing the database connection if it's not desirable to keep it open during the work session.
  • The new events are added to BaseMetadataProvider: BeforeSqlExec and AfterSqlExec. They might be useful for tracing SQL queries sent to the database server.
  • Oracle: Optimizer hints can be edited via the Query Properies dialog.
  • Other minor fixes and improvements are made.

New in Active Query Builder .NET Edition 2.2.1.558 (Apr 5, 2013)

  • Teradata SQL syntax is made.
  • Localizations are updated.
  • Handling of selection and indentation in the SQL Text Editor is improved.
  • Tooltips are shown now for fields in the datasources on design pane and for nodes of the database schema tree.
  • Metadata Editor can generate nodes of the metadata structure tree according to the physical database schema. This can ease design of custom metadata structure.
  • The new properties are added to the query statistics output columns to ease SQL modification according to the user actions to sort and filter data in resultset: ObjectNameInQuery and ColumnNameInQuery. The new demo that implements this scenario will be available soon.
  • The new property to define command timeout is added to the metadata providers.
  • Other minor fixes and improvements are made.

New in Active Query Builder .NET Edition 2.1.1.538 (Dec 17, 2012)

  • The overview window is added to the right bottom corner of the Design Pane to navigate over the large query diagrams.
  • The QueryBuilder.PanesConfigurationOptions property group now has the necessary properties to configure this window.
  • Ability to work without the Design pane is made.
  • It allows for easier query building process for relatively small databases in which the relations between database objects are clear enough so they won't require to be visualized. Read the Working without the Design Pane article for details.
  • Right-to-left layout and reading direction are implemented.
  • Use the RightToLeft and RightToLeftLayout properties to setup this functionality.
  • Documentation is updated.
  • Documentation in HTML Help format (CHM) is added to the installation package.
  • Massive fixes in the DevExpress controls factory are made.
  • Other minor fixes and improvements are made.

New in Active Query Builder .NET Edition 1.11.0.0 (Oct 27, 2009)

  • Support of VistaDB 4 and custom aggregate functions for MS SQL Server, Portuguese (Brazil) translation is added.

New in Active Query Builder .NET Edition 1.10.0.0 (Aug 18, 2009)

  • Support of DevExpress DXperience controls is made, Firebird 2.5 support is added.

New in Active Query Builder .NET Edition 1.9.0.0 (May 19, 2009)

  • Now it is possible to change join type via context popup menu.
  • Now the user can edit Join expression manually via the Link Properties dialog.
  • The new menu item is added to the Union Sub-Query context menu to copy the current union sub query to a new one.
  • The "Move forward" and "Move backward" Union Sub-Query context menu items are renamed to the "Move left" and "Move right" for better understanding.
  • Now you can invoke the Query Properties dialog with double click on the diagram pane.
  • Now you can drag and drop fields from datasource objects right onto the criteria list (grid).
  • Double click on a datasource field adds it to the criteria list now.
  • General improvements:
  • The component produce an empty query string on empty query builder now.
  • More optimal grid filling is made when loading criteria and select list items.
  • On saving metadata to XML file in Offline mode, the query builder does not try to load missing object columns from database now. This allows to cache database objects without their fields in XML file. Metadata caching example is added to the Full Featured Demo project.
  • The LoadMetadataDemo is modified. Demonstration of loading metadata from a stored DataSet is added.
  • Metadata XML schema is updated.
  • The User's Guide is updated.
  • API improvements:
  • New events are added to control adding of new expressions from the query building area (by clicking a checkbox, double-clicking a field or dragging them to the grid): DatasourceFieldAdding, DatasourceFieldAdded.
  • The new DenyIntoClause property is added to MSAccessSyntaxProvider, MSSQLSyntaxProvider and MySQLSyntaxProvider to allow/deny usage of the INTO clause in SQL queries.
  • The new property FieldListOptions.SortType allows to sort data source fields by name or description.
  • The new property FieldListOptions.KeyFieldsFirst allows to keep primary key fields always on the top of the field lists.
  • The new property StatisticsOutputColumn.MetadataObject is added.
  • Two new properties are added to define cardinality of relations between database objects: MetadataRelation.KeyCardinality and ChildCardinality.
  • SQL Syntax improvements:
  • PostgreSQL: Support of INTO clause is added.
  • DB2: Query Properties dialog is added.
  • MS SQL Server: Ranking functions are supported now.
  • MS SQL Server: Loading synonyms info for SQL Server 2005 is made.
  • DB2, PostgreSQL, Firebird and ANSI SQL/92: "NULLS FIRST/LAST" support is added.
  • Firebird: Empty brackets are suppressed now for stored procedures in the FROM clause.
  • Oracle: Missing "MONTH", "DAY", "HOUR" and "MINUTE" keywords are added.
  • Oracle: query builder now loads only metadata objects with granted SELECT right.
  • Informix syntax: The bug with case sensitivity settings is fixed.
  • MySQL: Missing "QUARTER" and "WEEK" functions are added.

New in Active Query Builder .NET Edition 1.5.6.96 (Apr 2, 2008)

  • DB2 syntax: Bug with correlation clauses is fixed.