Active Query Builder 3 WPF Edition v.3.8.14.2212
= HiDPI fixes are made. = MS SQL Server: Support for the "AT TIME ZONE" clause is made. - Oracle: The NRE in the code for calculating the expression result type is fixed. - The positioning of a new datasource control on the Design Pane after adding it via the linked datasource field's button is fixed.
Active Query Builder 3 WPF Edition v.3.8.12.2210
+ Support for Visual Studio 2022 is added. = Column aliases that are valid identifiers aren't quoted now. + The new BehaviorOptions.AlwaysQuoteColumnAliases property is added. Default is false. = MySQL: Fields are fetched sorted by ORDINAL_POSITION. = MySQL: The ANSI_QUOTES flag is detected during the server version autodetection.
Active Query Builder 3 WPF Edition v.3.8.11.2209
= Layout: New datasources are repositioned properly now on the new query assignment. = SQL Text Editor: Shift+Down on the last line selects a row to the end. = Metadata Editor: More connection types are available in the Metadata Load Wizard out-of-the-box. = Design Pane: Datasource fields filter panel is collapsed now when user clicks the cross button twice. = The Show/hide button is added to the datasource fields filter panel. + Informix: Support for databases, double-quoted strings, curly-braced comments are added; the keywords list is updated. + SQLite: Date, Time, and DateTime conversion built-in functions are added. = Firebird: CTE in subqueries are supported now. - Oracle: The bug with applying limits for server versions without OFFSET/FETCH support is fixed. - Oracle: The bug with queries containing DbLink objects has been fixed. - SQL Text Editor: An exception on text editing in rare cases is eliminated. - Design Pane: The bug with populating of "Where" datasource fields context menu items is fixed. = The new QueryRoot.LoadLayoutSqlV2 helper extension method to load the LayoutSql saved in the second version of the component is added to the ActiveQueryBuilder.View.Compatibility assembly. = Full-Featured MDI Demos are updated.
Active Query Builder 3 WPF Edition v.3.8.10.2208
+ The new property is added to determine the case of built-in functions and variables: SQLGenerationOptions.BuiltinFormat. = Design Pane: In the field list context menu, the Sorting item is moved to the root of the menu, the HAVING item is shown if a query has grouping. = The SQLFormattingOptions.KeywordFormat property is moved to the SQLGenerationOptions class. = IBM DB2, Informix: Metadata providers are compiled in the AnyCPU mode. Make sure that you have the required version of the DB client installed. = Syntax provider settings forms: The 'Deny INTO clause' option is not shown anymore. - Minor UI fixes are made.
Active Query Builder 3 WPF Edition v.3.8.9.2207
= The field context menu in DataSource controls on the Design Pane has been improved when grouping is applied, and the field is used in the query several times. - The field sorting icon is fixed in DataSource controls on the Design Pane when the field is mentioned in the ORDER BY several times. - SQL Text Editor: Search and replace functionality has been fixed. - SQL Text Editor: Pressing the Ctrl+Backspace key combination removes the whole word at the left of the cursor. The Shift+Backspace now acts as the Backspace key.
Active Query Builder 3 WPF Edition v.3.8.8.2206
= GrapeCity reports module can be activated in the Full-Featured MDI Demo by turning on the EnableActiveReportsSupport property in the Samples\ Directory.Build.props file. - Full-Featured demo: The crush on assigning wrong SQL text to the current subquery text has been eliminated. - The bug with SQL text generation for objects and fields with empty alternate names when the UseAltNames property is true has been fixed.
Active Query Builder 3 WPF Edition v.3.8.7.2205
= The methods to serialize/deserialize query builder option groups are moved from the View to Core assembly. = The bug with SQL query generation with alternate names for servers supporting object names as a default alias has been fixed.
Active Query Builder 3 WPF Edition v.3.8.6.2204
= MS SQL Server: Support for TRY_CAST and TRY_CONVERT built-in functions has been added. = Objects in the search results are expandable now. = Query model optimization has been made. Datasources aren't reordered now if not needed. - Query Columns List: Grouping and aggregate icons in checkboxes are updated. - Expression Editor: The Query Context panel content is generated correctly now. - The NRE on the component disposal for some complex queries has been eliminated. - Query Columns List: The bug with displaying the 'Or' column before the 'Criteria' column has been fixed.
Active Query Builder 3 WPF Edition v.3.8.5.2202
- The bug with empty context lists in Expression Editor is fixed. - The unhandled exception on opening Expression Editor has been eliminated.
Active Query Builder 3 WPF Edition v.3.8.4.2200
= Minor corrections and code clean-up.
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!