Downloads

Active Query Builder History History

April 22, 2022

Active Query Builder History v.3.8.20.2222

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

April 22, 2022

Active Query Builder History v.3.8.20.2222

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

April 22, 2022

Active Query Builder History v.3.8.20.2222

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

April 22, 2022

Active Query Builder History v.3.8.20.454

= Reference to the ActiveQueryBuilder.Core assembly are updated.

April 21, 2022

Active Query Builder History v.3.8.19.2221

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

April 21, 2022

Active Query Builder History v.3.8.19.2221

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

April 21, 2022

Active Query Builder History v.3.8.19.2221

- The bug with not printing aliased object names is fixed.
= MS SQL Server: Support for "FOR JSON" clause is added.
= MS SQL Server: Support JOIN without a type prefix is made.
- PostgreSQL: The bug with loading referencing objects list is fixed.
= Oracle: Support for default value clause for conversion functions is added.
- SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.

April 20, 2022

Active Query Builder History v.1.31.10

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

April 20, 2022

Active Query Builder History v.1.31.10

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

April 12, 2022

Active Query Builder History v.1.31.9

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