定義不同的連接類型和服務(wù)器的特定選項(xiàng)

將對(duì)象添加到查詢，自動(dòng)聯(lián)接創(chuàng)建

簡(jiǎn)單排序，分組和標(biāo)準(zhǔn)定義

與工會(huì)，子查詢和派生表的工作

輕松創(chuàng)建復(fù)雜的SQL查詢

Active SQL Query Builder的用戶界面與MS-Access極其相似，但相較于其他的同類組件來(lái)說(shuō)，Active SQL Query Builder功能更為強(qiáng)大。它允許用戶簡(jiǎn)單直接的定義數(shù)據(jù)分組，排序以及構(gòu)建其他條件。用戶可以如同創(chuàng)建單一查詢一樣在其獨(dú)立工作區(qū)內(nèi)創(chuàng)建聯(lián)合體以及子查詢，甚至還可以通過(guò)對(duì)查詢結(jié)構(gòu)樹(shù)單次訪問(wèn)即可進(jìn)入聯(lián)合體以及子查詢。此外，用戶還能將其一些諸如DISTICT, TOP, pMIT等的高級(jí)查詢屬性可視化。

設(shè)計(jì)用戶友好型查詢環(huán)境

Active Query Builder能將用戶友好型的查詢字段替換為數(shù)據(jù)庫(kù)中表和字段中的規(guī)范化命名的字段。然后，您的終端客戶能可以手動(dòng)的創(chuàng)建SQL腳本：但在其查詢文本中使用的查詢字將被自動(dòng)的替換為生成的查詢中真正的字段名。

格式化SQL查詢文本布局

使用Active Query Builder's SQL Formatter，用戶可以用自己喜歡的方式自定義SQL代碼的布局。可以通過(guò)很多屬性的設(shè)置自定義查詢結(jié)果的輸出，比如pne breaks, indents 以及 word wrapping等。

我們也考慮到了將用戶查詢條件盡可能以其輸入的SQL查詢文本原貌保存。充分的認(rèn)識(shí)到各種原始輸入條件對(duì)查詢結(jié)果影響的重要性，我們盡可能的保證了對(duì)查詢條件進(jìn)行解析后，不出現(xiàn)任何條件與可選項(xiàng)的丟失。

強(qiáng)大的SQL查詢解析與分析功能

用戶可以通過(guò)Active Query Builder對(duì)其SQL查詢進(jìn)行完全的控制—您可以使用內(nèi)部查詢創(chuàng)建器對(duì)象輕松的解析與引導(dǎo)SQL查詢，還可以可編程的修改SQL查詢。

通過(guò)Active Query Builder中的相關(guān)參數(shù)，用戶可以知道其名稱以及數(shù)據(jù)類型，甚至與其相關(guān)的數(shù)據(jù)庫(kù)對(duì)象以及字段。

限制數(shù)據(jù)庫(kù)連接對(duì)象，避免查詢沖突

用戶有時(shí)可能想拒絕用戶對(duì)數(shù)據(jù)庫(kù)中某些字段或者表的訪問(wèn)，以保障其安全性或者繞開(kāi)對(duì)于其的數(shù)據(jù)庫(kù)結(jié)果來(lái)說(shuō)無(wú)關(guān)緊要的部分。Active Query Builder能幫助用戶輕松的實(shí)現(xiàn)這一切。當(dāng)用戶在一個(gè)可視化界面中創(chuàng)建一個(gè)查詢時(shí)，可以隱藏住某些不希望被訪問(wèn)的數(shù)據(jù)庫(kù)對(duì)象或者字段。

通過(guò)檢索查詢中的某些信息，比如使用過(guò)的某些表或者字段名，用戶可以制止某些未授權(quán)的查詢。

完全支持Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQpte 和 ANSI SQL/92, 89 ，2003 SQL語(yǔ)法

我們聲稱完全支持這些SQL語(yǔ)言，這意味著能解析幾乎任何給定數(shù)據(jù)庫(kù)服務(wù)器中的SQL查詢語(yǔ)句，并且在查詢修正過(guò)程中保存每一查詢細(xì)節(jié)以避免語(yǔ)義損失。Active SQL Parser由升級(jí)版的CoCo/R Compiler Generator而來(lái)，其完全支持Unicode字符集，故而能正確處理多重嵌套連接以及一些其他SQL語(yǔ)言中的細(xì)節(jié)部分。

使用Active Query Builder時(shí)，其能為用戶自動(dòng)的確定目前使用的數(shù)據(jù)庫(kù)服務(wù)器，以避免不能提前確定（數(shù)據(jù)庫(kù)服務(wù)器）的情況。

脫機(jī)模式下工作時(shí)以XML文件格式保存元數(shù)據(jù)

在很多情況下，在當(dāng)前安全角度或者對(duì)性能來(lái)說(shuō)，對(duì)數(shù)據(jù)的直接訪問(wèn)是不受歡迎或者不可能的，比如在ASP.NET環(huán)境中。當(dāng)面對(duì)這種情況時(shí)，最方便的解決方法是在脫機(jī)模式下使用Active Query Builder，從之前保存的XML文件中加載元數(shù)據(jù)信息。這種方式幾乎能瞬間加載元數(shù)據(jù)，而無(wú)需考慮數(shù)據(jù)量的多少。

本地化組件

現(xiàn)在，用戶可以在Active Query Builder運(yùn)行時(shí)本地化其組件，以及在不同語(yǔ)言間進(jìn)行切換。

Active Query Builder是一個(gè)特別的組件

Active Query Builder并非被設(shè)計(jì)用于某些內(nèi)部需求，其是用于滿足客戶需要的。該組件的開(kāi)發(fā)團(tuán)隊(duì)的成員們是一群狂熱的程序員，以之展現(xiàn)了其對(duì)可視化查詢創(chuàng)建的理解。我們將認(rèn)真考慮您的所有建議與意見(jiàn)，因?yàn)槲覀兊哪繕?biāo)是盡可能使Active Query Builder成為業(yè)內(nèi)最優(yōu)秀的工具軟件。

Active Query Builder是一個(gè)完全的可視化SQL查詢創(chuàng)建解決方案！

Building complex SQL queries visually with ease.

The interface of Active SQL Query Builder is similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, construct criteria in a simple and direct way. Each union and sub-query has its own working area where it could be built visually as easy as single query; you can get access to each union and subquery in one-touch with the query structure tree. The advanced query properties, such as DISTICT, TOP, pMIT, etc., might be set visually as well.

Designing user-friendly query building environment

Active Query Builder allows you to substitute unintelligible names of database objects and fields for user-friendly aliases ("alternate names"). Among changing names of real objects, you may define your own virtual objects (views) and fields. Acting as derived tables ("virtual objects") and sub-queries or expressions ("virtual fields"), they look like an ordinary objects and fields to the end-users. All aliased object names that were used in the query will be substituted back for real names, sub-queries and expressions automatically in the resultant SQL query text.

While building SQL queries with aliased object names visually, the end-users can still edit them by hand. Acitve Query Builder generates two versions of a query: for the end-user and for database server, and it's able to parse both.

Having database without foreign keys, you may add them to the component's metadata repository so tables will be joined automatically when added to a query.

Formatting SQL query text layout.

Using the Active Query Builder's SQL Formatter you can customize SQL code layout the way you pke it. There are a lot of properties that can be used to customize SQL query output, such as pne breaks, indents and word wrapping.

We care about keeping user queries in the same form as they were entered in the SQL query text. None of conditions and options will be lost after parsing of the query because we understand how important they could be in result.

Powerful means of SQL query parsing and analysis.

Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects and modify SQL queries programmatically.

Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.

Restricting access to database objects, preventing query execution

You might want to deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. Using the Active Query Builder, you can do it easily. Building a query via a visual interface, you can hide undesirable objects and fields of your database.

Abipty to retrieve various information about the query, such as pst of used tables and fields, allows you to prevent execution of unauthorized queries.

Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQpte and ANSI SQL/92, 89 and 2003 dialects SQL syntax.

By claiming full support of these SQL dialects, we mean the possibipty of parsing of almost any vapd SQL query for the given database server and keeping of every single query clause during the query modification process without any losses. Generated from the improved CoCo/R Compiler Generator, Active SQL Parser with full Unicode support correctly handles multiple nested joins and other fine points found in some SQL dialects.

Using Active Query Builder you can determine the currently used database server automatically, in case it cannot be defined in advance.

Working in offpne mode, storing metadata in XML files.

In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offpne mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.

Locapzation.

Now it is possible to locapze Active Query Builder completely and to switch between available languages in run-time.

Active Query Builder is a special component.

It wasn't created for some internal needs, it was made to meet customer needs. This component was made by a team of enthusiast programmers to express their vision of the visual query building. All your comments and suggestions will be taken into consideration because we really want to make it the best tool possible.

Active Query Builder is complete solution for visual SQL query building!