Downloads  »  Active Query Builder VCL Edition History

November 13, 2007

Active Query Builder VCL Edition v.

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

- PostgreSQL: Fail to parse expressions "like 'qwe' || 'qwe2'" that were entered
  in the grid. Fixed now.
- Internal query loading issues were fixed.
- The new OnValidatePopupMenu event is added to modify internal pop-up menus. See
  example and definition in details.
[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

Active Query Builder VCL Edition v. in details

The new event that allows you to modify internal popup menus of the component is added.

  TacOnValidatePopupMenu = procedure (Sender: TacQueryBuilder; 
    AControlOwner: TacQueryBuilderControlOwner; AForControl: TControl;
    APopupMenu: TPopupMenu) of object;

The OnValidatePopupMenu is the event of TacQueryBuilder object. An example of usage is below:

procedure TForm2.qbValidatePopupMenu(Sender: TacQueryBuilder;
  AControlOwner: TacQueryBuilderControlOwner; AForControl: TControl;
  APopupMenu: TPopupMenu);
var mi:TMenuItem;
  if (AControlOwner is TacUnionSubQuery) and (AForControl is TacQueryBuilderWorkArea)
  then begin
    // remove all items

    // add custom item
    mi := TMenuItem.Create(Self);
    mi.Caption := 'My menu item';
    // assign handler
    //mi.OnClick := MyOnClick;

This example modifies popup menu of the query building area. The following combinations are available for the AControlOwner and AForControl parameters:

  • AControlOwner is TacUnionSubQuery: represents Union Sub-query object
    • AForControl is TacQueryBuilderWorkArea: the working area itself
    • AForControl is TacUnionButton: the union subquery button at the top-right corner
  • AControlOwner is TacLink: represents a link that joins two tables
    • AForControl is TacQueryBuilderLinkControl: visual control that draws a link
  • AControlOwner is TacSelectItem: represents an item in the Select List
    • AForControl is TacQueryBuilderSelectListControl: the columns pane (bottom grid)
    • AForControl is TacQueryBuilderSelectListInplaceEdit: inplace editor in the grid
  • AControlOwner is TacDatasource: represents an object at the query building area
    • AForControl is TacQueryBuilderDatasourceControl: visual control for datasource object
  • AControlOwner is TacUnionGroup: represents a group of unions enclosed with brackets
    • AForControl is TacLeftBracket: left bracket control
    • AForControl is TacRightBracket: right bracket control

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

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:




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