Active Query Builder 3 WPF Edition v.3.6.14.1171
= Snowflake SQL: Support for the "WITHIN GROUP" clause has been added.
Active Query Builder 3 WPF Edition v.3.6.13.1170
- Snowflake SQL: LimitCount and LimitOffset props are turned on to use the Skip and Take methods of the QueryTransformer.
Active Query Builder 3 WPF Edition v.3.6.12.1169
+ The user's job of adding general aggregate functions (with the "*" parameter) has been improved. Now the user can select an aggregate function right in the empty row of the Query Columns Grid. - Snowflake SQL: Parsing of VARCHAR without char count has been fixed. - Incorrect context menu was displayed for nodes of the Database Schema Tree. Fixed now. - The position of context menus on the screen as scale increases has been fixed. - SQL Text Editor now uses the form's back color by default.
Active Query Builder 3 WPF Edition v.3.6.11.1168
+ The new event to track changes in the Favorites folder is added: QueryBuilder.FavouritesChanged. (in the Professional version only) = The new method to append metadata from XML is added: MetadataContainer.AddFromXML(filename or stream). - Snowflake syntax: "LANGUAGE" is removed from the list of keywords. - SAP Hana: Minor SQL generation fixes are made. - MySQL: Minor fixes for queries with the "~" character.
Active Query Builder 3 WPF Edition v.3.6.10.1167
= ODBCMetadataProvider: new properties are added to turn off some specific driver features that sometimes can improve the performance: IgnoreSchemaOnlyFlag and SkipLoadFieldsFromGetSchema. - MySQL: Logical conditions aren't suffixed with "=True" or "=False" anymore. - IBM DB2: System views are checked for existence before querying them.
Active Query Builder 3 WPF Edition v.3.6.9.1166
+ Support for Snowflake DB SQL syntax has been added. + The SubQuery Navigation Bar now lets you know more about sub-query usage at one sight: query part, operator, correlatedness. = Searching in the Add Object Dialog is corrected. = SQL Server: The connection form lets define new authentication options for Azure databases. - Minor fixes in the Query Columns Grid have been made. - Assemblies are removed correctly now after uninstalling the product.
Active Query Builder 3 WPF Edition v.3.6.7.1165
= The BehaviorOptions.LinkManipulations property is taken into account when creating a new link using datasource context menus, notification events are fired correctly then. = On trying to link a table to itself, a copy of that table is added to the query and linked accordingly. - The bug with multiline field descriptions drawn on the same line is fixed.
Active Query Builder 3 WPF Edition v.3.6.6.1164
+ Users now can create links from UI separately indicating fields to start and finish a new link via the datasource field context menu. + Three new events are added to the CriteriaBuilder control: NeedEditorForValue, NeedCustomLookupButton, NeedCustomLookupControl. They allow for using custom editors for values of specific fields or data types. + The new demo project CriteriaBuilderCustomize is added to illustrate the way how one can use custom editors, buttons and controls in the CriteriaBuilder control. + Source code of the Metadata Container Editor is included in a set of demo projects for Trial and Professional versions. = Criteria Builder: minor fixes and improvements are made. = QuickBooks: Support for square-brackets quoted identifiers has been added. - The bug with checking/unchecking an asterisk item in datasources is fixed.
Active Query Builder 3 WPF Edition v.3.6.5.1163
+ Metadata loading errors are displayed now via the notification bar. + The new property QueryBuilder.BehaviorOptions.AllowMessageTypes is added to determine the types of messages to be shown in the notification bar. + The new property QueryBuilder.DesignPaneOptions.DesignPaneOverviewMaxHeight is added to determine the maximum ratio (range from 0 to 1) of the overview pane height and overall Design Pane height. The actual width and height of the overview pane is now calculated according to new and DesignPaneOverviewWidth properties. = Significant performance improvements are made. = QuickBooks (QODBC): Support for the TOP clause is added, support for derived tables is turned off. = PostgreSQL: Backslash quotation for generic string literals has been removed. = Metadata serialization to XML: The "Loaded" flag for all types of objects is now set on for a namespace if child database objects of any type exist.
Active Query Builder 3 WPF Edition v.3.6.3.1162
+ Initial support for QuickBooks (QODBC) SQL syntax has been added. + Performance and memory consumption improvements on loading large database schema has been made. ! "Loaded" flags for object types and referencing foreign keys are saved now in metadata XML files to avoid unnecessary SQL queries to be fired. = SAP HANA: Minor fixes are made: DISTINCT before TOP, PLACEHOLDER before alias, NVARCHAR builtin type. - Image sources are fixed now.
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!