Active Query Builder History v.3.6.12.412
= Reference to the AQB Core assembly has been updated.
Active Query Builder History 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. - SQL parsing error notification panel in the Expression Editor has been corrected in large-scaling modes. - DevExpress UI: The back color of the edited cell in the Query Columns Grid and the SQL Text Editor inside the Expression Editor is applied correctly now. - DevExpress UI: The drop-down button glyph in the Single-line SQL Text Editor has been fixed. - SQL Text Editor now uses the form's back color by default.
Active Query Builder History 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 History v.3.6.12.1169
- Snowflake SQL: Parsing of VARCHAR without char count has been fixed.
Active Query Builder History 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. - Tooltips for fields in datasources on the Design Pane are displayed correctly now. - SAP Hana: Minor SQL generation fixes are made. - MySQL: Minor fixes for queries with the "~" character.
Active Query Builder History 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 History v.3.6.11.1168
= 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 History v.3.6.11.411
+ 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. - Minor fixes have been made. = Reference to the AQB Core assembly has been updated.
Active Query Builder History v.2.10.21.832
- SAP Hana: Minor SQL generation fixes are made. - MySQL: Minor fixes for queries with the "~" character.
Active Query Builder History 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. - Add Object Dialog: The bug in applying the behavior determined by the StartWithDefaultNamespaceType property has been fixed. - Add Object Dialog: The bug on double-clicking the list folders is 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!