Active Query Builder  »  News  »  Active Query Builder .NET Edition News

May 30, 2013

Active Query Builder 2 .NET Edition 2.3 is released.

We're glad to announce the new version of Active Query Builder 2 .NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.

What's new in the Active Query Builder .NET Edition version 2.3?

• The new QueryTransformer component is added. It is intended to easily programmatically modify sorting, add filtration, aggregation and limits to SQL queries.
  See the "QueryTransformerDemo" source code sample and the Knowledge Book article for details.
• SQL Text Editor: The new properties are added to improve usability of the code completion feature and to prioritize the content of suggestion lists:
  • The ShowSuggestionAfterCharCount property determines number of chars that should be typed before the suggestion list will popup;
  • The SuggestionListContent property allows to filter the content of suggestion list (keywords, SQL functions and metadata objects);
  • The KeepMetadataObjectsOnTopOfSuggestionList property being set to True instructs to act exactly what is written.
• SQL Text Editor: The WordWrap property is added.
• SQL Text Editor: Performance is improved.
• The new MetadataContainer.ConnectionIdle event is added. It allows for closing the database connection if it's not desirable to keep it open during the work session.
• The new events are added to BaseMetadataProvider: BeforeSqlExec and AfterSqlExec. They might be useful for tracing SQL queries sent to the database server.
• Oracle: Optimizer hints can be edited via the Query Properies dialog.
• Other minor fixes and improvements are made.

Author: Sergey Smagin at ActiveDBSoft.

» All Active Query Builder news

Comments by Disqus: