Downloads

Active Query Builder History History

June 29, 2018

Active Query Builder History v.3.4.19.1099

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

June 28, 2018

Active Query Builder History v.3.4.19.1098

- The bug in the QueryTransformer with the WHERE clause corruption when 
  Skip/Take is set which arose on the SQL Server 2005 and 2008 has been fixed.

June 28, 2018

Active Query Builder History v.3.4.19.1098

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

June 28, 2018

Active Query Builder History v.3.4.19.1098

- The bug with the Design Pane control scrolling while dragging a field over
  it has been fixed.
- The bug in the QueryTransformer with the WHERE clause corruption when 
  Skip/Take is set which arose on the SQL Server 2005 and 2008 has been fixed.

June 22, 2018

Active Query Builder History v.3.2.3

+ The new VirtualDirectory option for the configuration file has been added.
  Setting it will override the autodetected value.
+ The message is displayed now on turning to the "Sleep mode" when the user
  enters a query that is not a SELECT statement.
+ The new demo project has been added to illustrate applying custom HTML
  layout to the web page and also presents the new version of HTML layout
  for mobile devices.
- Crieria Builder now correctly handles conditions for strings with spaces.
- The HideAsteriskItem property is applied correctly being set on the page
  for the Canvas control.
- The bug with the columns width out of sync on changing the Query Columns
  Grid width has been fixed.
- Handling of several Query Column List items with the same Expression has
  been fixed.
= The AQB.Web.Core.addGridRow method now applies all properties of the
  passed GridRowDto object.
= The GridComponent.setColumnWidth now accepts values in pixels and 
  percents.

June 22, 2018

Active Query Builder History v.2.14.2

= Numeric constants in ORDER BY are converted to corresponding expressions
  now.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
+ Oracle: Loading of stored procedure parameters from the server system
  catalog is supported now.
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
- Teradata: The bug with autodetection of new versions has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins now results in the 
  parsing error.
- MS SQL Server: Parsing of qualified names with skipped components has been
  fixed.
- MS SQL Server: Loading of fields for linked servers without database or 
  schema has been fixed.
= PostgreSQL parser has been optimized.
= SQLite: Keywords list has been filled.
- MySQL: Support of STDDEV function has been fixed.
+ Sybase: Support for window functions has been added.
- DB2: NULL is parsed now as a constant, not as an identifier.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and 
  OPTIMIZE FOR in an arbitrary order has been fixed.

June 21, 2018

Active Query Builder History v.3.4.18.1097

+ SAP HANA: Detection of the default schema has been made.
+ SQL Server Compact Edition: The list of functions and keywords has been
 filled.

June 21, 2018

Active Query Builder History v.3.4.18.1097

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

June 21, 2018

Active Query Builder History v.3.4.18.1097

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

June 09, 2018

Active Query Builder History v.3.4.17.1096

= No changes.

scroll to top
© Copyright 2005-2022 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:

News

Tweets

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks