Downloads  »  Active Query Builder VCL Edition History

January 06, 2009

Active Query Builder VCL Edition v.1.10.12.0

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

--- General Improvements -------------------------------------------------

+ New datasource context menu items are added to check/uncheck all fields 
  for a datasource.

+ Downgrade links of loaded query is implemented when Syntax changed to one 
  which doesn't support ANSI joins.

+ New property is added to sort fields within the datasource field lists: 
  TacQueryBuilder.FieldsListOptions.SortType: TacFieldsListSortType = 
  (flsNone, flsName)

+ New properties are added to take control over the links creation process: 
  TacQueryBuilder.LinkOptions: TacLinkOptions
  - LinkManipulations: enum(lmAllow, lmDeny, lmAllowRelationsOnly)
    allows/denies link creation by end-user, or allows creation of links 
    for foreign keys only;
  - CreateLinksFromRelations: Boolean
    allows/denies automatic links creation from foreign keys;
  - LinkCompatibleTypesOnly: Boolean
    allows links creation only for fields with compatible data types only.

+ New events are added to control specific end-user manipulations:  
  - TacQueryBuilder.OnBeforeDatasourceFieldDrag:
    set this event to deny dregging of specific fields to create links;
  - TacQueryBuilder.OnLinkCreating, TacQueryBuilder.OnLinkCreated:
    set these events to allow/deny or perform actions on creating a link;
  - TacQueryBuilder.OnLinkDeleting:
    set this event to allow/deny deletion of a link;
  - TacQueryBuilder.OnGridCellChanging, TacQueryBuilder.OnGridCellChanged:
    set these events to allow/deny or perform actions on changing values 
    at the columns pane grid.
    

+ New events are added to control displaying of the properties dialogs: 
  TacQueryBuilder.OnBeforePropertiesDialog and OnAfterPropertiesDialog.

+ New event is added to customize captions of datasources at the query 
  building area: TacQueryBuilder.OnCustomizeDatasourceCaption.

--- Syntax fixes and improvements ----------------------------------------

- DB2: Fixed problem with retrieval of the current schema for DB2 for AS/400.

+ Oracle: Support of EXTRACT function is added.
- Oracle: improved parameter name parsing is made.
- Oracle: "ZONE" is now treated as valid identifier.

- MS SQL: improved parameter name parsing is made.

+ MS Access can load queries with unquoted semi-keywords as field names now.
  (like "select a.select from orders a")

--- General bug fixes ----------------------------------------------------

- Bug with wrong hashing of alternate names in metadata container is fixed.

- The component is able to parse queries like the following correctly:
  "select [[[]]].OrderId from Orders [[[]]]"

--- VCL fixes and improvements -------------------------------------------

- ElevateDB 1/2 and DBISAM support is fixed.
+ Numerous improvements in the installer are made.
+ DevArt UniDAC connectivity package is added.
- Localizer fix for BDS 2009 is applied.
- Package description files are fixed.
+ ExpressSkins workaround is made.
+ Update of the DOA connectivity package to 4.1 is made.

[           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