Active Query Builder Java Edition v.1.1.3.1018
+ Portuguese (Brazil) translation is added. + Oracle: Retrieval of descriptions for objects and fields from the database is implemented. + SQLite: The query properties form is implemented. + SQLite: Ability to fetch metadata from "attached" databases is added. + New helper methods are added to the BaseSQLContext object for splitting full object names by parts: ExtractNameFromFullName(), ExtractSchemaFromFullName(), ExtractDatabaseFromFullName(). + Bunch of helpers are added to the MetadataContainer to add objects by theirs full or partially qualified name: AddObject(), AddTable(), AddView(), AddProcedure(), AddSynonym(). = The LIKE criteria parsing is improved. Manually entered criteria like "LIKE John Doe" will be distinguished as "LIKE 'John Doe'". - SQLite: LIMIT support in the main query is fixed. - SQL dialects without multiple database support (like Oracle) didn't skip default schema from object names. Fixed now. - Oracle: Parsing of the SEED keyword is fixed.
Active Query Builder Java Edition v.1.1.2.1017
- Oracle: Parsing of the SEED keyword is fixed.
Active Query Builder Java Edition v.1.1.2.1016
- Fixed crash when clicking at the Aggregate column cell.
Active Query Builder Java Edition 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 Java Edition 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 Java Edition v.1.1.0.1013
- Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart.
Active Query Builder Java Edition v.1.1.0.1012
- PostgreSQL: bug in parsing of INTO clause is fixed.
Active Query Builder Java Edition v.1.1.0.1011
+ Ability to define custom expression builder for the Expression and Criteria columns of the Criteria List is made. To activate this option, you should set the getCriteriaListOptions().setUseCustomExpressionBuilder() property and handle the CustomExpressionBuilderEvent event. See the "CustomExpressionBuilderDemo" source code sample.
Active Query Builder Java Edition v.1.0.10.1010
+ Localization is implemented. See the README.TXT in 'language_files' directory.
Active Query Builder Java Edition v.1.0.9.1009
+ The "Insert sub-query" popup menu is added to Expression and Criteria column cells. - The bug with saving of relation child cardinality to XML file is fixed. - The bug that leaded to exponential grow of parsing time for some FROM clauses is fixed.
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!