Active Query Builder VCL and ActiveX 1.9.1 released
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.9.1?
Common changes
Sleep mode is implemented. *
This mode allows you to suppress error messages while printing unsupported
statements in SQL text editor, connected with Active Query Builder.
Active Query Builder now switches to Sleep mode when non-SELECT statement is
passed to the SQL property. This allows your end-users to write any other
statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc.,
without any additional processing.
New properties are added to parenthesize conditions in WHERE clause. *
The new boolean QueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode
property is added to hide the database node from metadata objects tree when
there is only one database is loaded to the metadata container.
The new demo is added to illustrate ability to replace real object and field
names with user-friendly alternate names (Demos/AlternateNames).
PostgreSQL query properties form is added.
Numerous fixes in MySQL, DB2, Sybase and other SQL dialects.
Chinese, Italian, German and Portuguese (Brazil) localizations files are
updated. Spanish, Czech, Turkish and Japanese localization require updating.
Please let us know if you can update one of them.
ActiveX Edition
The new demo is added to provide various examples of working with Active
Query Builder API (Non-Visual Demo).
VCL Edition
Tne new demo project is added to illustrate ability to modify queries
programmatically (Demos/QueryModificationDemo).
The new metadata provider is added for the CoreLab Interbase DAC package
(www.crlab.com/ibdac): TacCrIbDACMetadataProvider.
New properties are added to the TacQueryBuilder.TreeOptionsMetadata to change
captions for database object type grouping nodes: TablesNodeName,
ViewsNodeName, ProceduresNodeName, SynonymsNodeName :WideString;
TMS Unicode controls are supported now (in Standard version with Source code only).
The new TacQueryBuilder.OnActiveSubQueryChanged event is added.
* Learn more about Sleep mode and conditions parenthension here:
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!