Softpedia >Windows >Programming >Packers/Crypters/Protectors >Active Query Builder VCL Edition >  Changelog

Active Query Builder VCL Edition Changelog

What's new in Active Query Builder VCL Edition 1.33.2.0

Sep 19, 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.
  • SQL Text Editor: The drawing of very longs string is optimized.
  • 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.
  • TacMetadataContainer.SetDefaultSchemaNamesStr: The crash if quotation symbol is not defined by the syntax is eliminated.

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

  • SQL Text Editor: ActiveColor, InactiveColor properties are added to
  • TacFoldingProperties. TacFoldingProperties.Color property is obsolete now.
  • SQL Text Editor: The new SuggestionsContent property is added.
  • The SuggestionListContent property is obsolete now.
  • SQL Text Editor: The new event OnReloadSuggestionsList is added.
  • TacSqlScript: Statements separator is added now on adding a new statement to
  • the end of the script.
  • 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.
  • Criteria Builder: The bug with incorrect parsing of float values if
  • DecimalSeparator differs from default is fixed.

New in Active Query Builder VCL Edition 1.32.3.0 (Mar 6, 2023)

  • DevExpress: The crash on displaying popup menu is eliminated

New in Active Query Builder VCL Edition 1.31.14.0 (Dec 31, 2022)

  • Criteria Builder: Lots of UI and UX improvements and fixes are made.
  • TacBaseMetadataProvider: The new OnDataSetCreate event is added.
  • 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.
  • Delphi 6 and 5 minor string conversion issues are made.

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

  • TacCriteriaBuilder: Users can copy and paste the list of values for the "in list" operator conditions.
  • SQL Text Editor: Text editor actions auto-disabling is fixed.
  • SQL Text Editor: The selection after Undo/Redo is fixed.
  • TacFindAndReplace: New events OnFindAndReplaceDialogShow, FindAndReplaceDialogClose are added.
  • Oracle: Type precision for NUMBER type is displayed now.
  • Pervasive: SQL parser ambiguity in datetime functions is eliminated.

New in Active Query Builder VCL 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 VCL Edition 1.31.10.0 (Apr 20, 2022)

  • Criteria Builder: Minor usablility improvements and bug fixes are made.
  • Query Columns List: Logical expressions such as EXISTS subqueries aren't set visible automatically, but used for filtration purposes by default.

New in Active Query Builder VCL Edition 1.31.9.0 (Apr 20, 2022)

  • Criteria Builder: Entering values in the list editor is made easier
  • Enter now moves focus to the next item, Alt+Home/End shortcuts move focus to the first/last item in the list
  • Criteria Builder: Automatic transition between date parts in DateTime picker when typing is made
  • Criteria Builder: Icons are scaled properly in HiDPI resolutions now
  • Criteria Builder: Entering minutes same as months is fixed in the DateTime picker
  • 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 VCL 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 VCL Edition 1.31.6.0 (Jan 19, 2022)

  • Design Pane: Datasources don't grab the focus on mouse hover now.
  • SQL Text Editor: Gutter width is updated properly on Text Editor font changing.
  • 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 VCL 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 VCL 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 VCL Edition 1.31.3.0 (Oct 15, 2021)

  • SimpleFilter now supports object masks (%, _).
  • The Access Violation error on dragging objects from the Metadata Tree in
  • specific circumstances is eliminated.

New in Active Query Builder VCL Edition 1.31.2.0 (Oct 14, 2021)

  • The Access Violation in TacSqlTextEditor on assigning a semi-initialized
  • TacQueryBuilder with AutoSyntaxProvider has been eliminated.

New in Active Query Builder VCL Edition 1.31.1.0 (Oct 5, 2021)

  • Support for RAD Studio 11 Alexandria has been made.
  • 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.
  • TacSqlBuilder: The new property BuiltinFormat is added to determine the case of built-in functions and variables.
  • FireDACMetadataProvider: The new property LoadPkFieldsFromDriver is added todetermine whether it's needed to retrieve the information about primary keys using FireDAC Meta helpers or not.
  • TacSqlStatement: the Start property is renamed to StartPos, the new EndPos property is added.
  • The crash on adding CTE in some cases has been eliminated.
  • Simple Metatada Filter: The bug with the filter for case-sensitive columns is fixed.
  • Minor fixes in the TacQueryTransformer are made.

New in Active Query Builder VCL Edition 1.31.0.0 (Sep 30, 2021)

  • Support for RAD Studio 11 Alexandria has been made.
  • 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.
  • TacSqlBuilder: The new property BuiltinFormat is added to determine the case of built-in functions and variables.
  • FireDACMetadataProvider: The new property LoadPkFieldsFromDriver is added to determine whether it's needed to retrieve the information about primary keys using FireDAC Meta helpers or not.
  • TacSqlStatement: the Start property is renamed to StartPos, the new EndPos property is added.
  • The crash on adding CTE in some cases has been eliminated.
  • Simple Metatada Filter: The bug with the filter for case-sensitive columns is fixed.
  • Minor fixes in the TacQueryTransformer are made.

New in Active Query Builder VCL Edition 1.30.10.0 (Mar 10, 2021)

  • SQL Text Editor: Minor autocompletion fixes have been made.
  • 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.
  • FireDac Metadata Provider: The internal FireDac macro-expansion has been turned off as it breaks some servers.

New in Active Query Builder VCL Edition 1.30.7 (Feb 2, 2021)

  • PostgreSQL: Support for the parenthesized 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 VCL Edition 1.30.6 (Dec 21, 2020)

  • Support for Intuit QuickBooks SQL syntax is added.
  • The Query Structure Demo has been improved by processing IN, LIKE and BETWEEN nodes in the DumpExpression method.
  • 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.

New in Active Query Builder VCL 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.
  • The new property QueryBuilder.SwapSidePanels has been added to swap the Database Schema Tree and the Query Structure Tree.
  • SQL Text Editor: Editing speed optimizations have been made.
  • SQL Text Editor: Minor fixes and improvements for the suggestions list have been made.
  • SQL Text Editor: The new property SqlTextEditorOptions.SyncSuggestionLoading has been made for DACs having problems with running queries in threads.
  • 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.
  • Nexus DB: Support for the TOP clause has been added.
  • Nexus DB: QueryTransformer now supports Skip and Take methods.

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

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

New in Active Query Builder VCL 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 VCL Edition 1.30.0 (Dec 19, 2019)

  • Standard edition:
  • Now you can assign an SQL script with DECLARE and SET statements preceding
  • the SELECT query to the TacPlainTextSQLBuilder.SQL 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 component TacSQLScript splits the query by statements, allows to
  • look through them and edit separate statements in it.
  • The new TacQueryParametersTransformer component is added to:
  • 1. cut off conditions with undefined parameter values,
  • 2. convert parameter notation to the colon-prefixed notation.
  • Query Columns List: Handling of incomplete strings in expression cells
  • has been improved.
  • PostgreSQL: Support for WITH clause in subqueries has been added.
  • Professional version:
  • The new TacQueryParametersTransformer is also capable to deal with macros.
  • Using it you can replace a single parameter with a list of values, SQL
  • expression or sub-query.
  • SQL Text Editor: The suggestion list now works smoothly, filters items to
  • suggest smarter and loads the needed metadata in a thread.
  • SQL Text Editor: New properties have been added to tune colors and
  • suggestion behavior.
  • SQL Text Editor: Highlights the current SQL statement and provides methods
  • to get and set the current SQL statement.
  • SQL Text Editor: Other fixes and usability improvements have been made.

New in Active Query Builder VCL Edition 1.29.10 (Oct 17, 2019)

  • The bug with an empty schema for generic ANSI SQL syntax providers has been fixed.

New in Active Query Builder VCL Edition 1.29.9 (Jul 12, 2019)

  • SQL Text Editor: The unhandled exception on user typing in specific circumstances has been fixed.

New in Active Query Builder VCL Edition 1.29.8 (Jul 9, 2019)

  • TreeOptions: CTEsNodeText and SubQueriesNodeText props are writable now.
  • DevExpress: UnionNavBar auto sizing has been fixed.
  • Dot-prefixing objects with an empty schema for servers without database namespace support has been fixed.
  • QueryTransformer: The assignment of random column aliases for transformed queries in the Trial version has been fixed.

New in Active Query Builder VCL Edition 1.29.7 (Jul 9, 2019)

  • Query Structure Tree: sub-queries from WHERE and SQL expressions from other parts of the query are shown in the tree now.
  • New methods TacQueryBuilder.GetSqlAst/SetSqlAst are added to get/set the parsed AST query tree.
  • Query Transformer: SQL-text based transformations are made with the query AST tree now.
  • AST tree operations have been speeded up.
  • Log: the version number is now displayed in the "log opened" message.
  • Universal Syntax Provider: add syntax properties autodetection is logged now.
  • DevExpress: The width of buttons in the UnionNavBar is fixed.
  • SQL Text Editor: Typing of colon-prefixed parameters has been fixed.

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

  • SQL Text Editor: The new TextEditorOptions.ReadOnly property has been added.
  • SQL Text Editor: The suggestion window behavior has been improved.
  • SQL Text Editor: MySQL analytic functions are added to the suggestion list.
  • SQL Text Editor: The events for drag'n'drop have been added; support for OLE text drag'n'drop has been made.
  • SQL Text Editor: Mouse is captured on selection now.
  • 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 VCL 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.
  • New methods to get the list of linked servers and databases from them are added: GetServersList, GetDatabasesList(serverName)
  • MS SQL Server: Objects from linked servers without database or schema support are retrieved fine now.
  • SQL Text Editor: Slowness in displaying the suggestion list in the case of a large database schema has been eliminated.
  • The Create Query Demo has been rewritten. It includes more code samples of programmatic SQL query creation.
  • 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.
  • CrMyDACMetadataProvider: A workaround for the MyQuery.PSSetParams issue has been made.
  • AdvantageMetadataProvider: Client package name for newer Delphi versions has been updated.

New in Active Query Builder VCL Edition 1.29.3 (Jan 22, 2019)

  • NexusDB syntax provider has been added.
  • 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.
  • DBISAM: Client package name is updated for compatibility with the latest DBISAM v.4.47.
  • PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE clauses have been fixed.

New in Active Query Builder VCL 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 VCL Edition 1.28.11 (Nov 19, 2018)

  • NexusDB syntax provider has been added.
  • MySQL: Support for Common Table Expressions for MySql v8+ has been added.
  • The new properties have been added to the QueryBuilder object to hide the
  • controls for managing subqueries: SubQueryTabsVisible, UnionNavBarVisible.
  • 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 VCL Edition 1.28.10 (Nov 19, 2018)

  • SQL Text Editor: Autocompletion improvements and fixes have been made.
  • German localization has been updated
  • DevExpress: MetadataTreeNodeGetHintText event is fired now.
  • Minor bugs have been fixed.

New in Active Query Builder VCL Edition 1.28.9 (Nov 19, 2018)

  • DevExpress UI: Better application of skin colors has been made.
  • Minor improvements in the Load Metadata demo project have been made.
  • A memory leak for non-unicode Delphi versions has been eliminated.

New in Active Query Builder VCL Edition 1.28.8 (Aug 14, 2018)

  • Initial support of SAP Hana SQL syntax has been added.
  • 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 new limitation of the trial edition: generation of random aliases for
  • the query output columns.
  • The new method TacSubQuery.GetSqlForDataPreview() returns correct SQL query
  • to preview the sub-query result data.
  • The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed.
  • Links are created only if one of the fields is a part of the primary key.
  • FireDAC: 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 VCL 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 VCL Edition 1.28.7 (Mar 16, 2018)

  • Access violation on creating TacQueryBuilder component in RAD Studio 10.2.3
  • has been fixed.
  • SQLite: The list of reserved words has been filled.

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

  • Parsing of incorrect/incomplete "IN" expressions in condition cells of the Query Columns List has been improved.
  • DevExpress: Access violation in the IDE form designer if TdxSkinController exists on a form has been eliminated.

New in Active Query Builder VCL 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 VCL 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.
  • FireDAC: Fetching of databases and schemas is supported now.
  • FireDAC The new TacFireDACMetadataProvider.LoadStoredProcedures property
  • (default false) has been added. It instructs to load stored procedures
  • from the driver. Turn it on only for the database servers which support
  • using them in the FROM clause of the SELECT statement.

New in Active Query Builder VCL 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 VCL 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 VCL Edition 1.28.2 (Dec 7, 2017)

  • 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 VCL Edition 1.28.1 (Nov 17, 2017)

  • 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.
  • Sybase: Case-sensitive identifiers are used now for Sybase ASE.
  • Oracle: complex SQL queries parsing has been speeded up.
  • IBM DB2: Both LabelText and Remarks are used as LongDescription for fields for the QSYS2 schema.
  • The bug with keyboard navigation in the Query Columns List has been fixed.
  • Minor SQL formatting fixes have been made.
  • Minor HighDPI scaling issues have been fixed.
  • Query Columns List cell painting bug has been fixed.
  • The Links menu item captions have been restyled, the bug with a foreign key referenced to itself has been fixed.
  • MySQL: The bug with parsing of DateDiff and TimeDiff functions has been fixed.

New in Active Query Builder VCL Edition 1.27.11 (Sep 8, 2017)

  • Query Transformer: The bug with creation of filter expression for a column
  • with quoted aliases has been fixed.
  • The bug with removing a derived table via the context menu command has
  • been fixed.
  • PostgreSQL: Parsing of string literals with ''-quoted apostrophes has been
  • fixed.
  • MS SQL Server: Support of SELECT into local var (SELECT @localVar = 10)
  • has been added.
  • Several DevExpress controls UI bugs have been fixed.
  • Compilation of Metadata Provider for DOA has been fixed.
  • Criteria Builder: The new ReadOnly and Color properties have been added.
  • Criteria Builder: Minor bug fixes and improvements have been made.
  • The "Field not found" bug in Criteria Builder has been fixed.
  • Text Editor: Selection movement on indent/unindent commands has been
  • eliminated.
  • Text Editor: The bug in Replace command in selection has been fixed.
  • Localization files have been updated, missing strings have been added.

New in Active Query Builder VCL Edition 1.27.10 (Aug 29, 2017)

  • The new TacQueryBuilder.SelectListOptions.DropdownInExpressionColumn property has been added. Turn it off to hide the drop-down list in the Expression column of the Query Columns Grid.
  • Localization of TacCriteriaBuilder has been fixed.
  • Installer: Folder for the demo projects can be changed now.

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

  • SQL Text Editor: Localization of the Find & Replace form has been made.
  • Localization fixes in the Properties forms have been made.
  • Correct column prefix is emitted for procedures and table-valued functions.
  • Installer: Folder for the demo projects can be changed now.
  • Minor memory leaks have been eliminated.

New in Active Query Builder VCL 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.
  • FireDAC: Metadata filters are now applied on loading objects from driver.
  • Professional: Source code compilation with DevExpress controls has been fixed.

New in Active Query Builder VCL Edition 1.27.7 (Aug 3, 2017)

  • Demo projects are installed now to the All Users Profile directory: C:UsersPublicDocumentsActiveDBSoftDemos
  • Source code in Professional version has correct compiler defines now.
  • Installer: An option to extract packages for all supported Delphi versions has been made.
  • SQL Text Editor: A memory leak has been fixed.
  • SQL Text Editor: Font is scaled correctly now on high resolutions.
  • The SQLTextEditor.ParentFont property has been made public.

New in Active Query Builder VCL Edition 1.27.6 (Aug 3, 2017)

  • Expression Editor: Access violation on moving mouse over the query objects
  • tree has been eliminated.

New in Active Query Builder VCL Edition 1.27.5 (Jul 27, 2017)

  • Professional: SQL Text Editor: packages for RAD Studio XE have been added.
  • Professional: Expression Editor: The new properties Height and Width
  • determine the dialog size.
  • Professional: SQL Text Editor: Font scaling has been made.
  • Professional: Expression Editor: Access Violation on mouse move over
  • metadata tree has been fixed.
  • Various fixes and improvements in the Full-featured demo have been made.

New in Active Query Builder VCL Edition 1.27.4 (Jul 26, 2017)

  • Compilation errors for C++Builder have been fixed.
  • Minor fixes for the Full-featured demo project have been made.
  • Demo projects are moved to the %ALLUSERSPROFILE%DocumentsActiveDbSoftDemos" folder (usually "C:UsersPublicDocumentsActiveDBSoftDemos".

New in Active Query Builder VCL Edition 1.27.2 (Jun 26, 2017)

  • The Custom Expression Editor ellipsis button doesn't hide the combo box
  • button in the inline editor of Expression column in the Query Columns
  • Grid, but displayed next to it.
  • The bug with incorrect loading of conditions joined with the topmost OR
  • operator has been fixed.
  • Access violation on pressing the TAB key in an empty Query Columns Grid
  • control with an inactive editor has been fixed.
  • PostgreSQL, MySQL, SQLite, Netezza: Support for expressions in
  • LIMIT/OFFSET clauses has been added.
  • TacSubQuery.AddNewCte: Field list is now set up correctly for the newly
  • created CTE.

New in Active Query Builder VCL Edition 1.26.36 (Mar 23, 2017)

  • MetadataProvider.LoadFieldsForObjectFromDriver: The TrimQuotes flag is
  • taken into account now.
  • MetadataContainer.LoadMetadataByFilter: Access violation on calling without
  • a connection while loading objects using events has been eliminated.

New in Active Query Builder VCL Edition 1.26.34 (Mar 17, 2017)

  • Automatic links creation has been improved: links are created only from
  • Parent to Child table or vice vera, but not both at the same time.
  • The StatisticOutputColumn.ColumnNameInQuery is now quoted if need.
  • The StatisticOutputColumn.MetadataField calculation has been improved.
  • The new properties TrimQuotes and TrimSpaces have been added to the
  • BaseMetadataProvider class.
  • Firing of the ActiveSubQueryChanging/Changed event is enforced on the
  • query clearing.
  • DevExpress UI: Click on the checkbox in the datasource field list has been
  • fixed.
  • PostgreSQL: Support of materialized view, TOAST tables, and foreign tables
  • has been made.
  • Oracle: Support of the "AT TIME ZONE" clause has been added.
  • Firebird: Column name definition after alias in the FROM clause is
  • supported now.
  • IBM DB2: The ListAgg function is supported now.
  • IBM DB2: The QSYS2 tables are used now for fields loading if this scheme
  • exists. Several minor bugs have been fixed.
  • SQLite: Support for the IS operator ("expr IS expr") has been added.
  • SQLite: The bug with not loading fields for a table being added second to
  • the query has been fixed.
  • MS SQL Server: loading objects from non-default schemas for non-default
  • databases is fixed
  • MS SQL Server: The DATEADD parser unambiguity has been fixed.
  • MySQL: Parsing of DATE, TIME and DATETIME types as keywords has been
  • fixed.

New in Active Query Builder VCL Edition 1.26.32 (Jan 5, 2017)

  • The bug with the newly introduced PartialMetadataLoading property is fixed.
  • MySQL: Proper fix up of string aliases has been made to avoid control hang on some queries.

New in Active Query Builder VCL Edition 1.26.31 (Jan 5, 2017)

  • Loading metadata from XML has been fixed.

New in Active Query Builder VCL Edition 1.26.30 (Jan 5, 2017)

  • The new TacQueryBuilder.PartialMetadataLoading property has been added.
  • Setting it to True prescribes the component to load metadata only for objects that were used in the query on assigning it to the SQL property.
  • You shouldn't call the RefreshMetadata method in this mode.
  • Mouse wheel works now in pick up lists of the Query Columns Grid.
  • The MetadataContainer.LoadFromXML method is significantly speeded up.
  • Firebird: Support of aliases in the ORDER BY clause only for the version 2.0 and higher.
  • Demo app: The parameters form for ADO connection has been fixed.
  • MS SQL Server: List of valid identifiers list has been updated.
  • Single-line comments are recognized properly now.

New in Active Query Builder VCL Edition 1.26.29 (Jan 5, 2017)

  • Scrolling by mouse wheel now works in the drop-down pick list of the
  • Expression cell editor.
  • The FieldListDescriptionColumnOptions.ShowLongDescription property is
  • now set to True by default.
  • Minor column type painting improvements in datasource field lists have
  • been made.
  • Calculation of checked fields in datasource field lists has been fixed.
  • The Varchar(Max) and Varbinary(Max) types are displayed correctly now.
  • MS Jet: Excel sheet names with the dollar sign are supported now.
  • Oracle: Support for the special form of TRIM function has been added.
  • MS SQL Server: ROW and ROWS are added to the list of valid identifiers.
  • Other minor bugfixes and improvements have been made.

New in Active Query Builder VCL Edition 1.26.28 (Oct 13, 2016)

  • Query Transformer is now capable to rename output query columns.
  • The new property TacQueryTransformer.RenameDuplicatedColumns property
  • prescribes to explicitly specify all the columns in the query SELECT list
  • by expanding the asterisk items, then find and rename unnamend and
  • duplicated column names (default = false).
  • The new TacQueryTransformer.AlwaysExpandColumnsInQuery instructs to perform
  • asterisk expansion in the query SELECT list even if it's not needed for the
  • specified query transformations (default = false).
  • The TacOutputColumn.Name property is renamed to OriginalName.
  • The new TacOutputColumn.PreassignedName allows to specify the needed name
  • for a query output column.
  • The new TacOutputColumn.ResultName gets the result query columns name which
  • turned out as a result of automatic columns renaming routine and manual
  • appliance of the new name specified via the PreassignedName property.
  • QueryTransformer: The bug with sorting by a column , which alias is equal
  • to field name is fixed.
  • The "Build Expression" popup menu item is now shown only when a handler
  • is assigned to the OnCustomExpressionBuilder event.
  • MS SQL Server: CHAR(n) parser ambiguity is fixed.
  • MS SQL Server: CHAR and NCHAR are moved from the builtin functions to the
  • list of valid identifiers.
  • PostgreSQL: Support for custom aggregate functions is added.
  • PostgreSQL: Date/time parts are added to the list of valid identifiers.
  • ElevateDB packages are updated to comply with the latest version.

New in Active Query Builder VCL Edition 1.26.26 (Oct 12, 2016)

  • Query Columns Grid: Changes in inplace editors are committed on focus lost.
  • PostgreSQL: Parsing of set operators is fixed.
  • ElevateDB: Connectivity package compilation is fixed.

New in Active Query Builder VCL Edition 1.26.18 (Mar 21, 2016)

  • Loading of subqueries from condition cells for "IN (subquery)" expressions is fixed.

New in Active Query Builder VCL Edition 1.26.17 (Mar 15, 2016)

  • Better row height sizing in the Select List Control using custom fonts is made.
  • The error with quotation of sub-query text in the cells of Select List Control is fixed.

New in Active Query Builder VCL Edition 1.26.16 (Mar 3, 2016)

  • The new property TacQueryBuilder.DatasourceOptions.TableWidthMode is added
  • to determine width of new datasources on Design Pane. Possible values:
  • twmFixed - fixed, specifed by the DefaultTableWidth property,
  • twmAutosizeByContent - calculated to fit the while text content,
  • twmAutosizeByFieldName - calculated to fit the longest field name.
  • FireDAC, AnyDAC 2: CmdExecTimeout setting is fixed.
  • Query Column List control: The "Sort Type" column autosize is fixed.

New in Active Query Builder VCL Edition 1.26.15 (Feb 24, 2016)

  • MS SQL Server: Parsing performance is improved.
  • Query Columns List: The fix for "Aggregate" and "Grouping" columns
  • auto-fit is made.

New in Active Query Builder VCL Edition 1.26.14 (Feb 24, 2016)

  • The new property is added to the TacCustomExpressionEditorParams object
  • to determine the index of condition/or column: ConditionIndex.
  • Fitting of the Query Column List's column width on double clicking on
  • the column splitter is made.
  • Addition or modification of expressions via the OnCustomExpressionEditor
  • event handler now follows the same rules as changing them via the query
  • building UI by end-user. (eg. checking of the Visible field for new rows,
  • assigning aliases to resolve column name conflicts, etc.)

New in Active Query Builder VCL Edition 1.26.13 (Feb 15, 2016)

  • The new SQL syntax feature to use aliases in GROUP BY is added:
  • TacBaseSyntaxProvider.IsSupportGroupByAlias property.
  • Firebird: Domain name is shown now instead of type name in datasource field lists.
  • Database Schema Tree wasn't scrolled to the top after reload. Fixed now.
  • The SubQuery.Clear clears the WITH clause as well.

New in Active Query Builder VCL Edition 1.26.12 (Feb 15, 2016)

  • Design Pane: Aggregated fields are checked now in Datasource controls.
  • The TAB key behaviour in the last column of Select List is fixed.

New in Active Query Builder VCL Edition 1.26.10 (Jan 23, 2016)

  • Added:
  • Query Column List Control now always displays the "Delete item" button.
  • The new property TSQLBuilderConditionFormat.NewLineBefore is made.
  • MS SQL: Support for COLLATE clause for column expressions is made.
  • Removed:
  • Access Violation in the "Remove CTE" event handler is eliminated.

New in Active Query Builder VCL Edition 1.26.9.0 (Dec 29, 2015)

  • The installer is signed using SHA256 algorithm.
  • Access violation is fixed in the QueryTransformer.QueryBuilder setter if QueryBuilder doesn't have a SyntaxProvider assigned.
  • Metadata provider for AnyDAC v.1: Minor compilation fixes are made.

New in Active Query Builder VCL Edition 1.26.7.0 (Dec 29, 2015)

  • Installer requires elevation (UAC).
  • Access violation is fixed in the TacSelectItem.SetConditionString method.
  • MicroOLAP PostgreDAC compilation warning is fixed.
  • Assert on datasource deletion in rare cases for complex queries is fixed.

New in Active Query Builder VCL Edition 1.26.6.0 (Dec 29, 2015)

  • Minor fixes in the Metadata Container Editor and Loader forms are made.
  • DevExpress forms are fixed.

New in Active Query Builder VCL Edition 1.26.5.0 (Dec 10, 2015)

  • MS Access: Support for CONVERT builtin function is made.
  • PostgreSQL: Support for POSITION builtin function is made.
  • Help file is converted to CHM format.
  • Oracle: PRECISION, NULLS, TIME, READ, INTERVAL are treated as valid
  • identifiers now.
  • Null reference exception is fixed thanks to passing MetadataFilter and
  • Database to the metadata loading thread in the LoadMetadataAsync method.
  • Oracle: The "List index out of bounds" error in data type calculation is
  • fixed.
  • Access violation in the TacBaseMetadataProvider.ExecSqlInternal method
  • is eliminated.
  • Minor DevExpress forms fixes are made.

New in Active Query Builder VCL Edition 1.26.4.0 (Dec 7, 2015)

  • Polish translation is added.
  • Oracle: Calculation of SQL expression data types is made.
  • Better "IN" lists and date literal recognition in the select list is made.
  • MS SQL Server: Date parts are added to the list of valid identifiers.
  • The new SyntaxProvider.IsQueryWithIntoClause method is implemented for
  • MS Access, MS SQL Server, PosgreSQL, and MySQL.
  • ODBC "fn" call is fixed.
  • Logging of user actions is possible now.

New in Active Query Builder VCL Edition 1.26.2.0 (Sep 19, 2015)

  • The new method TacBaseSyntaxProvider.GetKeywords is made to get list of reserved keywords.
  • MS SQL Server: Support fot IIF function is added.

New in Active Query Builder VCL Edition 1.26.0.0 (Sep 10, 2015)

  • Support for RAD Studio 10 Seattle is made.
  • Support for Netezza SQL syntax is added.

New in Active Query Builder VCL Edition 1.25.5.0 (Sep 10, 2015)

  • Minor fixes in Interbase Express metadata provider are made

New in Active Query Builder VCL Edition 1.25.4.0 (Jul 29, 2015)

  • Automatic addition of condition columns in the Query Columns Grid is fixed.

New in Active Query Builder VCL Edition 1.25.3.0 (Jul 29, 2015)

  • Using RTL flags even for SQL columns in the Query Columns Grid is made.

New in Active Query Builder VCL Edition 1.25.2.0 (Jul 10, 2015)

  • Teradata: Data type names are displayed correctly now.
  • MySQL: Support of "SUBSTRING(a FROM b TO c) is added.
  • Advantage: Editing of TOP clause in the Query Properties dialog is fixed.
  • Minor improvements for RTL script languages are made.
  • Query Transformer: minor bug fixes are made.

New in Active Query Builder VCL Edition 1.25.1.0 (Jun 13, 2015)

  • Localization to Farsi language is added.
  • Query Transformer state serialization to XML string is made.
  • Use the TacQueryTransformer.StateXML property to save and load state.
  • Grouping checkbox is hidden now for query columns with constant SQL
  • expressions.
  • Query Column List control now obeys RTL flag for captions, but ignores
  • it for SQL expressions.
  • Algorithm trying to preserve conditions order in WHERE and HAVING clauses
  • is implemented.
  • AdvantageDB: Support for the CONTAINS full-text search function is made.
  • PostgreSQL: Support for materialized views is made.
  • Intofmix: Metadata objects loading is made more reliably now.
  • Setting the UnionSubQuery.SQL property to query containing multiple unions
  • results in raising EacQueryBuilderError exception now.
  • The "Invalid class typecast" error on setting TacSubQuery.SQL property
  • to empty string is fixed.

New in Active Query Builder VCL Edition 1.25.0 (Jun 13, 2015)

  • Support for RAD Studio XE8 is added.
  • Compatibility with VCL Styles is improved.
  • Support of RTL languages is improved.
  • Ability to select muptiple rows in the Query Columns Grid eases
  • re-ordering of query columns.
  • The Aggregate column of the Query Columns Grid is moved closer to the
  • Grouping column.
  • Now when query grouping is cancelled by unchecking the main Grouping
  • option, the ConditionType ("Criteria For" column) is set to ctWhere
  • ("For values") only for non-aggregated columns.
  • IacTask: Support for cancelation of the task in another thread is made.
  • IacAsyncSql: The OnCustomizeDataset event is added to change parameters of
  • dataset after it's creation.
  • IacAsyncSql: Ability to use the given DB connection is added.
  • The QueryBuilder.OnSelectListColumnWidthsChanged event is now fired only
  • for changes made by the user.
  • QueryTransformer: Wrapping of queries with several unnamed columns is
  • fixed.
  • ANSI SQL/2003: Using the TABLE wrapper for stored procedures in FROM is
  • possible now.
  • AdvantageDB: Support for IIF builtin function is made.
  • AdvantageDB: Parsing of the LEFT and RIGHT builtin functions is fixed.
  • MySQL: Support for CHAR builtin function is made.
  • DB2: Duplication of the TABLE wrapper for stored procedures is fixed.
  • Informix: The system "INFORMIX" schema now treated as non-system if no
  • other schemas are found.

New in Active Query Builder VCL Edition 1.24.12.0 (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.
  • The new QueryBuilder.OnSelectListColumnWidthsChanged is made. Helpers to get/set columns widths are added.
  • Query columns list height and columns width are preserved now on query reloading and manual SQL text changes.
  • The QueryBuilder.ColumnsPaneHeight setter is improved.
  • The QueryBuilder.Clear method is fixed.
  • TacBaseSyntax: Better date/time parsing helpers are made.

New in Active Query Builder VCL Edition 1.24.11.0 (Mar 25, 2015)

  • Focus is not moved on mouse hover over datasources on the Design pane if the component is not focused.
  • The TacSubQuery.SetSql method now accepts CTE for the main query.
  • The TacUnionSubQuery.SQL property now emits empty string for empty queries.
  • Support for database connection activity logging is made.
  • Incorrect loading of ORDER BY is fixed.

New in Active Query Builder VCL Edition 1.24.10.0 (Mar 25, 2015)

  • Support for NexusDB v.4 is made.
  • The OnActiveSubQueryChanging and OnActiveUnionSubQueryChanging events signatures are changed. Now you can deny sub-query changing.
  • Minor parsing speed improvements are made.

New in Active Query Builder VCL Edition 1.24.9.0 (Jan 21, 2015)

  • Component usage under the Win64 platform is fixed.
  • Scanner performance optimizations are made.

New in Active Query Builder VCL Edition 1.24.8.0 (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 VCL Edition 1.24.7.0 (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 VCL Edition 1.24.6.0 (Dec 5, 2014)

  • Support for AdvantageDB SQL syntax is made.
  • The new Subquery Results Preview demo is added to illustrate working with subqueries independently and using Query Transformer to allow previewing of sub-query result data.
  • The new AlwaysWrapInSubQuery property is added to TacQueryTransformer to instruct the component to wrap original query in sub-query even it is not necessary in order to perform the requested modifications.
  • AdvantageDB Metadata Provider: minor bugs are fixed.

New in Active Query Builder VCL Edition 1.24.5.0 (Dec 5, 2014)

  • General SQL parsing bug is fixed.

New in Active Query Builder VCL Edition 1.24.4.0 (Dec 5, 2014)

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

New in Active Query Builder VCL Edition 1.24.3.0 (Dec 5, 2014)

  • Fonts scaling support is made.
  • 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).
  • MS SQL Server: Pound symbol is removed from the list of valid identifier letters.
  • Error on canceling execution of non-SELECT statements is fixed.
  • Error on deleting datasource in subquery is fixed.

New in Active Query Builder VCL Edition 1.24.2.0 (Dec 5, 2014)

  • A workaround for incorrect positioning of the Query Columns Grid context menu for Delphi 2009 and earlier is made.

New in Active Query Builder VCL Edition 1.24.1.0 (Dec 5, 2014)

  • A workaround for DevExpress 2014.1.4 splitter bug is made.

New in Active Query Builder VCL Edition 1.24.4.0 (Oct 22, 2014)

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

New in Active Query Builder VCL Edition 1.24.3.0 (Oct 22, 2014)

  • Fonts scaling support is made.
  • 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).
  • MS SQL Server: Pound symbol is removed from the list of valid identifier letters.
  • Error on canceling execution of non-SELECT statements is fixed.
  • Error on deleting datasource in subquery is fixed.

New in Active Query Builder VCL Edition 1.24.2.0 (Sep 18, 2014)

  • A workaround for incorrect positioning of the Query Columns Grid context menu for Delphi 2009 and earlier is made.

New in Active Query Builder VCL Edition 1.24.1.0 (Sep 18, 2014)

  • A workaround for DevExpress 2014.1.4 splitter bug is made.

New in Active Query Builder VCL Edition 1.24.2.0 (Sep 18, 2014)

  • A workaround for incorrect positioning of the Query Columns Grid context menu for Delphi 2009 and earlier is made.

New in Active Query Builder VCL Edition 1.24.0.0 (Sep 13, 2014)

  • RAD Studio XE7 support is made.
  • 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 VCL Edition 1.23.11.0 (Sep 13, 2014)

  • BDE: The bug with connection cloning is fixed.
  • TacSubQuery.SQL and TacUnionSubQuery.SQL properties now accept empty strings.
  • "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.
  • MS SQL Server: A workaround is made for loading metadata through BDE.
  • Minor improvements in Localizer are made.

New in Active Query Builder VCL Edition 1.23.10.0 (Sep 13, 2014)

  • The new internal metadata loading interfaces with directly specified database connection are made.
  • QueryTransformer assignment is fixed.
  • TacDatasourceControl.Collapsed property is fixed.
  • Fields list calculation for recursive CTEs is fixed.

New in Active Query Builder VCL Edition 1.23.9.0 (Sep 13, 2014)

  • More fixes for Allround Automations DOA metadata provider are made.
  • Package descriptions are fixed.
  • The "Preload Metadata Container" design-time command is re-enabled.

New in Active Query Builder VCL Edition 1.23.8.0 (Jun 12, 2014)

  • AdvantageDB, NexusDB, AllroundAutomations DOA: AV in GetConnection method is fixed.
  • QueryTransformer does not wrap query if limits are empty.
  • QueryTransformer obeys the QueryBuilder.SleepMode flag now.

New in Active Query Builder VCL Edition 1.23.7.0 (Jun 12, 2014)

  • Allround Automations DOA connectivity package is fixed.
  • AV on asyncronous metadata loading when main component is hidden is fixed.
  • 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.
  • QueryTransformer object can be assigned now.

New in Active Query Builder VCL Edition 1.23.6.0 (Jun 12, 2014)

  • Full-featured demo project: New generic dataset interface is used.
  • DevArt SQL Server DAC and NexusDB connectivity fixes are made.
  • Query Transformer: SortedColumn.SortType property setter is added to allow changing of sort order.
  • Better MySQL queries cancelation for asyncronous SQL execution is made.
  • A workaround for ADO parameter types bug is made.
  • MS SQL Server: A workaround for loading metadata via ODBC driver is made

New in Active Query Builder VCL Edition 1.23.4.0 (Jun 12, 2014)

  • Support for NexusDB 3.12 is added.
  • Small improvements in asyncronous SQL execution are made.

New in Active Query Builder VCL Edition 1.23.3.0 (Jun 12, 2014)

  • Installation for Delphi XE6 is fixed.
  • MS Access: Backtick-quoted identifiers are accepted now. They will be converted to square brackets during the query generation.

New in Active Query Builder VCL Edition 1.23.2.0 (Jun 12, 2014)

  • Prevent races on RefreshMetadataAsync and RefreshMetadata calls.
  • Installer: RAD Studio XE6 detection is fixed
  • Syntax Providers: The new set of functions to pack/unpack date, time and timestamp literals.
  • AnyDAC2: Default command timeout is set to 0 (unlimited) instead of 30
  • seconds.
  • Minor fixes in the Query Transformer are made.

New in Active Query Builder VCL Edition 1.23.1.0 (Jun 12, 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.

New in Active Query Builder VCL Edition 1.23.0.0 (Jun 12, 2014)

  • RAD Studio XE6 support is added.
  • Connection cloning and asyncronous SQL execution is possible now.
  • 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 VCL Edition 1.22.8.0 (Jun 12, 2014)

  • Add Linked Objects menu: Separate menu items are shown now if there are many links for a linked object.
  • FireDAC: Zero command timeout can be set now to turn off timing out.
  • The AltNameCaseSensitive flag is added to all objects with alternate names.
  • MS SQL Server: Parsing of method calls is fixed.

New in Active Query Builder VCL Edition 1.22.7.0 (Jun 12, 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 VCL Edition 1.22.4.0 (Nov 14, 2013)

  • Access Violation in UnionSubQuery.AddObject in non-visual mode is eliminated.
  • Sleep Mode and Focusing fixes are made.
  • 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 VCL Edition 1.22.3.0 (Nov 14, 2013)

  • Installer: Support of Delphi 5 is restored.
  • Query Transformer now can hide output columns and set the DISTINCT clause.
  • 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.
  • Query Transformer: Incorrect SQL query generation when source query has the ORDER BY statement is fixed.
  • DevExpress: The bug with incorrect datasource position changing when resizing a datasource with a large list of fields is fixed.

New in Active Query Builder VCL Edition 1.22.2.0 (Nov 14, 2013)

  • Minor improvements in the Add Linked Objects menu are made.
  • TacQueryTransformer API has been changed to reflect changes in the .NET version.
  • The bug with not storing the server version in those syntax providers that
  • aren't capable to detect version automatically is fixed.
  • Default prefixes in object names are skipped now in the Add Linked Objects
  • menu.

New in Active Query Builder VCL Edition 1.22.1.0 (Nov 14, 2013)

  • FireDAC packages are added.
  • The new DesignPaneOptions property group is made. It contains properties to
  • define spacing between datasource objects on the Design Pane.
  • MS SQL Server: CLR method calls support is made.
  • The linked objects button is placed on the panel now.
  • French translation is updated.
  • Delphi 5 support is fixed.
  • Other bug fixes are made.

New in Active Query Builder VCL Edition 1.22.0.0 (Nov 14, 2013)

  • RAD Studio XE5 is supported now.
  • 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.
  • Use the TacQueryBuilder.DatasourceOptions.ShowLinkedObjectsButton property
  • to disable this functionality.
  • 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 VCL Edition 1.21.4.0 (Aug 30, 2013)

  • Recently introduced bug that led to the emptiness of field lists is fixed.
  • Minor bug fixes and improvements for DevExpress UI are made.

New in Active Query Builder VCL Edition 1.21.3.0 (Aug 30, 2013)

  • DevExpress PageControl skin painter package is added to the list of referenced packages of acQueryBuilder package.

New in Active Query Builder VCL Edition 1.21.1.0 (Aug 30, 2013)

  • The new properties are added to fine tune the component's layout: TacQueryBuilder.OptionsView.TreeMargins property allows to remove margins around the TreeViews, TacQueryBuilder.OptionsView.SplitterResizeUpdate turns off immediate resizing when splitter moves.
  • The new TacQueryBuilder.OnLayoutChanged event is made to control changes in layout of the query. It is fired when datasource is moved on the Design Pane.
  • PostgreSQL: LEFT and RIGHT builtin functions are supported now.
  • The new TacBaseSyntaxProvider.QueryToLoadFieldsTemplate property is made.
  • DevExpress: IncSearch in treeviews is turned on, horizontal splitter is added to the Query Columns Grid.

New in Active Query Builder VCL Edition 1.21.0.0 (Aug 30, 2013)

  • The new TacQueryTransformer component is added. It is intended to easily modify SQL query sorting, filtration and aggregation programmatically.
  • RAD Studio XE4 support is added.
  • The new TacBaseSyntaxProvider.AppendLimitsForFieldsQuery property is added to enable/disable the "00" condition in the field list retrieval queries.
  • The new properties are added to the TacExpressionBuilderParams 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 VCL Edition 1.20.4.0 (Aug 30, 2013)

  • Oracle: REGEXP_LIKE function is supported now.
  • Usage of aliases in ORDER BY is corrected.
  • Minor fixes and improvements for DevExpress controls UI are made.
  • MS Access: Support of aliases in ORDER BY clause is turned off.

New in Active Query Builder VCL Edition 1.20.3.0 (Aug 30, 2013)

  • TacQueryTransformations: Addition of OR conditions is possible now.
  • "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.
  • DevExpress drawing artifacts are fixed.
  • 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.
  • Component version is shown in the TacQueryBuilder context menu in design time.
  • FieldsList.ItemHeight is updated now when TableFont is changed.
  • Alias quotation is removed in the Alias column.

New in Active Query Builder VCL Edition 1.20.2.0 (Aug 30, 2013)

  • The new CommandTimeout property is added to DevArt MyDAC metadata provider.
  • 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 VCL Edition 1.20.1.0 (Aug 30, 2013)

  • Compatibility with the latest DevExpress VCL controls is made.
  • The new properties are added to items of the TacStatisticsOutputColumns collection: ObjectNameInQuery and ColumnNameInQuery.
  • 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.
  • FIBPlus package references are updated.
  • FireDAC mentioned in AnyDAC package descriptions and in installer
  • 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 VCL 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.
  • NexusDB3 connectivity package is updated to refer to the latest version.

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

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

New in Active Query Builder VCL 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 VCL 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 VCL 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 VCL 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 VCL 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 VCL 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 VCL 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 VCL 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 VCL 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 VCL Edition 1.19.2.0 (Sep 25, 2012)

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

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

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

New in Active Query Builder VCL 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 VCL 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 VCL 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 VCL Edition 1.18.22.0 (Jul 5, 2012)

  • Minor fix in Oracle server version detection is made.

New in Active Query Builder VCL 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 VCL 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.
  • Imported MS XML interfaces are renamed to avoid name conflicts in C++Builder.
  • 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 VCL 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 VCL Edition 1.13.0.0 (Aug 4, 2009)

  • Firebird 2.5 support is added.
  • Embarcadero RAD Studio 2010 is supported now.

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

  • Nexus DB v3.00 connectivity package is added.
  • Two new events are added to control fields adding from the query building area to expressions grid: TacQueryBuilder.OnDatasourceFieldAdding and TacQueryBuilder.OnDatasourceFieldAdded.
  • The new TacOutputColumn.MetadataObject property is added to get access to the database object of output field.
  • The new TacBaseSyntaxProvider.DenyIntoClause property is added to restrict building of SQL queries containing "SELECT INTO" clause.
  • Two new properties are added to define cardinality of relations between database objects: TacMetadataRelation.KeyCardinality and ChildCardinality

New in Active Query Builder VCL 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 VCL Edition 1.10.14.0 (Jan 17, 2009)

  • Support of Embarcadero Delphi 2009 IDE is implemented.
  • Ability to compile the component with DevExpress controls is added. ustomization of datasource's field lists at the query building area is made.
  • Other minor improvements and bug fixes are made.

New in Active Query Builder VCL Edition 1.9 (Apr 4, 2008)

  • Delphi/C Builder 2007 support is implemented.
  • Improved usability of building GROUP BY/HAVING clauses with the new criteria list grouping style.
  • Ability to define alternate names for database objects and their fields is implemented.
  • Some speed optimizations were made.
  • Support of IBM DB2 and ANSI SQL/2003 standard dialects is implemented.
  • Ability to detect SQL syntax of the currently connected database server automatically is added.
  • DBLink support is implemented for Oracle databases.
  • Russian, Japanese, Turkish, Portuguese(Brazil), German and Swedish languages were added.
  • Ability to use external custom expression builder is made.
  • The new events are added to control addition and removal of the query datasources.
  • Ability to save an restore all or selected groups of properties is implemented.
  • Softvector ODBC DAC, VistaDB and ElevateDB connectivity packages were implemented.

New in Active Query Builder VCL Edition 1.7.9 (Mar 29, 2007)

  • Chinese, Czech and Italian localizations are added.
  • Support of Synonyms and Analytic Functions in Oracle, Join Object Hints, Ranking and Aggregate Window Functions in MS SQL Server, more precise erroneous token reporting, other SQL parsing improvements.
  • Many other bugfixes and improvements.

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

  • Retrieval of extended information about user parameters in the query: data type, related table and field names.
  • New property to get access to output columns of the query.
  • Better handling of the asterisk item in SELECT list.
  • Multiple fixes and improvements for MS Access SQL dialect.

New in Active Query Builder VCL 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.