Active Query Builder .NET Edition 1.9 is released

Sergey Smagin

New member
Joined
Feb 8, 2007
Messages
3
Programming Experience
5-10
Active Database Software announces the new version of Active Query Builder .NET Edition, the leading solution for SQL query building, parsing, analysis and modification.

Active Query Builder .NET Edition allows your end-users to build complex SQL queries via an intuitive visual interface. It's a true two-way query builder, so you may combine visual query building with direct SQL query text editing.

The main features of Active Query Builder .NET Edition:
  • Easy visual building of complex SQL queries with unions and sub-queries.
  • MS-Access style user-friendly interface with drag & drop support.
  • Two-way SQL query building (combined with SQL text editing).
  • Defining user-friendly aliases for tables and field names.
  • Powerful means of SQL query analysis and programming modification.
  • Working in offline mode, storing metadata in XML files.
  • Restricting access to unwanted objects, preventing query execution.
  • Sophisticated SQL parser, support of most popular database servers.
  • SQL query text formatting.
  • Ability to localize the component

The new version 1.9 introduces numerous usability, SQL syntax and API improvements, such as:
  • Possibility to change join type via context popup menu.
  • Manual editing of Join expressions via the Link Properties dialog.
  • PostgreSQL syntax: Support of INTO clause.
  • DB2 syntax: Adding of the Query Properties dialog.
  • MS SQL Server: Support of ranking functions.
  • More optimal grid filling when loading criteria and select list items.
  • And many more...
Full list of changes
 
Top Bottom