Active Query Builder 3 WinForms Edition v.3.13.0.2262
+ MS SQL Server, Oracle: Support for CROSS APPLY, OUTER APPLY joins is added. + Oracle, MySQL, PostgreSQL, Snowflake DB: Support for NATURAL joins is added. + The new QueryRoot.LoadConditionsToSeparateRows property id added to load conditions from WHERE and HAVING into separate rows. - Minor bug fixes are made.
Active Query Builder 3 WinForms Edition v.3.12.4.2261
= Minor parsing improvements are made. - The crash with bad ISupportDpi casts on .NET 4.6.x framework is fixed.
Active Query Builder 3 WinForms Edition v.3.12.3.2260
= Sybase and SnowFlake DB: Parser ambiguities are eliminated. - Separate controls form loading in designer is fixed.
Active Query Builder 3 WinForms Edition v.3.12.2.2258
= MSSQL Syntax Provider: New properties to control generation of prefixes for fields are published. Change carefully as this may lead to incorrect field qualification for objects from linked servers: UseObjectNamesAsDefaultAliases, UseObjectNamesAsDefaultAliasesForObjectsFromOtherServer. - The suggestion list position and size are fixed for inplace editor in Criteria column. - Snowflake DB: The parser ambiguity for objectColumn is eliminated.
Active Query Builder 3 WinForms Edition v.3.12.1.2257
+ Oracle: Support for Lateral, Pivot, Unpivot is added. + Snowflake: Support for Lateral, Flatten and Position clauses is added. = MS SQL Server: Support for aliases after join hints like "(NOLOCK) Alias" is added.
Active Query Builder 3 WinForms Edition v.3.12.0.2256
+ DevExpress UI: Reference to DevExpress assembiles is updated to v24.1.6. = Target framework for ActiveQueryBuilder.View.WinForms.DevExpress assembly is bumped to net6-windows. = Demo projects are migrated to net6-windows. = Obsolete API usages after migration to net6-windows are eliminated.
Active Query Builder 3 WinForms Edition v.3.11.6.2255
+ PostgreSQL: Support for [NOT] MATERIALIZED CTE hints is added.
Active Query Builder 3 WinForms Edition v.3.11.5.2254
= PostgreSQL: LATERAL and ONLY are added to the list of keywords.
Active Query Builder 3 WinForms Edition v.3.11.4.2253
= PostgreSQL: Keywords parsing as identifiers in aliases and field names is improved.
Active Query Builder 3 WinForms Edition v.3.11.3.2252
- MS SQL Server: Inappropriate functions are removed from suggestion list. - The crash on completing a suggestion with the Tab key at the end of the text is eliminated.
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!