Active Query Builder  »  News  »  Active Query Builder News

June 11, 2010

The new SQL Text Editor and Expression Editor for .NET is available now.

We are glad to announce the new component for Windows.Forms .NET 2.0 Framework intended for fast and convenient SQL text editing. The component requires Active Query Builder .NET Edition to perform SQL parsing and to get access to metadata information and SQL dialect settings of a database.

Key features:

  • Easy access to the list of database server keywords, operators and functions
  • Easy access to the database schema information
  • Code completion and context-sensitive suggestion lists
  • SQL syntax highlighting

The component can be used as a standalone SQL Text Editor (Active Query Builder can be visible or hidden, but it's needed anyway) or as an Expression Editor for Active Query Builder that accessible through the ellipsis button of Expression and Criteria column cells.

To use the component as a standalone SQL Text Editor, you should drag the SQLTextEditor component from the toolbox to a form and set the SQLTextEditor.QueryBuilder property to an instance of the QueryBuilder component. To use the component as an Expression Editor, you should drag the ExpressionEditor component from the toolbox to a form and set the QueryBuilder.ExpressionBuilder property to an instance of ExpressionEditor. You may find the sample project that illustrates working with the component included in the Trial version.

Please note that SQL Text Editor is available as a part of .NET Professional Subscription only.

at ActiveDBSoft.
» All Active Query Builder 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