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 version 1.5?
The new MetadataContainer property is added to provide access to the list of metadata objects used in the component. With its help, you can add or remove items manually to restrict certain tables being displayed in the component or you may even fill the entire metadata container by yourself to avoid connecting to the database.
The MetadataContainer property is a collection of metadata objects. You may iterate through the loaded metadata objects, add or remove them.
You are able to load additional metadata information from another databases by using the LoadMetadataByMask method of the MetadataContainer collection.
procedure LoadMetadataByMask(ANameMask: OleVariant; ASchemaMask: OleVariant; ADatabase: OleVariant);
The first two parameters are the masks for object names and schemas respectively. The third parameter is the database name from which you want to load metadata. If you don't want to filter objects loaded by name or schema, you should use the "%" symbol for the first two parameters, so the call will look like:
ActiveQueryBuilder.MetadataContainer.LoadMetadataByMask("%", "%", "database_name")
or, if you want to load only the 'dbo' schema from the database, you may use the following code:
ActiveQueryBuilder.MetadataContainer.LoadMetadataByMask("%", "dbo", "database_name")
The ANameMask and ASchemaMask parameters will be applied to the metadata retrieving query using the LIKE operator.
The new MetadataFilter property is added to implement (pre)filtration of database objects. This feature can speedup metadata loading process dramatically if there is a huge number of tables in the database and only a small set of them is operated with.
The MetadataFilter property is a collection of metadata filter items. Each item specifies one inclusion or exclusion condition that can affect specific object types (tables, views or procedures) and filter objects by object name and schema name using masks.
You may use "_" to represent any single character and "%" to represent any sequence of characters. You can test this feature using demo projects by opening the Properties dialog and selecting the "DB Objects Filtration" tab.
* These features will be available in the Standard Edition of Active Query Builder only.
Comments by Disqus:
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.