Active Query Builder ActiveX Edition v.1.24.11
= Focus is not moved on mouse hover over datasources on the Design pane if the component is not focused. - Incorrect loading of ORDER BY is fixed.
Active Query Builder ActiveX Edition v.1.24.10
- Minor parsing speed improvements are made.
Active Query Builder ActiveX Edition v.1.24.9
= Scanner performance optimizations are made.
Active Query Builder ActiveX Edition v.1.24.8
= DB2: The query to load default schema is corrected for older mainframes. = DB2: Metadata objects loading is improved for older mainframes: fallback to QSYS2.SYSTABLES is made. - Loading join conditions with references to objects from parent query is fixed. - Loading FROM clause enclosed with parenthesis is fixed. - Memory leak is fixed.
Active Query Builder ActiveX Edition v.1.24.7
+ SQLite: Support CTE at sub-queries level is added. = Oracle: Oracle8i compatibility fixes are made. = Comments parsing is fixed.
Active Query Builder ActiveX Edition v.1.24.6
+ Support for AdvantageDB SQL syntax is made. Set the SQLSyntax property to xsAdvantage=130 to select this syntax. - Minor bug fixes are made.
Active Query Builder ActiveX Edition v.1.24.5
- General SQL parsing bug is fixed.
Active Query Builder ActiveX Edition v.1.24.4
= SQL parser fix is made. (affects all SQL dialects)
Active Query Builder ActiveX Edition v.1.24.3
+ SQLite: Backtick quoted identifiers are supported now. + SQLite: Support for Common Table Expressions is made. It was added in SQLite v3.8.3 released on 2014-02-03. + The new property SelectListOptions.CreateColumnAliasesForUnnamedColumns is added to instruct the component to add aliases for unnamed fields (expressions, aggregates) automatically. It is turned on by default. = MS SQL Server, DB2: QueryTransformer now uses ROW_NUMBER ranking function to implement Skip and Take methods for these servers. - Add Linked Objects menu now creates links for all fields for multi-column foreign keys (not only for the first field). - Error on deleting datasource in subquery is fixed. - MS SQL Server: Pound symbol is removed from the list of valid identifier letters.
Active Query Builder ActiveX Edition v.1.24.0
+ The new SelectListOptions.ResolveColumnNamingConflictsAutomatically property is added to instruct the component to generate unique aliases for explicitly specified query columns to avoid duplicated column names. + PostgreSQL: RECURSIVE keyword in WITH clause support is added. + Parametrized queries are used now to fetch fields list for MS SQL Server and Oracle to reduce the load on the server when retrieving metadata. + Oracle: SearchClause and CycleClause in WithClauseItems is supported. = Case-insensetive comparison is used now when creating unique aliases. - MySQL: Quoted characters in string literals are supported now. - Firebird: WEEK date part support is added.
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!