Below is the list of fixes and improvements in Active Query Builder VCL Edition v.184.108.40.206.
+ Tne new demo project is added to illustrate ability to modify queries programmatically (Demos\QueryModificationDemo). * Chinese, Italian, German and Portuguese (Brazil) localizations files are updated. Spanish, Czech, Turkish and Japanese localization require updating. Please let us know if you can update one of them. + Two new events are added to update object metadata information if necessary: OnObjectMetadataLoading(TacMetadataContainer, TacMetadataObject); OnObjectMetadataLoaded(TacMetadataContainer, TacMetadataObject); + The new QueryToLoadFields property is added to the TacMetadataObject interface. Read this property to get SQL statement that should be executed to read result columns from dataset and fill the fields definition list for this database object. + Now the Universal Syntax Provider is able to retrieve metadata from SQLite and Informix database servers. + TacUniversalSyntaxProvider: The new AutodetectConnectedServer(ASQLContext) method is added to re-detect connected server manually + Localizer: Ability to load localized strings through the event is implemented + MS SQL Syntax: Added support for the "OPENQUERY" clause. - MySQL: Small fix is made in the loading relations procedure. - Oracle: Small fix is made in loading objects procedure. - Add Object Window: Fixed bug that does not allowed to add views and procedures to the query.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder VCL Edition at the download page.
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!