Active Query Builder ActiveX Edition v.1.23.11
= "No linked objects" menu item is shown if linked ojbects are not found. + MS SQL Server: Support for new analytic functions SQL Server 2012 is made. + Datasource is focused on mouse hover to display the linked objects button.
Active Query Builder ActiveX Edition v.1.23.10
- TacDatasourceControl.Collapsed property is fixed. - Fields list calculation for recursive CTEs is fixed.
Active Query Builder ActiveX Edition v.1.23.8
= QueryTransformer does not wrap query if limits are empty. = QueryTransformer obeys the QueryBuilder.SleepMode flag now.
Active Query Builder ActiveX Edition v.1.23.7
= Universal syntax: Query properties form to add DISTINCT clause is added, list of reserved words is extended. = MS Access syntax: It is possible to parenthesize complex join expressions as it's necessary when working with MS Excel. = OLE DB connection: Forced to sort list of fields by ordinal position.
Active Query Builder ActiveX Edition v.1.23.6
- MS SQL Server: A workaround for loading metadata via ODBC driver is made.
Active Query Builder ActiveX Edition v.1.23.4
= Small improvements in asyncronous SQL execution are made. = Demo projects: The RefreshMetadata method call after Connect is removed, as it is called automatically on connect.
Active Query Builder ActiveX Edition v.1.23.3
= MS Access: Backtick-quoted identifiers are accepted now. They will be converted to square brackets during the query generation.
Active Query Builder ActiveX Edition v.1.23.2
- Prevent races on RefreshMetadataAsync and RefreshMetadata calls. - Minor fixes in the Query Transformer are made.
Active Query Builder ActiveX Edition v.1.23.1
- Installer: Fixed problem with registration of the main OCX. - MS SQL Server: Parsing of aggregated functions is fixed. - DB2: Parsing of Hex, Graphics and Unicode string literals is fixed. - MS Access: Built-in functions list is fixed.
Active Query Builder ActiveX Edition v.1.23.0
+ Asyncronous metadata loading support is made. + MS SQL Server: MS SQL Server 2014 is supported. - MS SQL Server: method call chain parsing is fixed. = MS SQL Server: keywords list is updated. + PostgreSQL: WITH clause support is made. = PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object columns (formerly used "LIMIT 1"). + Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed. + Oracle: Interval expressions are supported now. = DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are supported now. = DB2: Short object names are used in case of SYSTEM naming convention. - MySQL: DATE and TIME types parsing ambuiguities 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!