Below is the list of fixes and improvements in Active Query Builder VCL Edition v.188.8.131.52.
+ The new Universal Syntax Provider is added to the Free version. It is based on the ANSI SQL/92 syntax but allows to determine most of popular database servers, successfully retrieve metadata and apply specific settings for them to let the user build simple queries for these servers. Please note that this does not mean that the Universal Syntax Provider could be a suitable replacement for specific database syntax providers, as it strictly follows the rules of ANSI standard, that may lead to many incompatibilities while working with specific database servers. Working with the Standard version, use the Auto Syntax Provider in case of necessity to detect database server automatically. * ANSI SQL/92 Syntax Provider has been removed from the Free version. * Most of the demo projects are modified to work with Universal Syntax Provider by default. + PostgreSQL query properties form is added. - PostgreSQL syntax: Fixed problem with double VARCHAR generation for built-in types. - PostgreSQL syntax: Added support for "/* ... */" comments that were erroneously parsed as user-defined operators "/*" and "/*". - DB2 Syntax now treats "@" and "#" as valid identifier characters.
[ 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!