Active Query Builder VCL Edition History

July 27, 2017

Active Query Builder VCL Edition v.1.27.5

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

July 22, 2017

Active Query Builder VCL Edition v.1.27.4

- 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%\Documents\ActiveDbSoft\Demos"
  folder (usually "C:\Users\Public\Documents\ActiveDBSoft\Demos".

July 20, 2017

Active Query Builder VCL Edition v.1.27.3

+ The new Professional version is available now. It includes the Advanced
  SQL Text Editor, SQL Expression Editor, and the SQL Filter Builder.
  The Full-featured demo project now exists in two variants: one for the
  Standard, other for the Professional version. The Trial version includes
  both variants. 
+ The new demo projects have been made: Create Query demo and Edit Metadata
  Container demo.
- The bug with applying result column names for queries with asterisk items
  when fields aren't loaded yet has been fixed.
- Filtration by aggregated columns has been fixed.

June 24, 2017

Active Query Builder VCL Edition v.1.27.2

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

June 10, 2017

Active Query Builder VCL Edition v.

+ Sybase ASA: Compatibility with older server versions has been improved.
+ NativeDB Metadata Provider is capable of loading objects and foreign keys

June 09, 2017

Active Query Builder VCL Edition v.1.27.1

+ Support of DevExpress 17.1 has been added. 
+ Conditions for the same left part joined using the OR operator are merged
  into a single cell now. 
- IBM DB2: The bug with appending LIMIT OFFSET by the Query Transformer  
  has been fixed. 
- FireDAC: The DataSet.CursorKind property is set to ckForwardOnly for
  uni-directional datasets now. 
- Oracle: A workaround for Microsoft ODBC driver bug has been made. Fields
  are loaded now using the non-parametrized query if the parametrized query
- The bug with loading of CTE referred in a reverse order has been fixed. 
- MS SQL Server: Fake ORDER BY is added correctly now if there is no
  ordering in the transformed query. 
- Oracle: Loading of fields for synonyms has been fixed.

April 29, 2017

Active Query Builder VCL Edition v.1.27.0

+ Support for RAD Studio 10.2 Tokyo has been made.
+ MySQL: Support of MATCH full-text search operator has been added. 
= DB2: The new ObeySchemaListFromDriver boolean property (true by default)
  has been added. It prescribes to get the list of available databases
  from the driver (OLE DB or ODBC). 
- Access violation on removing active CTE has been eliminated. 
- DB2: The bug with selecting table owner instead of table schema for 
  schema name has been fixed.

March 23, 2017

Active Query Builder VCL Edition v.1.26.36

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

March 17, 2017

Active Query Builder VCL Edition v.1.26.35

+ SQLite: Right outer joins are converted to left now.
= SQLite: Non-qualified double-quoted identifiers are treated as strings now.
= The OnSQLUpdated event doesn't fire now during the form load.
- MS SQL Server: Built-in @@-named variables are recognized now.
- Oracle: Date/time built-in constants are recognized properly now.

March 13, 2017

Active Query Builder VCL Edition v.1.26.34

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

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:



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