Downloads

Active Query Builder VCL Edition History

October 24, 2013

Active Query Builder VCL Edition v.1.22.3

- Installer: Support of Delphi 5 is restored.
+ Query Transformer now can hide output columns and set the DISTINCT clause.
+ Alias is printed before expression in the Query Structure Tree.
+ Oracle: National string literals are supported now.
= Oracle: DENSE_RANK in partition clause is supported.
= MS SQL Server: System views are used now to fetch foreign keys 
  (for SQL Server 2005 and newer).
= PostgreSQL: Support of multi-parameter aggregates is made.
- PostgreSQL: Parsing of the ANY clause in codition cells is fixed.
- Query Transformer: Incorrect SQL query generation when source query has 
  the ORDER BY statement is fixed.
- DevExpress: The bug with incorrect datasource position changing when 
  resizing a datasource with a large list of fields is fixed.

October 10, 2013

Active Query Builder VCL Edition v.1.22.2

= Minor improvements in the Add Linked Objects menu are made.
= TacQueryTransformer API has been changed to reflect changes in the .NET version.
= The bug with not storing the server version in those syntax providers that 
  aren't capable to detect version automatically is fixed.
= Default prefixes in object names are skipped now in the Add Linked Objects 
  menu.

October 03, 2013

Active Query Builder VCL Edition v.1.22.1

+ FireDAC packages are added.
+ The new DesignPaneOptions property group is made. It contains properties to
  define spacing between datasource objects on the Design Pane.  
+ MS SQL Server: CLR method calls support is made.
= The linked objects button is placed on the panel now.
= French translation is updated.
= Delphi 5 support is fixed.
- Other bug fixes are made.

October 01, 2013

Active Query Builder VCL Edition v.1.22

+ RAD Studio XE5 is supported now.
+ The new button is now shown at the right of the focused datasource on Design
  pane to allow easy adding of linked objects to the query. 
  Use the TacQueryBuilder.DatasourceOptions.ShowLinkedObjectsButton property 
  to disable this functionality.
+ The new datasource context menu item is added for the same purpose.
- MS Access: Parsing of the ASC builtin function is fixed.

September 13, 2013

Active Query Builder VCL Edition v.1.21.8

= Layout: Horizontal interval between datasources is decreased to 40 px.

September 12, 2013

Active Query Builder VCL Edition v.1.21.7

+ Query layout is now preserved after parsing of the modified query.
+ Algorithm of automatic objects placement on the diagram pane is improved.
= The OptionsView.SplitterResizeUpdate property now affects horizontal splitter.
  (between the Query Columns grid and the Design area)
- Small fixes for MSStyleGrouping mode are made.

August 29, 2013

Active Query Builder VCL Edition v.1.21.6

= Alternate Names now obey server identifier case sensitivity rules.
- The bug with incorrect bracketing of inner OR conditions is fixed.
= MS Access: Builtin functions siffixed with the dollar sign are supported now.
- Oracle: Usage of the "TIMESTAMP" keyword as column name is possible now.
= MS SQL Server: Table hints are updated according to the SQL Server 2012 
  specification.

June 27, 2013

Active Query Builder VCL Edition v.1.21.4

- Recently introduced bug that led to the emptiness of field lists is fixed.
- Minor bug fixes and improvements for DevExpress UI are made.

June 20, 2013

Active Query Builder VCL Edition v.1.21.3

- DevExpress PageControl skin painter package is added to the list of referenced
  packages of acQueryBuilder package.

June 18, 2013

Active Query Builder VCL Edition v.1.21.1

+ The new properties are added to fine tune the component's layout:
  TacQueryBuilder.OptionsView.TreeMargins property allows to remove margins
  around the TreeViews, TacQueryBuilder.OptionsView.SplitterResizeUpdate turns
  off immediate resizing when splitter moves.
+ The new TacQueryBuilder.OnLayoutChanged event is made to control changes in
  layout of the query. It is fired when datasource is moved on the Design Pane.
= PostgreSQL: LEFT and RIGHT builtin functions are supported now.
+ The new TacBaseSyntaxProvider.QueryToLoadFieldsTemplate property is made.
+ DevExpress: IncSearch in treeviews is turned on, horizontal splitter is added
  to the Query Columns Grid.

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