Downloads  »  Active Query Builder VCL Edition History

January 11, 2010

Active Query Builder VCL Edition v.1.14.14.0

Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.14.14.0.

+ The new property is made to accept tabs in the columns pane.
  TacQueryBuilder.SelectListOptions.AcceptTabs: boolean; default true;
+ The new properties are added to the TacQueryBase class to set up the Union
  operator programmatically:
  - UnionOperator: gets/sets the unifying operator ('Union', 'Except',
    'Intersect' etc.);
  - UnionAllFlag: gets/sets the 'All' keyword for the operator;
  - UnionOperatorFull: gets/sets the full operator string (e.g. 'Union All').
+ Aliases for virtual calculated fields are added automatically now if they
  aren't defined by the user.
+ Firebird: Predefined context variables are supported now: CURRENT_DATE,
  CURRENT_TIME and CURRENT_TIMESTAMP.
+ Firebird: "IS DISTINCT FROM" operator is supported now.
+ MS SQL Server, Sybase: Support of the old-style TransactSQL outer join
  operators ("*=" and "*=") is made. 
- The component doesn't trim right spaces when creating field's aliases from
  alternate names now.
- MySQL: Better support of CONVERT function is made.
- PostgreSQL: Metadata filtration is fixed.
- Popup menu for the grid inplace editor is restored now.
- The LayoutSQL property does not expand virtual fields and objects now.
- Create derived table access violation is fixed now.
- Sybase ASE: Relations metadata loading is fixed now.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder VCL Edition at the download page.

» Full Active Query Builder VCL Edition history