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

Active Query Builder ActiveX Edition Changelog

What's new in Active Query Builder ActiveX 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 ActiveX Edition 1.35.3.0 (Feb 28, 2024)

  • Minor drawing issues are fixed.

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

  • Pervasive: metadata loading is improved.

New in Active Query Builder ActiveX 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 ActiveX 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 ActiveX Edition 1.34.0.0 (Sep 20, 2023)

  • Redshift: Metadata extraction is fixed.

New in Active Query Builder ActiveX 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 ActiveX 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 ActiveX 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 ActiveX Edition 1.31.14.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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX Edition 1.31.6.0 (Nov 11, 2021)

  • Minor internal optimizations were made.

New in Active Query Builder ActiveX 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 ActiveX 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 ActiveX 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 ActiveX Edition 1.31.2.0 (Oct 8, 2021)

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

New in Active Query Builder ActiveX Edition 1.31.1 (Oct 6, 2021)

  • It is now possible to Show/Hide Unused fields for all objects on the Design Pane via the context menu
  • Minor interface improvements for datasource fields filtration are made
  • Better placement of new datasources on the query diagram is made
  • Informix: The bug with missing built-in functions has been fixed
  • Oracle: The bug with queries containing DbLink objects has been fixed
  • A memory leak is fixed

New in Active Query Builder ActiveX 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 ActiveX 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 ActiveX 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 ActiveX Edition 1.30.7 (Dec 31, 2020)

  • Support for the QuickBooks SQL syntax is added (xsQuickBooks = 140)
  • PostgreSQL: Support for parenthesised subqueries has been added.
  • Informix: Support for the LIMIT clause is added.
  • Generic SQL syntax: Support for ABS built-in function is added.
  • MySQL: The bug with the special syntax of POSITION has been fixed.

New in Active Query Builder ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX 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 ActiveX Edition 1.29.3 (Jan 22, 2019)

  • Turning off grouping in the query via the global Grouping checkbox in the header of Query Columns List may lead to inconsistent queries. Fixed now.
  • PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE clauses have been fixed.

New in Active Query Builder ActiveX 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 ActiveX 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 ActiveX Edition 1.28.7 (Mar 16, 2018)

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

New in Active Query Builder ActiveX 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 ActiveX Edition 1.28.5 (Mar 1, 2018)

  • Initial support of Pervasive SQL syntax has been added.
  • 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 ActiveX 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 ActiveX Edition 1.28.3 (Dec 19, 2017)

  • Help strings for new properties have been added.
  • MS SQL Server: The DB_NAME function is used now to the get current db name
  • on MS SQL Server 2008 and higher.

New in Active Query Builder ActiveX 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 ActiveX Edition 1.28.0 (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 ActiveX Edition 1.27.10 (Aug 29, 2017)

  • The new property ISelectListOptions.DropdownInExpressionColumn has been added. Turn it off to hide the drop-down list in the Expression column of the Query Columns Grid.

New in Active Query Builder ActiveX Edition 1.27.9 (Aug 17, 2017)

  • Localization fixes in Properties forms have been made.
  • Correct column prefix is emitted for procedures and table-valued functions.
  • Minor memory leaks have been eliminated.

New in Active Query Builder ActiveX Edition 1.27.8 (Aug 3, 2017)

  • Icons in the Union Navigation Bar and Query Columns List control are correctly scaled now on High DPI monitors.
  • ODBC: Metadata filters are now applied on loading objects from driver.

New in Active Query Builder ActiveX Edition 1.24.12 (Mar 25, 2015)

  • PostgreSQL: LIKE (ANY|SOME|ALL) is supported now.
  • Query Transformer: Construction of NOT BETWEEN condition is fixed.
  • Column aliases entered in the Query column list are always quoted now to preserve the case.
  • Query columns list height and columns width are preserved now on query reloading and manual SQL text changes.

New in Active Query Builder ActiveX Edition 1.24.11 (Mar 10, 2015)

  • Focus is not moved on mouse hover over datasources on the Design pane if the component is not focused.
  • Incorrect loading of ORDER BY is fixed.

New in Active Query Builder ActiveX Edition 1.24.10 (Feb 10, 2015)

  • Minor parsing speed improvements are made.

New in Active Query Builder ActiveX Edition 1.24.9 (Jan 21, 2015)

  • Scanner performance optimizations are made.

New in Active Query Builder ActiveX Edition 1.24.8 (Jan 21, 2015)

  • DB2: The query to load default schema is corrected for older mainframes.
  • DB2: Metadata objects loading is improved for older mainframes: fallback to QSYS2.SYSTABLES is made.
  • Loading join conditions with references to objects from parent query is fixed.
  • Loading FROM clause enclosed with parenthesis is fixed.
  • Memory leak is fixed.

New in Active Query Builder ActiveX Edition 1.24.7 (Dec 19, 2014)

  • SQLite: Support CTE at sub-queries level is added.
  • Oracle: Oracle8i compatibility fixes are made.
  • Comments parsing is fixed.

New in Active Query Builder ActiveX Edition 1.24.6 (Nov 14, 2014)

  • Support for AdvantageDB SQL syntax is made.
  • Set the SQLSyntax property to xsAdvantage=130 to select this syntax.
  • Minor bug fixes are made.

New in Active Query Builder ActiveX Edition 1.24.4 (Oct 29, 2014)

  • SQL parser fix is made. (affects all SQL dialects)

New in Active Query Builder ActiveX Edition 1.24.3 (Oct 22, 2014)

  • SQLite: Backtick quoted identifiers are supported now.
  • SQLite: Support for Common Table Expressions is made. It was added in SQLite v3.8.3 released on 2014-02-03.
  • The new property SelectListOptions.CreateColumnAliasesForUnnamedColumns is added to instruct the component to add aliases for unnamed fields
  • (expressions, aggregates) automatically. It is turned on by default.
  • MS SQL Server, DB2: QueryTransformer now uses ROW_NUMBER ranking function to implement Skip and Take methods for these servers.
  • Add Linked Objects menu now creates links for all fields for multi-column foreign keys (not only for the first field).
  • Error on deleting datasource in subquery is fixed.
  • MS SQL Server: Pound symbol is removed from the list of valid identifier letters.

New in Active Query Builder ActiveX Edition 1.24.0 (Oct 22, 2014)

  • The new SelectListOptions.ResolveColumnNamingConflictsAutomatically property is added to instruct the component to generate unique aliases for explicitly specified query columns to avoid duplicated column names.
  • PostgreSQL: RECURSIVE keyword in WITH clause support is added.
  • Parametrized queries are used now to fetch fields list for MS SQL Server and Oracle to reduce the load on the server when retrieving metadata.
  • Oracle: SearchClause and CycleClause in WithClauseItems is supported.
  • Case-insensetive comparison is used now when creating unique aliases.
  • MySQL: Quoted characters in string literals are supported now.
  • Firebird: WEEK date part support is added.

New in Active Query Builder ActiveX Edition 1.23.11.0 (Aug 28, 2014)

  • "No linked objects" menu item is shown if linked ojbects are not found.
  • MS SQL Server: Support for new analytic functions SQL Server 2012 is made.
  • Datasource is focused on mouse hover to display the linked objects button.

New in Active Query Builder ActiveX Edition 1.23.10.0 (Aug 28, 2014)

  • TacDatasourceControl.Collapsed property is fixed.
  • Fields list calculation for recursive CTEs is fixed.

New in Active Query Builder ActiveX Edition 1.23.8.0 (Jun 11, 2014)

  • QueryTransformer does not wrap query if limits are empty.
  • QueryTransformer obeys the QueryBuilder.SleepMode flag now.

New in Active Query Builder ActiveX Edition 1.23.7.0 (Jun 10, 2014)

  • Universal syntax: Query properties form to add DISTINCT clause is added, list of reserved words is extended.
  • MS Access syntax: It is possible to parenthesize complex join expressions as it's necessary when working with MS Excel.
  • OLE DB connection: Forced to sort list of fields by ordinal position.

New in Active Query Builder ActiveX Edition 1.23.6.0 (Jun 10, 2014)

  • MS SQL Server: A workaround for loading metadata via ODBC driver is made.

New in Active Query Builder ActiveX Edition 1.23.4.0 (Jun 10, 2014)

  • Small improvements in asyncronous SQL execution are made.
  • Demo projects: The RefreshMetadata method call after Connect is removed, as it is called automatically on connect.

New in Active Query Builder ActiveX Edition 1.23.3.0 (Jun 10, 2014)

  • MS Access: Backtick-quoted identifiers are accepted now. They will be converted to square brackets during the query generation.

New in Active Query Builder ActiveX Edition 1.23.2.0 (Jun 10, 2014)

  • Prevent races on RefreshMetadataAsync and RefreshMetadata calls.
  • Minor fixes in the Query Transformer are made.

New in Active Query Builder ActiveX Edition 1.23.1.0 (Jun 10, 2014)

  • Installer: Fixed problem with registration of the main OCX.
  • 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.

New in Active Query Builder ActiveX Edition 1.23.0.0 (Jun 10, 2014)

  • Asyncronous metadata loading support is made.
  • MS SQL Server: MS SQL Server 2014 is supported.
  • MS SQL Server: method call chain parsing is fixed.
  • MS SQL Server: keywords list is updated.
  • PostgreSQL: WITH clause support is made.
  • PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object columns (formerly used "LIMIT 1").
  • Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed.
  • Oracle: Interval expressions are supported now.
  • DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are supported now.
  • DB2: Short object names are used in case of SYSTEM naming convention.
  • MySQL: DATE and TIME types parsing ambuiguities fixed.

New in Active Query Builder ActiveX Edition 1.22.8.0 (Feb 27, 2014)

  • Add Linked Objects menu: Separate menu items are show now if there are many
  • links for a linked object.
  • MS SQL Server: Parsing of method calls is fixed.

New in Active Query Builder ActiveX Edition 1.22.7.0 (Jan 29, 2014)

  • MySQL: The KEY_COLUMN_USAGE is not queried if server version is less than 5.0.
  • Firebird: New builtin functions are supported.
  • Firebird: Special syntax of TRIM is supported now.
  • PostgreSql: Parser ambiguity in ROW expressions is eliminated.
  • Focus is not moved to the QueryBuilder anymore on assigning query text to the SQL property.

New in Active Query Builder ActiveX Edition 1.22.6.0 (Dec 20, 2013)

  • Windows 2000 compatible version is added to the "Compat" folder.
  • Required stack size for SQL parsing is reduced.
  • Custom popup menu is used for all Query Columns Grid cells now.
  • The RightToLeft mode is turned off for expressions in the Query Columns Grid.
  • Minor localization updates are made.
  • MS SQL Server: SQL parser is optimized to speed up parsing of deep nested
  • function calls.
  • MS SQL Server: PARSE is treated as valid identifier now.
  • MS SQL Server: Server version autodetection is fixed.
  • MS Access: Date/time builtin functions are supported.

New in Active Query Builder ActiveX Edition 1.22.5.0 (Nov 13, 2013)

  • PostgreSQL: The WINDOW clause is supported now.
  • PostgreSQL: The ORDER BY clause in aggregate functions is supported now.
  • PostgreSQL: The ROW constructor expressions are supported now.
  • PostgreSQL: The AT TIME ZONE is supported, the EXTRACT function is updated.
  • Linked Objects Menu: Linked object names are sorted alphabetically now.
  • Loading of WHERE joins with subqueries referencing other datasources is fixed.
  • Access Violation error when using miltiple Query Builders with ODBC connection string is fixed.

New in Active Query Builder ActiveX Edition 1.22.4.0 (Oct 31, 2013)

  • Oracle: Partition OUTER JOIN support is fixed.
  • MS SQL Server: Loading of relations is speeded up on SQL Server 2005 and higher.

New in Active Query Builder ActiveX Edition 1.22.3.0 (Oct 25, 2013)

  • Alias is printed before expression in the Query Structure Tree.
  • Oracle: National string literals are supported now.
  • Oracle: DENSE_RANK in partition clause is supported.
  • MS SQL Server: System views are used now to fetch foreign keys
  • for SQL Server 2005 and newer).
  • PostgreSQL: Support of multi-parameter aggregates is made.
  • PostgreSQL: Parsing of the ANY clause in codition cells is fixed.

New in Active Query Builder ActiveX Edition 1.22.0.0 (Oct 2, 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.
  • The new datasource context menu item is added for the same purpose.
  • MS Access: Parsing of the ASC builtin function is fixed.

New in Active Query Builder ActiveX Edition 1.21.7.0 (Sep 16, 2013)

  • Query layout is now preserved after parsing of the modified query.
  • Algorithm of automatic objects placement on the diagram pane is improved.
  • Small fixes for MSStyleGrouping mode are made.

New in Active Query Builder ActiveX Edition 1.21.4.0 (Jun 28, 2013)

  • Recently introduced bug that led to the emptiness of field lists is fixed.

New in Active Query Builder ActiveX Edition 1.21.1.0 (Jun 19, 2013)

  • PostgreSQL: LEFT and RIGHT builtin functions are supported now.

New in Active Query Builder ActiveX Edition 1.21.0.0 (May 31, 2013)

  • The new IQueryTransformer interface is added. It is intended to easily modify SQL query sorting, filtration and aggregation programmatically. You can get it's instance via the IActiveQueryBuilderX.QueryTransformer property.
  • The new properties are added to the ExpressionBuilderParams class that is
  • passed to the OnCustomExpressionEditor event handler: ExpressionKind (ekExpression, ekWhere or ekHaving), RelatedExpression, RelatedField, RelatedObject.
  • Internal change: Binding of column names is not performed now if fieldless
  • datasources are in the scope.
  • MySQL: The BINARY prefix operator is supported now.

New in Active Query Builder ActiveX Edition 1.20.4.0 (May 9, 2013)

  • Oracle: REGEXP_LIKE function is supported now.
  • Usage of aliases in ORDER BY is corrected.
  • MS Access: Support of aliases in ORDER BY clause is turned off.

New in Active Query Builder ActiveX Edition 1.20.3.0 (Apr 26, 2013)

  • Direct connection to ODBC data sources is possible now. You can simply assign
  • your ODBC connection string to the ConnectionString property.
  • "Check/Uncheck All" items are added to the context menu of derived table's
  • field list.
  • MS Access: LEFT and RIGHT are accepted as builtin function names now.
  • Grouping doesn't set now on assigning sort order for aggregated expressions.
  • Additional brackets are added now on loading conditions to a non-empty cell.
  • FieldsList.ItemHeight is updated now when TableFont is changed.
  • Alias quotation is removed in the Alias column.

New in Active Query Builder ActiveX Edition 1.20.2.0 (Apr 12, 2013)

  • Scrolling of partially visible items before check in DataSource check list box
  • is handled correctly now.
  • Aliases are emitted in the Order By clause when possible.
  • French localization is updated.

New in Active Query Builder ActiveX Edition 1.20.1.0 (Apr 8, 2013)

  • MS Access: Support of TRIM builtin function is added.
  • Incorrect loading of complex conditions fixed
  • Interbase: Parsing some builtin functions is fixed.
  • Interbase: EXTRACT function is supported.
  • Oracle: Named parameters in function calls are supported now.
  • Oracle: resolve ambiguity in parsing qualified column name with method call
  • Oracle: Support of CONNECT_BY_ROOT and preserving order of START WITH/CONNECT BY is made.
  • PostgreSql: Some date/time and system functions like CURRENT_DATE or USER
  • could not be quoted. Fixed now.

New in Active Query Builder ActiveX Edition 1.20.0.0 (Feb 28, 2013)

  • Greek translation is added.
  • The new "Add Union Sub-query" button is added to the Union navigation bar.
  • The new button is added to each datasource to collapse/expand it's field list.

New in Active Query Builder ActiveX Edition 1.19.11.0 (Feb 22, 2013)

  • Oracle: The DATE built-in function is added.

New in Active Query Builder ActiveX Edition 1.19.10.0 (Feb 22, 2013)

  • Firebird: ROWS clause is supported now.
  • The new IActiveQueryBuilderX.SelectListAlternateRowColor property is made to
  • mark even rows of the grid.

New in Active Query Builder ActiveX Edition 1.19.9.0 (Feb 19, 2013)

  • Teradata syntax provider is updated. Query properties form is revised.
  • 64-bit OCX is added to the root installation folder.
  • Oracle: Support for method call expressions is made.
  • Other minor bug fixes are made.

New in Active Query Builder ActiveX Edition 1.19.8.0 (Jan 28, 2013)

  • The x64 version is made.
  • The "CTE" prefix is added to the CTE sub-query tabs to distinguish them from other sub-queries.
  • Unnecesary parens are not written for nested conditions now.

New in Active Query Builder ActiveX Edition 1.19.7.1 (Jan 16, 2013)

  • Support of Teradata syntax is made. The xsTeradata (=120) constant should be assigned to the SQLSyntax property to use this syntax.
  • Conditions like "= @DT_START" are loaded into one cell now.

New in Active Query Builder ActiveX Edition 1.19.7.0 (Jan 16, 2013)

  • Oracle: Support for KEEP expression is added.
  • An algorithm of choosing datasources for links with complex expressions is
  • improved.
  • Double clicking on a datasource column moves focus to the first criteria cell
  • of the newly added criteria item.
  • Select item alias is used as subquery tab caption now.
  • Query Builder background and link colors are changed to system constants.
  • MS SQL Server: "PATH" is treated as a valid identifier now.
  • Sybase: FIRST clause is fixed.
  • Sybase: Query limit transformation is fixed.
  • Oracle: Usage of ANY, ALL and SOME in comparison expressions is fixed.
  • Interbase: ROWS clause is supported now.
  • MS SQL Server 2012: Parse and Try_Parse functions are supported.
  • MS SQL Server 2012: ROW and RANGE clause in OVER expression are supported.

New in Active Query Builder ActiveX Edition 1.19.6.0 (Nov 13, 2012)

  • The new syntax provider for MS SQL Compact Edition is made.
  • SQL Parser is speeded up.

New in Active Query Builder ActiveX Edition 1.19.5.0 (Nov 7, 2012)

  • Field List options: Column prefix and suffix do not drawn if a column is empty.
  • Calculation of optimal datasource height is fixed.

New in Active Query Builder ActiveX Edition 1.19.4.0 (Oct 29, 2012)

  • MS SQL Server: Tilda (~) is removed from the list of valid characters for
  • identifiers.
  • MS SQL Server: Support of varchar(max) is added.
  • A rare memory leak is fixed.

New in Active Query Builder ActiveX Edition 1.19.3.0 (Oct 8, 2012)

  • MySQL: Support of ampersand prefixed parameters is added.
  • MySQL: Support of JOIN and INNER JOIN without ON clause is made.
  • Localizer: Language files are opened now in share mode.
  • Maintaining optimal tables height in subqueries is fixed.

New in Active Query Builder ActiveX Edition 1.19.2.0 (Sep 25, 2012)

  • IActiveQueryBuilderX: The new DynamicIndents and DynamicRightMargin properties are added.

New in Active Query Builder ActiveX Edition 1.19.1.0 (Sep 12, 2012)

  • IActiveQueryBuilderX: The new DynamicIndents and DynamicRightMargin properties are added.

New in Active Query Builder ActiveX Edition 1.18.25.0 (Aug 31, 2012)

  • The newly added datasource height is set optimal according to the design area height when the MaxTableHeight property is set to default value (0).
  • MySql: The ":=" operator is parsed fine now.

New in Active Query Builder ActiveX Edition 1.18.24.0 (Aug 18, 2012)

  • Oracle: Printing of analytical expression specifier is fixed.
  • Firebird: CURRENT_USER, CURRENT_ROLE, CURRENT_TRANSACTION, CURRENT_CONNECTION constants are added.

New in Active Query Builder ActiveX Edition 1.18.23.0 (Aug 1, 2012)

  • Installer: Manifest ia added to require administrative rights.
  • PostgreSQL: Analytic expressions support is made.

New in Active Query Builder ActiveX Edition 1.18.22.0 (Jul 5, 2012)

  • Minor fix in Oracle server version detection is made.

New in Active Query Builder ActiveX Edition 1.18.21.0 (Jun 30, 2012)

  • Oracle: Processing of the IN clause with single value in set is fixed.
  • Oracle: The bug with the "TYPE" keyword is fixed.
  • Oracle: Support for the full syntax of XMLAGG aggregate function is made.
  • MySQL: Support for full syntax of TRIM function is made.

New in Active Query Builder ActiveX Edition 1.18.20.0 (May 28, 2012)

  • Exception on reading the QueryStatistics.QueryStructureXML property for a query with full outer joins is fixed.
  • Sybase: AV in the query roperties form is fixed.
  • DB2: Support for the MINUS alias of the EXCEPT union operator is added. Since it is just an alias, it will be automatically converted to EXCEPT.

New in Active Query Builder ActiveX 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 ActiveX Edition 1.13.0.0 (Aug 4, 2009)

  • Firebird 2.5 support is added.
  • Other minor improvements and bugfixes

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

  • The "Safe for scripting" and "Safe for initialization" flags are set now.
  • The new DenyIntoClause property is added to restrict building of SQL queries containing "SELECT INTO" clause.
  • The new properties are added to the IMetadataObject and IMetadataField interfaces: ShortDescription and LongDescription.
  • The new properties are added to get information about objects in the metadata container from the Query Statistics: IStatsFromObject.MetadataObject, IStatsUsedColumn.MetadataObject, IStatsUsedColumn.MetadataField, IStatsOutputColumn.MetadataObject, IStatsOutputColumn.MetadataField.

New in Active Query Builder ActiveX 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 ActiveX Edition 1.7.9 (Mar 29, 2007)

  • Chinese, Czech and Italian localizations are added.
  • Support of synonyms in Oracle is implemented.
  • Join object hints in MS SQL Server are supported now: WITH (nolock, repeatableread, ...).
  • MS SQL ranking and aggregate window functions and Oracle analytic functions are supported now.
  • Sub-queries in WITH clause now have support of field's aliases.
  • More precise erroneous token reporting.
  • Minor fixes in most of supported SQL dialects are made.
  • Several bugs are fixed.
  • The new property is added to control format of the ORDER BY clause:
  • VCL Edition: TSQLBuilderSelectFormat.OrderByFormat.NewLineAfterItem
  • ActiveX Edition: ISQLBuilderSelectFormat.OrderByNewLineAfterEachItem
  • New properties are added for fields to be stored in the Metadata Container: Size (Integer), Precision (Integer), PrimaryKey (Boolean), Nullable (Boolean), ReadOnly (Boolean). They are filled according to database structure and can be saved to XML file.
  • ActiveX Edition: New properties are added for fields to retrieve data type: IMetadataField.DataType, IStatsUsedColumn.DataType, IStatsOutputColumn.DataType.
  • The new (missing) properties are implemented to set width of query structure and database object trees:
  • VCL Edition: TreeOptions.TreeWidth
  • ActiveX Edition: TreeOptions.TreeWidth and TreeOptionsMetadata.TreeWidth
  • VCL Edition: AbsoluteDB Metadata Provider is implemented.
  • Several memory leaks are eliminated.

New in Active Query Builder ActiveX Edition 1.5.5 (Jul 3, 2006)

  • Active SQL Parser has full Unicode support now.
  • Ability to retrieve information about objects and columns being used in the query is implemented.
  • The new IdentCaseSens property is added to control the behavior of the ANSI syntax providers. This property determines whether an identifier should be quoted or not.
  • Other minor bugfixes and improvements.

New in Active Query Builder ActiveX 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 Users guide for end-users of Active Query Builder.
  • Now you may specify whether you want to display the standard error message.
  • Most memory leaks have been eliminated.
  • Other minor bugfixes and improvements.