Downloads

Active Query Builder VCL Edition History

August 11, 2011

Active Query Builder VCL Edition v.1.17.3

+ Support of DevExpress VCL controls v2011 vol.1.5 is made.
- Localizer: Localization of TStrings is fixed.

July 17, 2011

Active Query Builder VCL Edition v.1.17.2

+ The new method is added to TacUnionSubQuery:
  ConvertDatasourceToDerivedTable(ADatasource): TacDatasourceQuery
+ TacUnionSubQuery: The new Clear method and SQL property (read-write)
  are added. Now you can modify the sub-query text separately.
+ The new TacDatasource.NameInQuery read-only property is added. 
  It allows to get datasource name as it should be referenced in the query.
= MS SQL: Loading objects from linked servers is restored.
= MySQL: Parsing of the ORDER BY clause is improved.
- Mimer Sql: Reference type is not supported by MimerSql. Fixed now.
- Alignment in UnionNavBar is suspended when updating the union buttons to
  prevent flickering.
- NexusDB 3 metadata provider compilation is fixed.
- AV on creating link by identical field names is fixed.

June 08, 2011

Active Query Builder VCL Edition v.1.17.1

+ MS SQL Server: Table and query hints are supported; join hints are parsed
  fine now, but not preserved due to architecture limitations.
+ TacMetadataRelation: Setters for ChildTable and ChildTableStr properties
  are made.
- SQLite: Parsing of sub-queries in condition cells is fixed.
- German translation: Wrong translation "Default"->"German" is reverted to
  "Default".
+ Advantage metadata provider is fixed. It's now can be used to work with DBF
  files.
= Firing the OnLinkCreating and OnLinkCreated events in AddFKLinksForObject and
  AddIdenticalFieldsLinksForObject methods is made.
= MySQL: UNSIGNED is treated as a valid data type now.

May 19, 2011

Active Query Builder VCL Edition v.1.17.0

+ The new TacQueryBuilder.OnActiveUnionSubQueryChanged event is added.
+ SQL queries that look like "select orders.orderId from orders o" are fixed
  now to "select o.orderId from orders o".
= Grouping is set automatically now on specifying the aggregate for a column.
= The "=TRUE" condition is set automatically on adding a logical expression now.
= The numbers entered into condition for string fields are treated as literals.
= MySQL Query Properties form is redesigned.
+ MySQL: The [Default|DISTICTS|ALL] query options are added to the Query 
  Properties dialog.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.
- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.
- Minor bugs on reomving CTE from query are fixed.

May 12, 2011

Active Query Builder VCL Edition v.1.16.22

= Support of DevExpress ver.56 is made. (Package name renamings were made)
+ The new method TacUnionSubQuery.AddLinksFromExpression() is added for manual
  adding of links with complex joining expressions.
- Fixed problem when a link was attached to wrong datasource on the design pane 
  in some rare conditions.
+ Metadata fetching support for NexusDB 3 is made.
- PostgreSQL: Parsing of logical expressions in criteria cells is fixed.
- Localizer: Loading of milti-line translated strings is fixed.
= Oracle: The GetSchemasListOracle procedure returns only schemas which have
  accessible database objects now.
= The Select checkbox is checked automatically now on adding a new expression.

May 04, 2011

Active Query Builder VCL Edition v.1.16.19

+ Automatic alias assignment is made when user adds two or more columns with 
  same name to the query. The warning message is shown when muptiple columns
  with same name appear in sub-queries in result of user actions as this may 
  lead to inconsistence in the calling sub-query.
+ The new OnUserMessage event is added. It is fired when the Query Builder is
  about to show the warning message to the user. You may override this 
  behavior by handling the OnUserMessage event.
= The CreateWhereJoinsByDefault property is moved to QueryBuilder.LinkOptions.
= The AddObjectWithFK method takes into account the CreateLinksByIdenticalFields
  property value now.
= C++ Builder 6 support is reverted.
- Minor bug fixes are made.

April 23, 2011

Active Query Builder VCL Edition v.1.16.18

+ SQLite: The component can load foreign keys now.
= SQLite: The list of aggregates and built-in functions is filled now.
+ The new TacQueryBuilder.LinkOptions.CreateLinksByIdenticalFieldNames property
  is added to instruct the component to add links between objects by identical
  field names (might be useful for legacy databases without foreign keys).
+ The new  TacBaseSyntaxProvider.CreateWhereJoinsByDefault property is added
  to instruct the component to create joins in WHERE clause, not using the JOIN
  keyword in FROM clause. Useful for Oracle databases when you want to use 
  Oracle style joins (+=, =+).
= Preserving additional ORDER BY attributes like "ORDER SIBLINGS BY" is made.
= Turkish.lng: correct order of params in "Unexpected token" error message
- Localizer "out of range" error when saving files is fixed.
- The component will not try to load fields from database now if they already
  loaded during execution of the DoObjectMetadataLoading event handler.
- MS SQL Server: Support of the OPENQUERY function is fixed.
- Few CTE bugs are fixed.

April 13, 2011

Active Query Builder VCL Edition v.1.16.16

= Language files are converted to UTF8. The component allows to read language 
  files in both ANSI and UTF8 encoding now.
- OleInitialize/OleUnintialize calls are corrected for C++ Builder support.
- Wrong SQL generation when object and database names are equal is fixed.

April 06, 2011

Active Query Builder VCL Edition v.1.16.12

+ The new property TacSQLBuilder.CTESubQueryFormat is made to define formatting
  rules of CTE sub-queries independently from derived tables.
- Better parsing of criteria expressions is made.
+ The new events are added to customize the result SQL query text:
  TacSQLBuilder.OnBeginBuildSQLForNode and TacSQLBuilder.OnEndBuildSQLForNode
= The AddNewCTE method performs names fixup for its AQuery argument now.
+ The new property TacMetadataContainer.LoadInvertedRelations is added to get
  relations assigned to the detail table instead of master table while loading
  metadata.

March 23, 2011

Active Query Builder VCL Edition v.1.16.11

+ OLE drag-and-drop of text items to design area and criteria grid is made.
+ The new properties are added to allow OLE drag'n'drop of text items to the
  Design Area (QueryBuilder.OLEDragAndDrop: Boolean) and the Query Colums Grid
  (QueryBuilder.SelectListOptions.OLEDragAndDrop: Boolean).
+ The new AParam.CompletionsList property in OnCustomExpressionBuilder event is
  added to get access to the list of datasource columns of the currently active
  sub-query.
= MySQL: more accurate checking of the current database request is made.
- Oracle: correct printing of objects with @DBLINK is made.
- Replacing name of stored proc with it's alias is fixed.
= C++ Builder 2007 and above installation procedure is fixed.
= Exception is not raised now on ParseExpression error, returning Null instead.