Active Query Builder ActiveX Edition v.1.21.7
+ Query layout is now preserved after parsing of the modified query. + Algorithm of automatic objects placement on the diagram pane is improved. - Small fixes for MSStyleGrouping mode are made.
Active Query Builder ActiveX Edition v.1.21.6
= Alternate Names now obey server identifier case sensitivity rules. - The bug with incorrect bracketing of inner OR conditions is fixed. = MS Access: Builtin functions siffixed with the dollar sign are supported now. - Oracle: Usage of the "TIMESTAMP" keyword as column name is possible now. = MS SQL Server: Table hints are updated according to the SQL Server 2012 specification.
Active Query Builder ActiveX Edition v.1.21.5
- SQLite: Fields list loading for tables with BLOB columns through ODBC is fixed.
Active Query Builder ActiveX Edition v.1.21.4
- Recently introduced bug that led to the emptiness of field lists is fixed.
Active Query Builder ActiveX Edition v.1.21.2
- Deadlock on OCX unload in Clarion is fixed.
Active Query Builder ActiveX Edition v.1.21.1
= PostgreSQL: LEFT and RIGHT builtin functions are supported now.
Active Query Builder ActiveX Edition v.1.21.0
+ The new IQueryTransformer interface is added. It is intended to easily modify SQL query sorting, filtration and aggregation programmatically. You can get it's instance via the IActiveQueryBuilderX.QueryTransformer property. + The new properties are added to the ExpressionBuilderParams class that is passed to the OnCustomExpressionEditor event handler: ExpressionKind (ekExpression, ekWhere or ekHaving), RelatedExpression, RelatedField, RelatedObject. = Internal change: Binding of column names is not performed now if fieldless datasources are in the scope. = MySQL: The BINARY prefix operator is supported now.
Active Query Builder ActiveX Edition v.1.20.4
+ Oracle: REGEXP_LIKE function is supported now. = Usage of aliases in ORDER BY is corrected. - MS Access: Support of aliases in ORDER BY clause is turned off.
Active Query Builder ActiveX Edition v.1.20.3
+ Direct connection to ODBC data sources is possible now. You can simply assign your ODBC connection string to the ConnectionString property. = "Check/Uncheck All" items are added to the context menu of derived table's field list. - MS Access: LEFT and RIGHT are accepted as builtin function names now. - Grouping doesn't set now on assigning sort order for aggregated expressions. = Additional brackets are added now on loading conditions to a non-empty cell. - FieldsList.ItemHeight is updated now when TableFont is changed. = Alias quotation is removed in the Alias column.
Active Query Builder ActiveX Edition v.1.20.2
- Scrolling of partially visible items before check in DataSource check list box is handled correctly now. = Aliases are emitted in the Order By clause when possible. = French localization is updated.
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!