Active Query Builder 3 WinForms Edition v.3.7.19.1194
+ The user can collapse the Preview area in the bottom-right corner of Design Pane to an icon. It becomes completely hidden when the query diagram fits the Design Pane. + It is now possible to switch grouping on and off via the Design Pane context menu. + Grouping marker is displayed for fields in the data source field list (curly bracket is now used for grouping; sigma for aggregation). = Pervasive: Parsing of the DateAdd, DateDiff, and DatePart functions and DOUBLE built-in type are fixed. = DB2: Parsing of the EXCEPTION join and parsing backslash as a division in expressions are fixed. - Scaling of the top-right toolbar on the Design Pane is fixed. - The update of cell value after using the Expression Editor has been fixed.
Active Query Builder 3 WinForms Edition v.3.7.18.1193
+ When the last CTE reference is removed, a prompt to remove from the query the CTE itself contains the link to switch to it. = Query Structure Demo: The dumping of the WHERE clause is improved. - Pervasive SQL: The parsing of the IF built-in function is fixed.
Active Query Builder 3 WinForms Edition v.3.7.17.1192
- The bug with focusing on a wrong property on clicking the "Fix issue" anchor is fixed. - Minor localization and other fixes are made.
Active Query Builder 3 WinForms Edition v.3.7.16.1191
- Drop position on creating a link has been fixed. - MySQL: The Query Properties form initialization if there is no SQLCalcFoundRows property is fixed. - MySQL: The bug with PRECEDING keyword parsing is fixed.
Active Query Builder 3 WinForms Edition v.3.7.15.1190
= The length of automatically generated aliases for single-word names is limited to 3 characters. = The ObjectNamesNormalization property set to False doesn't lead to the full qualification of names added by code and visually. - MySQL: "POSITION" is added to the list of valid identifiers. - DevExpress: The bug with clicking on checkboxes next to datasource fields on the Design Pane has been fixed. - The location of buttons to show/hide unused fields on the Design Pane has been fixed.
Active Query Builder 3 WinForms Edition v.3.7.14.1189
= The length of autogenerated aliases is limited by 5 characters. = Design Pane: Visibility of PK and FK fields on hiding fields has been fixed. - SQL Text Editor: The crash on showing the suggestion list after user input has been fixed.
Active Query Builder 3 WinForms Edition v.3.7.13.1188
- Usage of alternate names in column prefixes has been fixed. = The default value of BehaviorOptions.GenerateShortObjectAliases is set to false. - SQL Text Editor: An exception on showing the suggestion popup has been fixed.
Active Query Builder 3 WinForms Edition v.3.7.12.1187
= SAP HANA: Support for the CONVERT_UNIT built-in function is added. = MS Access: Parsing of optional identifier before subquery in the FROM clause has been fixed. - Generation of short aliases for names with more than 3 fragments has been fixed. - SQL generation for objects added to the query by alternate name has been fixed. - Design Pane: Primary and foreign key fields aren't hidden by the "Hide unused fields" command even if they aren't used in the query. - Design Pane: Link attachment points are updated after showing or hiding unused fields.
Active Query Builder 3 WinForms Edition v.3.7.11.1186
- MySQL: Support for UTC_* functions has been added. - SQL Text Editor: Showing and hiding of suggestion popup has been fixed. - The bug on clicking on an empty condition cell has been fixed. - Other minor bugs are fixed.
Active Query Builder 3 WinForms Edition v.3.7.10.1185
= MySQL: Parsing of the RECURSIVE keyword in WITH clause has been fixed. = SQL generation with UseAltNames option turned on has been fixed. - WinForms: Combobox property editor has been fixed. - The unhandled exception if there is a bad foreign key in metadata has been eliminated. - SQL generation for data export in the Full-featured MDI demo has been 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!