Active Query Builder History v.1.8.5.3
- Minor fixes in the installation package were made.
Active Query Builder History v.1.8.5.2
+ The new metadata provider for AnyDAC (www.da-soft.com) is added. + The new metadata provider for NativeDB (www.nativedb.com) is added. - AQB didn't allow to select the expression for output on some stages of building queries with grouping. Fixed now.
Active Query Builder History v.1.8.5.2
+ The new property IActiveQueryBuilderX.UsedSQLSyntax is added to retrieve the actually used SQL syntax provider when using the auto detection of database server (SQLSyntax = xsAuto). - AQB didn't allow to select the expression for output on some stages of building queries with grouping. Fixed now.
Active Query Builder History v.1.8.5.0
+ Added possibility to compile the component on the base of TNT Unicode visual library. (this option is available for the customers of Standard version with Source Code only) + TacQueryBuilder: The new OnAfterCreateControl and OnBeforeDestroyControl events were added to configure internal properties of query builder controls. - MS SQL Syntax: The bug with parsing of CTE sub-queries is fixed. - Other minor bugs were fixed.
Active Query Builder History v.1.8.5.1
+ Unicode support in the Columns pane and in all the Properties windows is implemented. (the rest of visual controls were already Unicode compatible before)
Active Query Builder History v.1.8.0.13
+ SQL2003 Syntax: The CURRENT_DATE, CURRENT_TIME and LOCALTIMESTAMP constants are supported now. + Firebird syntax: common table expressions are supported now. + Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made. - Fixed falling into the recursion when using an unaliased query with ORDER BY clause, if the select item alias is specified in the ordering list.
Active Query Builder History v.1.8.0.13
+ SQL2003 syntax: The CURRENT_DATE, CURRENT_TIME and LOCALTIMESTAMP constants are supported now. + Firebird syntax: Common table expressions are supported now. + Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made. - Fixed falling into the recursion when using an unaliased query with ORDER BY clause, if the select item alias is specified in the ordering list.
Active Query Builder History v.1.3.8.69
+ Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made. - Minor bug in MySQLSyntaxProvider is fixed (affected the Visual sample project).
Active Query Builder History v.1.8.0.12
- The EventMetadataProvider did not call the GetSQLFieldsList event. Fixed now. + EventMetadataProvider: The new events OnLoadTableMetadata, OnLoadViewMetadata, OnLoadProcedureMetadata, OnLoadSynonymMetadata are added. Use them to load the fields list for appropriate objects using the TacMetadataObject reference. + Oracle syntax: QueryBuilder now has support of Oracle specific types.
Active Query Builder History v.1.8.0.12
- The bug with getting AV on clicking the Apply button of Properties window is fixed. + Oracle syntax: QueryBuilder now has support of Oracle specific types.
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!