Softpedia >Windows >Internet >Servers >Database Utils >Active Query Builder Free Edition >  Changelog

Active Query Builder Free Edition Changelog

What's new in Active Query Builder Free Edition 1.35.4.0

Apr 26, 2024
  • ANSI SQL/92, SQL/2003: Minor compatibility fixes are made.
  • Handling of the ORDER BY by column index for unnamed columns is fixed.
  • Pervasive: The bug with fields ordering is fixed.

New in Active Query Builder Free Edition 1.35.3.0 (Feb 28, 2024)

  • Minor drawing issues are fixed.

New in Active Query Builder Free Edition 1.35.2.0 (Feb 19, 2024)

  • Pervasive: metadata loading is improved.

New in Active Query Builder Free Edition 1.35.1.0 (Jan 26, 2024)

  • Oracle: Parsing expressions with parentheses is speeded up.
  • MySQL: Parsing of queries with "false" and "true" is speeded up.
  • MySQL: New aggregate functions are added.
  • Snowflake: The bug with some aggregate function names is fixed.
  • Snowflake: Support for POSITION and FLATTEN functions is made.
  • MS SQL Server: Support for WITHIN expression is made.

New in Active Query Builder Free Edition 1.35.0.0 (Nov 26, 2023)

  • Firebird: Server version autodetection is added.
  • Oracle: Support for percentile_cont, percentile_disc functions is added.
  • Denodo: Support for analytical functions is added.
  • New SQLSyntax constants were added: xsSnowflake = 150, xsFirebird4 = 83

New in Active Query Builder Free Edition 1.34.0.0 (Sep 20, 2023)

  • Redshift: Metadata extraction is fixed.222

New in Active Query Builder Free Edition 1.33.2.0 (Aug 17, 2023)

  • Support for Snowflake SQL syntax is made. The new TacSnowflakeSyntaxProvider is added.
  • Support for Firebird v.4 SQL is made. The new server version is added to TacFirebirdSyntaxProvider.
  • MySQL: Support for IS TRUE and IS FALSE clauses is improved.
  • PostgreSQL: The ambiguity on parsing TIMESTAMP type name is eliminated.
  • SQL Server: Parsing of the ZONE keyword as an identifier is fixed.
  • The crash if quotation symbol is not defined by the syntax is eliminated.

New in Active Query Builder Free Edition 1.33.1.0 (Jul 15, 2023)

  • PostgreSQL: Partitioned tables are fetched correctly now on schema load.
  • PostgreSQL: Parsing of the AT TIME ZONE operator is fixed.
  • MySQL: Support for Group_Concat function is added.
  • MySQL: Support for IS TRUE and IS FALSE operators is added.
  • Oracle: Ambiguities on parsing TIMESTAMP and DISTINCT clauses are eliminated.
  • SAP Hana: The bug with STRING_AGG function with ORDER BY clause is fixed.
  • MS SQL Server: Parsing of the AT identifier is fixed.

New in Active Query Builder Free Edition 1.33.0.0 (Apr 11, 2023)

  • SQL parsing preformance improvements and optimizations are made.

New in Active Query Builder Free Edition 1.32.5.0 (Mar 27, 2023)

  • MS SQL Server: Object names are used as default aliased for unaliased objects.
  • The crash if no fields were loaded when printing "table.*" is fixed.
  • The crash on wrapping a query into a subquery for some complex queries is fixed.
  • IBM DB2: The bug in the fields loading query for DB2 for AS/400 is fixed.
  • PostgreSQL: Parsing of dollar-quoted string literals is fixed.

New in Active Query Builder Free Edition 1.32.4.0 (Jan 21, 2023)

  • PostgreSQL: The API to add new aggregate functions is made as follows.
  • Var rootItems = queryBuilder1.MetadataContainer.Items;
  • Var agg = new MetadataAggregate(rootItems) { Name = "custom_agg" };
  • rootItems.Add(agg);
  • MySQL: Hanging on parsing queries with GROUP_CONCAT functions is fixed.
  • Crash on using the "Wrap Into Derived Table" feature for some queries is fixed.
  • Crash on drawing the datasource selection frame in rare circumstances is fixed.

New in Active Query Builder Free Edition 1.31.13.0 (Dec 3, 2022)

  • SQL Server: Alias is made required for table-valued functions to distinct them from tables with hints.
  • Oracle: Support for VALIDATE_CONVERSION built-in function is corrected.
  • Using correct field name in ORDER BY if query has set operators (UNION, etc.)
  • SAP Hana: Support for CHAR built-in function is fixed.
  • Minimal control size is decreased.

New in Active Query Builder Free Edition 1.31.13.0 (Jul 16, 2022)

  • Oracle: Type precision for NUMBER type is displayed now.
  • Pervasive: SQL parser ambiguity in datetime functions is eliminated.

New in Active Query Builder Free Edition 1.31.12.0 (May 19, 2022)

  • MySQL: Support for JSON extraction operators is added
  • Design Pane: Redrawing of datasource field lists is fixed
  • Design Pane: Minor HiDPI drawing fixes are made

New in Active Query Builder Free Edition 1.31.11.0 (May 6, 2022)

  • The load of conditions with double-negated logical fields, such as "not not
  • tbl.LogicalField" is fixed.
  • Denodo: The list of built-in functions is updated.
  • The bug on calling the EditProperties method on x64 platform is fixed.
  • The bug with MFC/ATL applications compiled in 64-bit mode with VC10 compiler and higher is fixed.

New in Active Query Builder Free Edition 1.31.10.0 (Apr 20, 2022)

  • The compatibility issue with MFC/ATL applications compiled by Visual Studio
  • 2019 and higher is fixed.
  • Query Columns List: Logical expressions such as EXISTS subqueries aren't set visible automatically, but used for filtration by default.

New in Active Query Builder Free Edition 1.31.9.0 (Apr 12, 2022)

  • Design Pane: Join type markers in MSSQL-style mode are scaled properly in
  • HiDPI resolutions now.
  • Query Column List: Row selection and re-ordering by mouse is fixed.
  • Query Column List: "=TRUE" is added automatically to the Criteria cell on
  • entering logical expressions like "EXISTS" sub-queries.
  • MS SQL Server: Support for "FOR JSON" clause is added.
  • MS SQL Server: Support of JOIN without type is added.
  • Oracle: Parsing of default value clause for conversion functions is fixed.
  • SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.
  • PostgreSQL: The DEFAULT token is added to the list of keywords.
  • InterBase: The bug with applying limits in the QueryTransformer is fixed.
  • SQLite: Extracting DateTime values from the parsed expression is fixed.

New in Active Query Builder Free Edition 1.31.8.0 (Feb 17, 2022)

  • SAP Hana: Support for analytic expressions is added.
  • MS SQL Server: The TIME built-in type parsing is fixed.
  • Pervasive DB: The ambiguity in the IF built-in function parsing is eliminated, so parsing is speeded up.
  • Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
  • The bug with OLE drag'n'drop registration for the select list grid control is fixed.

New in Active Query Builder Free Edition 1.31.7.0 (Jan 20, 2022)

  • Informix: The bug with the impossibility to use some keywords as identifiers is fixed.
  • MS SQL Server: Support for the "AT TIME ZONE" operator is added.
  • The exception on loading queries with index-referenced columns in ORDER BY is eliminated.
  • The bug on selecting the "Check all" action in the datasource field list for queries with grouping is fixed.
  • The exception on re-calculation of datasource control captions in some cases is eliminated.

New in Active Query Builder Free Edition 1.31.6.0 (Nov 15, 2021)

  • Design Pane: Datasources don't grab the focus on mouse hover now.
  • MySQL: Fields are fetched sorted by ORDINAL_POSITION now.
  • SQLite: A load of foreign keys is improved.
  • Metadata Filter: The exclusion filter condition generation for filter items with both non-empty SchemaMask and ObjectMask is fixed.

New in Active Query Builder Free Edition 1.31.5.0 (Nov 2, 2021)

  • The bug with loading images from named resources when ActiveQueryBuilder resources are compiled into a separate DLL (or BPL package) is fixed.

New in Active Query Builder Free Edition 1.31.4.0 (Oct 30, 2021)

  • SQLite: Date, Time and DateTime conversion built-in functions are added.
  • Firebird: CTE in subqueries are supported now.
  • Oracle: The bug with applying limits for server versions without OFFSET/FETCH support is fixed.
  • QueryTransformer: On the select list expansion, column aliases are assigned for all fields, not only for renamed ones.
  • The access violation error on deleting a datasource from the Design Pane is eliminated.

New in Active Query Builder Free Edition 1.31.3.0 (Oct 15, 2021)

  • The load of aqbx.cab is added to the HTMLDemo.
  • The ASPNetDemo is converted to the VS2005 format.

New in Active Query Builder Free Edition 1.31.2.0 (Oct 8, 2021)

  • The "Connect" button is fixed int the HTMLDemo.

New in Active Query Builder Free Edition 1.31.0 (Sep 30, 2021)

  • Now it's possible to filter fields in datasources on the Design Pane.
  • Informix: Support for databases, double-quoted strings, curly-braced comments are added; the keywords list is updated.
  • MySQL: ANSI_QUOTES server option autodetection is made.
  • The crash on adding CTE in some cases has been eliminated.

New in Active Query Builder Free Edition 1.30.10 (Mar 10, 2021)

  • The length of automatically generated aliases for single-word names is
  • Set to 3 characters; the maximum length is limited to 5.
  • MySQL: "PRECEDING" and "POSITION" clauses are fixed.

New in Active Query Builder Free Edition 1.30.9 (Feb 5, 2021)

  • The component generates short object aliases for objects added to the query if the ActiveQueryBuilderX.GenerateShortObjectAliases is set to True.

New in Active Query Builder Free Edition 1.30.6 (Dec 21, 2020)

  • MySQL: The bug with adding "=TRUE" or "=FALSE" for logical expressions has been fixed.
  • MySQL: The Tilda character "~" is removed from the set of valid characters for identifiers.
  • SAP Hana: TOP, DISTINCT, and PLACEHOLDER clauses are generated at the right place and order now.
  • OCX registration script is available for different platforms now.

New in Active Query Builder Free Edition 1.30.3 (May 23, 2020)

  • Design Pane: Datasource captions are made more contrast.
  • Usability of building queries with grouping has been improved by a series of small fixes.
  • Oracle: params and fields for stored procs, table functions loading fix
  • Oracle: Synonyms are loaded faster now.
  • Oracle: The bug in the QueryTransformer that led to incorrect query generation has been fixed.
  • SQL Server: Loading field comments for objects from non-default schemas and databases has been fixed.
  • PostgreSQL: Support for the WINDOW, FILTER clauses has been added.
  • SQLite: Support for the WINDOW and FILTER clauses and analytic expressions has been added.
  • SQLite, Teradata: Support for the REPLACE function has been fixed.
  • SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type, CURRENT_UTC* constants have been added.
  • SAP Hana: Metadata filters are applied now to metadata fetching queries.
  • SAP Hana: Working with table functions has been fixed.

New in Active Query Builder Free Edition 1.30.2 (Jan 14, 2020)

  • The unhandled exception on component destruction has been eliminated.
  • Universal SQL syntaxThe bug with TIMESTAMPADD and TIMESTAMPDIFF functions is fixed.

New in Active Query Builder Free Edition 1.30.1 (Dec 26, 2019)

  • The new paramValue.ParamsCount and paramValue.Params[index] properties are added to provide a reference to corresponding items of the Parameters collection which might be needed to detect the related field, object, and type for the parameter value.
  • The new paramValue.Expression property has been added to replace parameters
  • with SQL expressions in the SQL query text.
  • The ParameterValuesCanBeMacros property has been removed.
  • SAP Hana & ANSI Standard SQL Syntax: Support for the standard TRIM(LEADING/TRAILING ...) builtin function is added.
  • Oracle: Paging with ROWNUM has been fixed.
  • MySQL: Parsing of the MATCH full-text search expressions has been fixed.

New in Active Query Builder Free Edition 1.30.0 (Dec 19, 2019)

  • Now you can assign an SQL script with DECLARE and SET statements preceding
  • the SELECT query to the ActiveQueryBuilderX.FormattedSQL property.
  • The component will bypass statements preceding the first SELECT statement,
  • lets you edit the SELECT statement and get back the script with the
  • preceding statement and the modified SELECT statement.
  • The new properties ActiveQueryBuilderX.ParameterValues* are made to:
  • 1. cut off conditions with undefined parameter values,
  • 2. apply parameter values (scalar and lists where it's possible),
  • 3. replace parameters with SQL expressions in the query text.
  • Query Columns List: Handling of incomplete strings in expression cells
  • has been improved.
  • PostgreSQL: Support for WITH clause in subqueries has been added.

New in Active Query Builder Free Edition 1.29.11 (Oct 17, 2019)

  • SQL Text Editor: The content of suggestion list is now loaded and calculated in a background thread.
  • Minor bugs in the Query Structure Tree have been fixed.
  • Oracle: OFFSET/FETCH support for Oracle 12+
  • PostgreSQL: add DISTINCT ON support
  • New properties have been added to ANSI standard and Universal syntax providers: IsSupportDatabases and IsSupportSchemas.
  • Informix: Support for new built-in functions (LEFT, RIGHT) has been added.
  • Informix: Support for derived tables for IDS11+ has been made.
  • Informix: Objects from all schemas can be used without schema prefix.
  • PostgreSQL: Comparison operators precedence has been corrected.
  • PostgreSQL: Handling of "partial" expressions like "=1" is improved.
  • PostgreSQL: Filtration of camel-cased names using QueryTransformer has been fixed.
  • Pervasive: The bug with a dot before the table name has been fixed.

New in Active Query Builder Free Edition 1.29.8 (Jul 10, 2019)

  • Dot-prefixing objects with an empty schema for servers without database namespace support has been fixed.

New in Active Query Builder Free Edition 1.29.7 (Jul 10, 2019)

  • Dot-prefixing objects with an empty schema for servers without database namespace support has been fixed.

New in Active Query Builder Free Edition 1.29.6 (Jul 1, 2019)

  • New server versions are listed now for MySQL, MS SQL, Oracle syntaxes.
  • Link Properties Form: The single-line expression editor has been replaced with a memo field.
  • Visibility of the UnionNavBar is restored correctly now after updating the UnionTabSheet params.
  • SAP SQL Anywhere: Loading of objects for a non-privileged user has been fixed; modern views are used now for v.17 and higher.
  • Universal Syntax Provider: The detection of database and schema namespaces usage is performed now. It now works fine with the Absolute DB.
  • SQLite: Union operators list has been fixed.

New in Active Query Builder Free Edition 1.29.4 (May 8, 2019)

  • Dutch localization has been added.
  • The Query Structure Tree is improved. It is more sensibly organized and allows performing various actions with nodes using context menus.
  • MS SQL Server: Objects from linked servers without database or schema support are retrieved fine now.
  • MySQL: The default server version is set to 8.0.
  • Pervasive: Parsing of some built-in functions has been fixed.
  • Minor SQL formatting fixes and improvements have been made.
  • PostgreSQL: "table.*" is accepted now as an ordinary row expression term.
  • NexusDB: The list of reserved words has been updated.
  • SAP Hana: Support for missing functions has been added: LEFT, RIGHT and (REPLACE/SUBSTR/OCCURRENCES)_REGEXPR.
  • Scaling issues have been fixed.
  • The bug with not switching to the new subquery on creating a Derived Table has been fixed.

New in Active Query Builder Free Edition 1.29.0 (Dec 11, 2018)

  • Initial support of SAP Hana SQL syntax has been added.
  • Initial support of Pervasive SQL syntax has been added.
  • MySQL: Support for Common Table Expressions for MySql v8+ has been added.
  • Now it's possible to add and remove rows in the Query Columns List using the Alt+Insert and Alt+Delete keyboard shortcuts, move them up and down using the Alt+[Arrow Up/Down] keys.
  • Parsing of incorrect/incomplete "IN" expressions in condition cells of the Query Columns List has been improved.
  • The new properties have been added to the ActiveQueryBuilderX object to hide the controls for managing subqueries: SubQueryTabsVisible, UnionNavBarVisible.
  • The behavior of LinkOptions.CreateLinksByIdenticalFieldNames property has been changed. Links are created only if one of the fields is a part of the primary key.

New in Active Query Builder Free Edition 1.28.11 (Nov 19, 2018)

  • MySQL: Support for Common Table Expressions for MySql v8+ has been added.
  • Oracle: Support for ranking functions has been updated.
  • PostgreSQL: Parsing of the "AT TIME ZONE" clause and "EXTRACT(epoch FROM
  • ...)" function has been fixed.
  • MS Access: Parsing of the TRUE and FALSE constants has been fixed.
  • The Union Navigation Bar scaling issues have been eliminated.

New in Active Query Builder Free Edition 1.28.8 (Jul 14, 2018)

  • Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
  • Pervasive: List of keywords and functions has been filled.
  • Pervasive: Support of IF function, LIMIT/OFFSET clause has been made.
  • Pervasive: Parsing of date/time builtin functions has been fixed.
  • Teradata: The bug with the autodetection of new versions has been fixed.
  • SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing
  • exception now.
  • IBM DB2: NULL is parsed as a constant, not as an identifier.
  • The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed.
  • Links are created only if one of the fields is a part of the primary key.
  • Loading of Primary Key fields has been improved.
  • Complex SQL expressions aren't loaded as joins anymore.
  • Changing of the link type if RIGHT JOIN is not supported is not allowed now.
  • The bug with the height calculation of the UNION navigation bar when the
  • query has unions in brackets has been fixed.
  • Memory leaks have been eliminated.

New in Active Query Builder Free Edition 1.28.7 (Mar 16, 2018)

  • SQLite: The list of reserved words has been filled.

New in Active Query Builder Free Edition 1.28.6 (Mar 1, 2018)

  • Parsing of incorrect/incomplete "IN" expressions in condition cells of the Query Columns List has been improved.

New in Active Query Builder Free Edition 1.28.5 (Mar 1, 2018)

  • Initial support of Pervasive SQL syntax has been added.
  • DevExpress UI: Theme colors are applied automatically now.
  • Links cardinality calculation has been fixed.
  • MS SQL Server: Multi-column foreign keys loading for SQL Server 2005 and
  • higher has been fixed.
  • MySQL: Support of STDDEV function has been fixed.

New in Active Query Builder Free Edition 1.28.4 (Jan 27, 2018)

  • Index numbers in ORDER BY are converted to corresponding expressions now.
  • PostgreSQL parser has been optimized.
  • DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in an arbitrary order has been fixed.
  • Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
  • ODBC: Fetching of databases and schemas is supported now.

New in Active Query Builder Free Edition 1.28.3 (Dec 19, 2017)

  • Compatibility with the latest DevExpress 17.2 version.
  • MS SQL Server: The DB_NAME function is used now to get the current db name
  • on MS SQL Server 2008 and higher.

New in Active Query Builder Free Edition 1.28.2 (Dec 8, 2017)

  • The new property ILinkOptions.DefaultLinkType has been added. It determines the type of JOIN created on linking tables by drag'n'drop.
  • Possible values: dltLeft=0, dltRight=1, dltInner=2, dltFull=3.
  • The new properties to format WINDOW clause have been added to ISQLBuilderSelectFormat class: WindowNewLineAfterItem (bool), WindowNewLineBeforeComma (bool).
  • The new properties to format CASE and IF expressions have been added to ISQLBuilderSelectFormat class:
  • ConditionalOperatorsNewLineBeforeWhen (bool);
  • ConditionalOperatorsNewLineAfterWhen (bool);
  • ConditionalOperatorsNewLineBeforeThen (bool);
  • ConditionalOperatorsNewLineAfterThen (bool);
  • ConditionalOperatorsIndentExpressions (int): indents expressions in WHEN, THEN and ELSE parts of CASE operator;
  • ConditionalOperatorsIndentBranch (int): indents each WHEN branch of a CASE expression.
  • Sybase: Support of window functions has been added.
  • Teradata: Fetching fields from server system catalog has been speeded up.
  • Query Columns Grid: parsing of user input of criteria has been improved.
  • SQL Anywhere: Detection of new versions has been fixed.
  • Oracle: Unsupported comparison operators !> and !< have been removed.
  • SQL parsing has been speeded up.

New in Active Query Builder Free Edition 1.28.1 (Nov 17, 2017)

  • Descriptions for database objects and fields are shown in hints in the
  • Metadata Tree.
  • Minor SQL formatting improvements and bug fixes have been made.
  • MySQL: Default server version is bumped to v.5.7.
  • MySQL: The list of valid identifiers has been actualized.
  • MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been
  • made.
  • PostgreSQL: The ComparisonOperators syntax provider property now stores
  • only user-defined operators.
  • PostgreSQL: Support for "$n"-style positional params has been added.
  • Several fixes for high resolutions have been made.

New in Active Query Builder Free Edition 1.14.0.0 (Oct 27, 2009)

  • Support of custom aggregate functions for MS SQL Server, other fixes and improvements.

New in Active Query Builder Free Edition 1.13.0.0 (Aug 4, 2009)

  • Support of Firebird 2.5 is added.
  • Other improvements and bugfixes are made.

New in Active Query Builder Free Edition 1.12.0.0 (May 19, 2009)

  • End-user Interface improvements:
  • 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.
  • General improvements:
  • The component produce an empty query string on empty query builder now.
  • 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.
  • Loading fields descriptions into metadata container from OLE DB Provider is made.
  • More optimal grid filling is made when loading criteria and select list items.
  • All links to database objects and fields point directly to objects of Metadata container, not to their copies.
  • The internal visual controls destroying method is changed. Now all differences between SQL and SyncSQL properties are eliminated.
  • Metadata XML schema is updated.
  • The User's Guide is updated.
  • 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 Free Edition 1.11.5.0 (Feb 27, 2009)

  • Minor usability and syntax improvements, new properties and events to get control over the query building process.

New in Active Query Builder Free Edition 1.7.7 (Jan 12, 2007)

  • Added support for C Builder 5 IDE and BDS 2006 C Builder personality.
  • Ability to convert queries between dialects is implemented.
  • Spanish localization is added.

New in Active Query Builder Free Edition 1.7.5 (Dec 5, 2006)

  • Database Objects Tree is implemented.
  • Ability to localize the component is added.
  • Better handling of the asterisk item in SELECT list.

New in Active Query Builder Free Edition 1.5 (May 22, 2006)

  • Ability to to work with metadata is implemented.
  • Ability to build queries with objects from different databases is implemented.
  • Pre-filtering of database objects is implemented to speed up metadata loading process.
  • We have created the User’s guide for end-users of Active Query Builder.
  • Most memory leaks have been eliminated.
  • Other minor bugfixes and improvements.