Downloads

Active Query Builder History History

September 11, 2023

Active Query Builder History v.3.9.13.2245

+ Snowflake: Support for the latest Snowflake features is made.
= PostgreSQL: The compatibility issue with Amazon Redshift is addressed.

September 11, 2023

Active Query Builder History v.3.9.13.2245

+ Snowflake: Support for the latest Snowflake features is made.
= PostgreSQL: The compatibility issue with Amazon Redshift is addressed.

September 11, 2023

Active Query Builder History v.3.9.13.2245

+ Snowflake: Support for the latest Snowflake features is made.
= PostgreSQL: The compatibility issue with Amazon Redshift is addressed.

August 17, 2023

Active Query Builder History v.1.33.2

+ Support for Snowflake SQL syntax is made. (xsSnowflake = 150)
+ Support for Firebird v.4 SQL is made. (xsFirebird4 = 83)
= MySQL: Support for IS TRUE and IS FALSE clauses is improved.
- PostgreSQL: The ambiguity on parsing TIMESTAMP type name is eliminated.
- SQL Server: Parsing of the ZONE keyword as an identifier is fixed.
- The crash if quotation symbol is not defined by the syntax is eliminated.

August 17, 2023

Active Query Builder History v.1.33.2

+ Support for Snowflake SQL syntax is made. The new TacSnowflakeSyntaxProvider
  is added.
+ Support for Firebird v.4 SQL is made. The new server version is added to 
  TacFirebirdSyntaxProvider.
= SQL Text Editor: The drawing of very longs string is optimized.
= MySQL: Support for IS TRUE and IS FALSE clauses is improved.
- PostgreSQL: The ambiguity on parsing TIMESTAMP type name is eliminated.
- SQL Server: Parsing of the ZONE keyword as an identifier is fixed.
- TacMetadataContainer.SetDefaultSchemaNamesStr: The crash if quotation symbol 
  is not defined by the syntax is eliminated.

July 14, 2023

Active Query Builder History v.1.33.1

! SQL Text Editor: ActiveColor, InactiveColor properties are added to 
  TacFoldingProperties. TacFoldingProperties.Color property is obsolete now.
! SQL Text Editor: The new SuggestionsContent property is added. 
  The SuggestionListContent property is obsolete now.
+ SQL Text Editor: The new event OnReloadSuggestionsList is added.
= TacSqlScript: Statements separator is added now on adding a new statement to
  the end of the script.
= PostgreSQL: Partitioned tables are fetched correctly now on schema load.
- PostgreSQL: Parsing of the AT TIME ZONE operator is fixed.
= MySQL: Support for Group_Concat function is added.
= MySQL: Support for IS TRUE and IS FALSE operators is added.
- Oracle: Ambiguities on parsing TIMESTAMP and DISTINCT clauses are eliminated.
- SAP Hana: The bug with STRING_AGG function with ORDER BY clause is fixed.
- MS SQL Server: Parsing of the AT identifier is fixed.
- Criteria Builder: The bug with incorrect parsing of float values if 
  DecimalSeparator differs from default is fixed.

July 14, 2023

Active Query Builder History v.1.33.1

= PostgreSQL: Partitioned tables are fetched correctly now on schema load.
- PostgreSQL: Parsing of the AT TIME ZONE operator is fixed.
= MySQL: Support for Group_Concat function is added.
= MySQL: Support for IS TRUE and IS FALSE operators is added.
- Oracle: Ambiguities on parsing TIMESTAMP and DISTINCT clauses are eliminated.
- SAP Hana: The bug with STRING_AGG function with ORDER BY clause is fixed.
- MS SQL Server: Parsing of the AT identifier is fixed.

June 01, 2023

Active Query Builder History v.3.9.12.479

= Reference to the ActiveQueryBuilder.Core assembly is updated to v.3.9.12.2244.
- JS error on right-click on the asterisk datasource field is fixed.
- The "check all" and "uncheck all" datasource context menu items are displayed
  now when right-click when context menu is already opened.

June 01, 2023

Active Query Builder History v.3.9.12.2244

= PostgreSQL: Partitioned tables are fetched now on schema load.
- Duplicate alias detection for case-sensitive SQL syntaxes is corrected.

June 01, 2023

Active Query Builder History v.3.9.12.2244

= PostgreSQL: Partitioned tables are fetched now on schema load.
- Duplicate alias detection for case-sensitive SQL syntaxes is corrected.

Product Summary

 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:

News

Tweets

Testimonials

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!


Social networks