Downloads

Active Query Builder VCL Edition History

March 02, 2011

Active Query Builder VCL Edition v.1.16.8

- The bug with entering criteria prefixed with comparison operators is fixed.
  (introduced in 1.16.6)
= Prevented EOL and EOF characters to be included in .hpp files.
= DB2: Additional aggregate functions are added: VAR_POP, VAR_SAMP
= Fixed bug with incorrect removal of selected query fields not related to the
  sub-query on removing same named fields from the sub-query.

February 24, 2011

Active Query Builder VCL Edition v.1.16.6

- The position parameter in the OnCustomExpressionBuilder event now measured
  from the top-left corner of the component (was of the columns grid control).
- Add Object Form: The ListView display mode is now applied correctly.
+ Add Object Form: Descriptions for metadata objects are displayed now in the
  Report ListView mode.
= MySQL: The || and && operators are treated now correctly according to the
  server configuration (as synonyms for logical OR and AND in default mode).
+ IBM DB2: Statistics aggregate functions are added.
+ IBM DB2: Extended syntax for TRIM, POSITION and EXTRACT functions, string
  types with CCSIDs are supported now.
= The "{expression}" entered to the Condition cell is converted to 
  "= {expression}" now.
- The ColumnPaneVisible property is fixed in Design Time.
+ MySQL: &,|,^,<<,>> operators are supported now.

February 09, 2011

Active Query Builder VCL Edition v.1.16.4

- DB2: The INNER, LEFT and RIGHT join keyword parser ambiguities are removed.
- ObjectMetadataLoading and ObjectMetadataLoaded events were not fired 
  in offline mode. Fixed now.
- Delphi6 support is fixed.
- DelphiXE installer is fixed.

January 28, 2011

Active Query Builder VCL Edition v.1.16.2

+ The new sample project is added to demonstrate how to replace all the WHERE
  clause or to append new condition string to the query.
+ The new properties are added to TacQueryBuilder.FieldsListOptions group:
  the HideAsteriskItem allows to remove the asterisk item from the field lists;
  the SelectAllFieldsByDefault instructs the component to check all fields 
  of a datasource on adding it to the query building area.
- MS Jet: Original fields order is preseved now for Jet 3.5 and 4.0.

January 26, 2011

Active Query Builder VCL Edition v.1.16.1

= Packages for Delphi 6 Enterprise IDE are included.
- MySQL: "Datetime" is now valid identifier.
+ Conditional define is made to support ExpressPageControl v3 (currently BETA)
  in acQBControls.pas,  TacPageControlBase.GetBorderWidth function.
= MySQL: GROUP_CONCAT is added to the list of aggregate functions now.
+ DB2: tuples are supported now.
= Access: Original database object fields order is restored now.

January 21, 2011

Active Query Builder VCL Edition v.1.16

+ Now it's possible to rename and remove CTE sub-queries from the query using
  the sub-query tab context menu.
+ Parsing of derived tables without aliases is possible now.
+ Oracle: Extract function for XML queries is supported now.
+ MySQL: REGEXP and RLIKE functions are supported now.
- The expressions with fields from sub-query are deleted now if these fields are 
  removed from respective sub-query (applied to all types of sub-queries).
= Better DevExpress Skins support is made for Datasource windows.
- Minor changes in the properties dialogs are made. 
- Wrong cast while processing the "not(not expression)" is fixed.
+ Fixup (determination of the field's ownership to a database object) by
  object's base name is made. (e.g. "select orders.id from db.schema.orders")
- Height calculation of the Link Properties form is fixed.
- MySQL: The differences between mysql.atg and mysql_ansi.atg are eliminated.
= The FROM keyword is always generated now for Oracle and DB2 dialects as it is
  mandatory there.

December 01, 2010

Active Query Builder VCL Edition v.1.15.24

+ Renaming of CTE is possible now.
+ Caption of the CTE subquery tab is taken from the CTE name now.
+ Addition of recursive CTE is allowed only for specific servers now.
+ Query-unique names are generated now for CTE and derived tables.
+ Server version autodetection for MS SQL, MySQL, Oracle, Sybase ASA/ASE,
  Informix is made.
+ Firebird: DateAdd, DateDiff, Overlay, Position builtin functions are added.
+ Oracle: RANGE added to the list of valid identifiers.
+ Access: The dollar sign ($) is turned to invalid letter for identifiers,
  built-in functions are added.
+ Oracle: Loading of materialized views is made.
- Field sorting is reverted to original order now when flsNone value is 
  assigned to the FieldsListOptions.SortType property.
- Query properties dialog forms look better now with DevExpress controls.
+ The new flag functions are added to the TacSubQuery class to determine if a 
  sub-query is derived table or CTE: IsSubQueryDerivedTable, IsSubQueryCTE.
+ Syntax Providers: The new server flag is added to determine if database 
  server supports recirsive CTE or not: IsSupportRecursiveCTE.
= Metadata Loading Wizard: Loading metadata is split to 3 separate stages:
  Load Objects, Load Relations and Load Custom Aggregates. This allows to 
  bypass the unnecessary steps in case of failure.
- Exception on using virtual fields in virtual objects is fixed.

November 10, 2010

Active Query Builder VCL Edition v.1.15.22

+ TacDatasourceGroup: The new methods GetLinks and GetLinksRecursive are added.
+ Oracle: CURSOR expressions are supported now.
= Empty union groups are removed automatically now after user's changes at the
  UnionNavBar.
- Oracle: Filtered metadata relations loading is fixed.
- Oracle: Aggregates list is corrected.
- Oracle: DB Links syntax is fixed.
- Conditions are converted correctly from HAVING to WHERE clause now on 
  clearing aggregate for a column.
- EvevateDB v2 Unicode support is fixed.
- Installer: MicroOLAP DACs package detection mistype is corrected.
- Installer: Link to Alternate Names Demo in the start menu is added.

October 07, 2010

Active Query Builder VCL Edition v.1.15.21

+ Delphi XE is supported now.
+ Bulgarian translation is added.
+ Oracle: Metadata filtration is now applied to relations fetch queries.
+ MS SQL: INDEX join hint is fixed.
+ Re-sorting fields in datasource field lists is made on changing sort mode.
- Firebird: UPPER built-in function support is fixed.
- MS SQL: Parameter names can include special symbols now (@, $, _ and #).
- MySQL: CONVERT function is fixed.

July 06, 2010

Active Query Builder VCL Edition v.1.15.12

+ German translation is updated.
+ French translation is updated.
- MS SQL Server: Special chars in parameter names (_,@,...) are accepted now.
- Interbase: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP are supported now.
+ Derived table alias is shown in the query structure tree instead of entire 
  SQL text.