Active Query Builder  »  News  »  Active Query Builder VCL and ActiveX Editions News

October 06, 2017

Active Query Builder VCL Edition 1.28 introduces new SQL formatting options.

We're glad to announce the new minor version of Active Query Builder VCL 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 VCL Edition version 1.28?

  • On adding a stored procedure (table-valued function), a prompt for its parameters does not appear anymore. Instead, you can open the datasource properties dialog (by selecting the Properties context menu item or by double-clicking on a datasource) and edit procedure parameters there.
  • Descriptions of database objects and fields are shown in hints in the Metadata Tree.
  • The new OnMetadataTreeNodeGetCaptionText and OnMetadataTreeNodeGetHintText events have been added to customize the text of captions and hints for nodes of the Metadata Tree.
  • The new group of properties has been made to customize formatting for IF and CASE clauses: TSQLBuilderSelectFormat.ConditionalOperatorsFormat.
  • The new TSQLBuilder.SubqueryTextFromNewLine property has been made to break line between the sub-query text and the parentheses enclosing it.
  • The new LinkOptions.DefaultLinkType property has been added. Using it you can prescribe to create left, right or full outer join instead of inner join on linking tables by drag'n'drop.
  • SQL Text Editor (Professional): The new TextEditorOptions.UseTabCharacter property has been added.
  • Several fixes for high-resolutions have been made.
  • Minor fixes for DevExpress dark themes have been made.
  • Lots of other minor bug fixes and improvements have been made.
at ActiveDBSoft.
» All Active Query Builder VCL and ActiveX Editions news

Comments by Disqus:




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