Downloads

Active Query Builder VCL Edition History

October 21, 2014

Active Query Builder VCL Edition v.1.24.3

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

September 17, 2014

Active Query Builder VCL Edition v.1.24.2

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

September 12, 2014

Active Query Builder VCL Edition v.1.24.1

- A workaround for DevExpress 2014.1.4 splitter bug is made.

September 11, 2014

Active Query Builder VCL Edition v.1.24.0

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

August 05, 2014

Active Query Builder VCL Edition v.1.23.11

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

June 27, 2014

Active Query Builder VCL Edition v.1.23.10

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

June 12, 2014

Active Query Builder VCL Edition v.1.23.9

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

June 10, 2014

Active Query Builder VCL Edition v.1.23.8

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

June 09, 2014

Active Query Builder VCL Edition v.1.23.7

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

May 27, 2014

Active Query Builder VCL Edition v.1.23.6

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

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