Active Query Builder
以下是 "产品介绍"，如果您需要了解更多信息，您可以联系我们。
Active Query Builder是一个可视化SQL查询编辑组件，允许你的最终用户再直观的界面中创建复杂的SQL查询。Active Query Builder还有优秀的SQL解析功能，能够分析和修改SQL查询并完全控制用户的查询。Active Query Builder for .NET版包括一个SQL文档编辑器，支持代码自动完成和语法高亮。
当前有6个版本可提供
- Active Query Builder WinForms .NET Edition ：Windows Forms .NET 2.0+ 组件
- Active Query Builder ASP.NET Edition ： ASP.NET 2.0+ 组件
- Active Query Builder Java Edition ：基于 Swing的Java bean 组件
- Active Query Builder ActiveX Edition ：.NET-ready COM/ActiveX 控件
- Active Query Builder VCL Edition ：Delphi 和 C++ Builder 组件
- Active Query Builder .NET WPF: .NET WPF2.0+ 组件
简单的和清晰的可视化SQL查询建立界面
Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with SQL queries. The interface of Active Query Builder is similar to MS Access and SQL Server’s visual query building interface. Therefore, it is already familiar to most database users.
可自定义的查询建立环境
Active Query Builder provides unique opportunities to customize the presentation of database schema for the end-user. You can tune everything: add descriptions and change database object names, remove unwanted objects and add virtual objects and fields, group objects by subject area, etc. Having changed all of this, you will receive correct SQL queries to your database without any effort as a result.
轻松的元数据管理
Active Query Builder can load metadata automatically from direct DB connections as well as programmatically from various custom datasources, such as web services and .NET datasets. Filtration by database, schema and object name, manual removing of unwanted objects is possible. Once loaded, metadata can be saved to XML to build queries disconnected from the database in multi-tier or web environment.
强大的可编程API
Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries as well as analyze and modify them programmatically via the internal query builder objects. The detailed information about used database objects and fields is available for every part of the query. By using this information you can deny the execution of unwanted objects or add the necessary conditions to the query in order to prevent unauthorized access to the data.
完全支持 Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, DB2, Informix, Sybase, SQLite, Teradata dialects 和标准的ANSI SQL/92, 89 以及2003 SQL 语法.
By claiming the full support of these SQL dialects, we mean the possibility of the parsing of almost any valid SQL query for the given database server and keeping of every single query clause during the query modification process without any losses. Active Query Builder SQL Parser correctly handles multiple nested joins and other fine points of various SQL dialects.
只要几行代码就能与你的应用程序集成
The component can be integrated into your application with just a few lines of code. The Knowledge Book, documentation and numerous demo projects included in the installation package allows for mastering the component for just a few days.