Active Query Builder VCL and ActiveX Editions 1.19 are 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.19?
VCL Edition: Support of RAD Studio XE3 is made.
User interface and behavior changes:
Now the double click on a datasource field appends it to the query column list but does not select it as output column.
The height of a newly added datasource is set optimally according to the design area height when the MaxTableHeight property is set to default value (zero).
ANSI SQL/92, SQL/2003 syntaxes: Query Properties form is added to edit the DISTINCT clause.
Column expression is emitted instead of column alias for ORDER BY items.
Alias of a sub-query in expression is used now for sub-query tab caption.
API changes:
The new properties were added for more customizable SQL query text formatting:
- TSQLBuilderFromClauseFormat: NewLineBeforeComma, NewLineBeforeJoinExpression;
- TSQLBuilderItemsListFormat (formats SELECT list, GROUP BY and ORDER BY items): NewLineBeforeComma;
- TSQLBuilderPlainText.DynamicIndents: allows to indent the next item in the list to the same position as the first item;
- TSQLBuilderPlainText.DynamicRightMargin: instructs the component not to take into account leading spaces when counting line lenght to wrap.
The new events are added to support the newly added sub-query editing modes:
- TacQueryBuilder: OnActiveSubQueryChanging and OnActiveUnionSubQueryChanging;
- TacSQLBuilderPlainText: OnQueryPartChanging, OnQueryPartChanged.
SQL syntax fixes and improvements:
MS SQL Server: FOR XML is supported in subqueries now.
MS SQL Server: Support of static method calls of CLR types is added (ex. "geometry::STGeomFromText(...)")
MS SQL Server, MySQL, PostgreSQL: Loading of precision and scale for numeric fields from server system catalogs is fixed.
PostgreSQL: Analytic expressions support is made.
PostgreSQL: Typed literal support is added: "date '2001-09-28' + integer '7'".
Oracle: Support of new types is added (SIMPLE_INTEGER, SIMPLE_FLOAT, SIMPLE_DOUBLE).
Oracle: Support for the full syntax of XMLAGG aggregate function is made.
Firebird: The new aggregate LIST, WEEKDAY and YEARDAY keywords in EXTRACT function are added.
Firebird: CURRENT_USER, CURRENT_ROLE, CURRENT_TRANSACTION, CURRENT_CONNECTION constants are added.
Interbase: CASE function is supported.
Other fixes and improvements:
Loading of ORDER BY for queries like "SELECT a.* from a ORDER BY field" is fixed.
Metadata Container: Access to the metadata objects is synchronized now.
The QueryStatistics.OutputColumns[i].ColumnName property value is always unquoted now.
DevExpress UI: Design area and Select list use DevExpress scrollbars now.
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!