Active Query Builder VCL Edition History

March 15, 2018

Active Query Builder VCL Edition v.1.28.7

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

February 28, 2018

Active Query Builder VCL Edition v.1.28.6

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

February 22, 2018

Active Query Builder VCL Edition v.1.28.5

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

January 27, 2018

Active Query Builder VCL Edition v.1.28.4

= Index numbers in ORDER BY are converted to corresponding expressions now.
= PostgreSQL parser has been optimized.
  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.

December 19, 2017

Active Query Builder VCL Edition v.1.28.3

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

December 07, 2017

Active Query Builder VCL Edition v.1.28.2

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

November 17, 2017

Active Query Builder VCL Edition v.1.28.1

+ 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

October 05, 2017

Active Query Builder VCL Edition v.1.28.0

+ Constants for new server versions have been added to appropriate syntax
+ Descriptions for database objects and fields are shown in hints in the
  Metadata Tree.
+ On adding a stored procedure (table-valued function), a prompt for its
  parameters does not appear anymore. Instead, you can open the datasource
  properties dialog (by selecting the Properties context menu item or by
  double-clicking on a datasource) and edit procedure parameters there.
  Those who want to display a dialog on adding a stored procedure can 
  handle the OnGetProcedureParameters to prompt the user for parameters.
+ The new LinkOptions.DefaultLinkType property has been added. It lets 
  prescribe to create left, right or full outer join instead of inner join
  on linking tables by drag'n'drop.
+ The new TSQLBuilder.SubqueryTextFromNewLine propery has been made to 
  break line between the sub-query text and the parentheses enclosing it.
+ The new group of properties has been made to customize formatting for 
  IF and CASE clauses: TSQLBuilderSelectFormat.ConditionalOperatorsFormat.
+ Minor SQL formatting improvements and bug fixes have been made.

+ SQL Text Editor (Professional): The new TextEditorOptions.UseTabCharacter
  property has been added.
- SQL Text Editor (Professional): Some bugs are fixed, minor improvements
  have been made.

+ The new OnMetadataTreeNodeGetCaptionText and OnMetadataTreeNodeGetHintText
  events have been added to customize the text of captions and hints for
  nodes of the Metadata Tree.

= 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

= PostgreSQL: The ComparisonOperators syntax provider property now stores
  only user-defined operators.
+ PostgreSQL: Support for "$n"-style positional params has been added.

+ The new SelectListOptions.GridLinesColor property has been added. 
  Being set to clNone it doesn't affect the painting.
- DevExpress: Some fixes for dark skins have been made.
- Several fixes for high resolutions have been made.

September 06, 2017

Active Query Builder VCL Edition v.1.27.12

+ DB2: Database objects description fetching for iSeries/AS400 has been
= NexusDB 4: Package references are updated to the latest version 4.12.
- MS SQL Server: Query Properties forms compilation for DevExpress controls
  has been fixed.

September 05, 2017

Active Query Builder VCL Edition v.1.27.11

- 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
+ 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
- Text Editor: The bug in Replace command in selection has been fixed.
= Localization files have been updated, missing strings have been added.

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