Active Query Builder History v.1.28.8
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added. = Pervasive: List of keywords and functions has been filled. = Pervasive: Support of IF function, LIMIT/OFFSET clause has been made. - Pervasive: Parsing of date/time builtin functions has been fixed. - Teradata: The bug with the autodetection of new versions has been fixed. - SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing exception now. - IBM DB2: NULL is parsed as a constant, not as an identifier. = The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed. Links are created only if one of the fields is a part of the primary key. = Loading of Primary Key fields has been improved. = Complex SQL expressions aren't loaded as joins anymore. - Changing of the link type if RIGHT JOIN is not supported is not allowed now. - The bug with the height calculation of the UNION navigation bar when the query has unions in brackets has been fixed. - Memory leaks have been eliminated.
Active Query Builder History v.1.28.8
+ Initial support of SAP Hana SQL syntax has been added. = Oracle: Support for the new Oracle 12c LISTAGG syntax has been added. = Pervasive: List of keywords and functions has been filled. = Pervasive: Support of IF function, LIMIT/OFFSET clause has been made. - Pervasive: Parsing of date/time builtin functions has been fixed. - Teradata: The bug with the autodetection of new versions has been fixed. - SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing exception now. - IBM DB2: NULL is parsed as a constant, not as an identifier. = The new limitation of the trial edition: generation of random aliases for the query output columns. + The new method TacSubQuery.GetSqlForDataPreview() returns correct SQL query to preview the sub-query result data. = The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed. Links are created only if one of the fields is a part of the primary key. = FireDAC: Loading of Primary Key fields has been improved. = Complex SQL expressions aren't loaded as joins anymore. - Changing of the link type if RIGHT JOIN is not supported is not allowed now. - The bug with the height calculation of the UNION navigation bar when the query has unions in brackets has been fixed. - Memory leaks have been eliminated.
Active Query Builder History v.1.9.0.1154
- MySQL: The bug with getting the default database name has been fixed. - Query Columns List: Grouped expressions are now loaded with the default condition type "For values". - MSSQL: The ambiguity on parsing of the method call has been solved. - Oracle: Parsing of the CYCLE identifier has been fixed.
Active Query Builder History v.3.2.4.1
- Criteria Builder: The bug with the bool fields type has been fixed. - Criteria Builder: The bug with the load of invalid logical expressions has been fixed.
Active Query Builder History v.3.4.19.1100
- CriteriaBuilder: Boolean conditions loading has been fixed.
Active Query Builder History v.3.4.19.1100
- CriteriaBuilder: Boolean conditions loading has been fixed.
Active Query Builder History v.3.4.19.1100
- CriteriaBuilder: Boolean conditions loading has been fixed.
Active Query Builder History v.3.2.4
+ The new "Properties" item has been added to context menus of Objects, Links and the Canvas itself (Query properties). + Possibility to catch error both on the server and client has been added. 1. The new BaseHandler.OnException event has been made. It allows overriding the message passed to the client. 2. The new AQB.Web.QueryBuilder.Events.OnError method allows informing the user about the error in another way. + The new property CriteriaBuilder.dateFormat allows changing the date display format. Default value: "dd.mm.yy". Possible values are listed here: https://api.jqueryui.com/datepicker/#option-dateFormat + The new DataSourceOptions.resizeMode property has been added to change the way the user can resize objects in the Canvas. Default value: "se" (bottom-right corner). Possible values are listed here: https://api.jqueryui.com/resizable/#option-handles - Criteria Builder: The bug with the bool fields type has been fixed. - The bug with displaying splitters in the Internet Explorer has been fixed. = Other minor changes have been made.
Active Query Builder History v.3.4.19.1099
= The current active sub-query is saved now in the XML structure of the LayoutSQL property.
Active Query Builder History v.3.4.19.1099
= The current active sub-query is saved now in the XML structure of the LayoutSQL property.
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!