Active Query Builder is a query builder component suite for Borland Delphi and C++Builder which gives your end-users the ability to create complex SQL queries containing unions and sub-queries via an intuitive visual interface. It has complete support of Oracle, Microsoft SQL Server, MySQL, PostgreSQL, InterBase, Informix and more SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.
特征综述 About Feature
声明:本产品中文介绍为慧都控件网版权所有,未经慧都公司书面许可,严禁拷贝、转载!
- Implemented retrieval of extended information about parameters
- Now you can get table and field names to what this parameter will be applied. Also you can get the data type expected for this parameter. All these properties are available via the Parameters collection
- Most of demo projects now have example of working with extended information about parameters
- Made the new QueryStatistics.OutputColumns property to get access to output columns of the query.* It allows you to retrieve maximum information about output columns:
- SQL Experssion and alias of expression
- Object name, Object alias and Field name (only if the column is based on single field)
- Better handling of the asterisk item in SELECT list: now the asterisk item (*) is added to a query by default and removed automatically when any other item is added to SELECT list
- Multiple fixes and improvements for MS Access: Ability to retrieve linked tables is added, several fixes for MS Access sytnax are made, a form to manage MS Access query parameters is added (TOP, DISTINCT, etc.)
- ActiveX Editon
- The new ConnectionTimeout property is added to IActiveQueryBuilder interface
- Added support of IProvideClassInfo2 interface to work properly with Internet Explorer 7
- VCL Editon
- The new AnsiQuotes property is added to MySQL Syntax provider in order to operate correctly with MySQL Server when the "ANSI_QUOTES" option is set or not
更新时间:2008-4-23 | 录入时间:2006-12-19 | 编辑:huhm | 审核:xiaoy