We're glad to announce the new minor version of Active Query Builder. You can download the newest version from the download page.
What's new in the Active Query Builder version 1.7.5?
We have 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.
We have 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.).
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. (ActiveX Editon works in default MySQL mode)
Please refer to MySQL Documentation for more information: https://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html
ActiveX Edition: The new ConnectionTimeout property is added to IActiveQueryBuilder interface.
ActiveX Edition: Added support of IProvideClassInfo2 interface to work properly with Internet Explorer 7.
* These features will be available in the Standard Edition of Active Query Builder only.
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!