Reply to thread

Message: [QUOTE="Sergey Smagin, post: 101325, member: 11769"] Active Database Software announces the new version of Active Query Builder .NET Edition, the leading solution for SQL query building, parsing, analysis and modification. [B][URL="http://www.activequerybuilder.com/"]Active Query Builder .NET Edition[/URL][/B] 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: [LIST] [*]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 [/LIST] The new version 1.9 introduces numerous usability, SQL syntax and API improvements, such as: [LIST] [*]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... [/LIST] [URL="http://www.activequerybuilder.com/news.html?story=51&sec=1"]Full list of changes[/URL] [/QUOTE]

Verification