We're glad to announce the new minor version of Active Query Builder. You can download the newest version from the download page.
What's new in the Active Query Builder VCL Edition version 1.4.5?
TacQueryBuilder: The new MetadataPrefilter property is added to implement pre-filtration of database objects. This feature can decrease metadata loading time dramatically in case of huge number of tables in the database when only a small set of them is required to operate with. The MetadataPrefilter.ExcludedSchemas string list should contain names or masks of schemas to be excluded from the list of database objects and the MetadataPrefilter.IncludedSchemas should contain names or masks of schemas to be included in the list of database objects. Actually these properties will add some constraints to the WHERE clause of all metadata retrieving queries, i.e. each line in the IncludedSchemas list will add the 'LIKE' clause while each line in the ExcludedSchemas list will add the 'NOT LIKE' clause.
TacQueryBuilder: The new Parameters property is added to retrieve the list of parameters. Use the Parameters.Count property to get the number of parameters in the query and the Items[i] property to get access to each parameter in the query.
TacQueryBuilder: The new GridFont, TableFont and TreeFont properties are added to change fonts (and their charsets) used in each part of the TacQueryBuilder component.
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!