Downloads  »  Active Query Builder VCL Edition History

November 13, 2007

Active Query Builder VCL Edition v.1.8.0.4

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

- 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.1.8.0.4 in details

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

type
  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;
begin
  if (AControlOwner is TacUnionSubQuery) and (AForControl is TacQueryBuilderWorkArea)
  then begin
    // remove all items
    APopupMenu.Items.Clear;

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

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