Active Query Builder History v.1.1.2.1015
+ The new properties are made to force the query builder to show or omit the AS keyword in alias definition. Use the QueryBuilder and PlainTextSQLBuilder get/setAsKeywordInExpressionAlias() and get/setAsKeywordInObjectAlias() methods for this purpose. + The new events are added to control unchecking of a field from the datasource field list: DatasourceFieldRemoving and DatasourceFieldRemoved. + Basic support for custom aggregate functions is implemented. + MS SQL Server: Custom aggregate functions retrieving is implemented. + Oracle, PostgreSQL: Interval literals are supported now. + The INNER keyword can be omitted now in join specifications for Firebird and MS SQL via the get/setInnerKeywordInLinks() property. = API changes: MetadataFieldNameList class is renamed to MetadataQualifiedNameList. - CROSS JOIN processing bug is fixed. - Wrong link context menu coordinantes when the diagram pane is scrolled down are fixed. - MSSQL: Parsing of DatePart and DateName functions is fixed. - Oracle: Parsing of "CONNECT BY" and "START WITH" clauses sequence is fixed. - Minor bugfix in metadata filtering is made. - Bug with duplicating mixed case field names from case sensitive servers is fixed. - MSSQL: Fixed parsing of fields those names match datatype names, like "DateTime".
Active Query Builder History v.1.10.2.191
- The bug with duplicating mixed case field names from case sensitive servers is fixed.
Active Query Builder History v.1.10.2.190
- MSSQL: Fixed parsing of fields with names matching datatype names, like "DateTime".
Active Query Builder History v.1.10.2.189
+ New properties in the QueryBuilder and PlainTextSQLBuilder components: AsKeywordInExpressionAlias and AsKeywordInObjectAlias. You can use them to force the query builder to always show or omit AS keyword before aliases. + The new events DatasourceFieldRemoving, DatasourceFieldRemoved are added to control removal of fields by unchecking them from the datasource field list. + Basic support for custom aggregate functions is implemented. + MSSQL: Custom aggregate functions retrieval is made. + Oracle, PostgreSQL: Interval literals are supported now. + The INNER keyword can be omitted now in join specifications for Firebird and MSSQL via the InnerKeywordInLinks property. = (!) API changes: MetadataFieldNameList class is renamed to MetadataQualifiedNameList. - The CROSS JOIN processing bug is fixed. - Wrong link context menu coordinates when the diagram pane is scrolled down are fixed.
Active Query Builder History v.1.13.10.0
+ Installer: C++ Builder 2010 support is fixed. + Installer: DevExpress ExpressSkins and QuantumTreeList versio auto detection and automatic sources configuration is made. - DevExpress ExpressSkins and QuantumTreeList 4 support is fixed. + Oracle and PostgreSQL: interval literals support is added. + Custom Aggregate Functions support is made. + MS SQL Server: Custom aggregate functions fetching is made. + The INNER keyword can be omitted now in join specifications for Firebird, Interbase and MS SQL Server via the InnerKeywordInLinks property. = NexusDB connectivity package is upgraded to 3.01. = DBISAM connectivity package upgraded to 4.28. = Refactoring: TacMetadataFieldNamesList is renamed to TacMetadataQualifiedNamesList. - CROSS JOIN processing bug is fixed. - LoadMetadataDemo and QueryModificationDemo are fixed for RAD Studio 2010. - Access violation when user delete a table which used in a correlated query is fixed. - The "NULLS FIRST" and "NULLS LAST" ordering options representation is fixed in grid. - Access violation in Delphi 5-7 when loading SQL in OnExit event of SQL edit is fixed.
Active Query Builder History v.1.13.10.0
+ The new Custom Metadata Loading demo for .NET is added. + Oracle and PostgreSQL: Interval literals support is added. + MS SQL Server: Custom aggregate functions fetching is made. + The INNER keyword can be omitted now in join specifications for Firebird, Interbase and MS SQL Server via the InnerKeywordInLinks property. - Aggregate function name duplication bug is fixed. - CROSS JOIN processing bug is fixed. - Access violation when user delete a table which used in a correlated query is fixed. - The "NULLS FIRST" and "NULLS LAST" ordering options representation is fixed in grid.
Active Query Builder History v.1.10.1.188
- [CRITICAL] Drag and drop bug is fixed.
Active Query Builder History v.1.10.0.187
+ The new CriteriaListControlInitialization event is added for additional customization of the grid. = Appearance of the DevExpress implementation of DataSourceControl is improved. = DevExpress controls support is improved.
Active Query Builder History v.1.1.1.1014
+ New property is added to allow visual setting of NULLS FIRST/NULLS LAST options: getCriteriaListOptions().setShowNullOrderingInSortTypeColumn(). + Firebird 2.5 support is added. + The new setInnerKeywordInLinks() property is added to SQLBuilder and QueryBuilder components to suppress the "INNER" keyword in joins. + SQL2003 syntax: Support for OVERLAPS expression is added. - Firebird: Identifiers validity checks is fixed. - Sybase ASE support is fixed. - Parsing of highly parenthesized WHERE joins is fixed. - Right quotation in "Alias" column is made. - Right interpretation on writing the "='" and "'" strings in condition cell. - MSSQL: NULLIF function support is fixed. - PostgreSQL: SIMILAR TO operator support is fixed. - PostgreSQL: Escaped and unicode string literals support
Active Query Builder History v.1.9.7.186
+ The new property is added to allow visual setting of NULLS FIRST/NULLS LAST options: queryBuilder.CriteriaListOptions.ShowNullOrderingInSortTypeColumn. + Firebird 2.5 support is added. + New property InnerKeywordInLinks is added to SQLBuilder and QueryBuilder components to suppress the "INNER" keyword in joins. = DevExpress dependencies is updated to version 9.1.5. + SQL2003: support for OVERLAPS expression is added. - Firebird: Identifiers validity checks is fixed. - Sybase ASE support is fixed. - Parsing of highly parenthesized WHERE joins is fixed. - Right quotation in "Alias" column is made. - Right interpretation on writing the "='" and "'" strings in condition cell. - MSSQL: NULLIF function support is fixed. - PostgreSQL: SIMILAR TO operator support is fixed. - PostgreSQL: Escaped and unicode string literals support - Showing of the Query Properties dialog is fixed with Auto Syntax Provider.
Active Query Builder WinForms .NET Edition:
Active Query Builder WPF .NET Edition:
Active Query Builder ASP.NET Edition:
Active Query Builder Java Edition:
Active Query Builder ActiveX Edition:
Active Query Builder VCL Edition:
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!