Active Query Builder History v.1.9.0.2
- Fixed packages for C++ Builder 5 and 6. - Fixed incorrect hiding of multiple database nodes when HideSingleDatabaseNode property is turned on.
Active Query Builder History v.1.9.0.2
+ The new boolean QueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode property is added to hide the database node from metadata objects tree when there is only one database is loaded to the metadata container. - Fixed incorrect hiding of multiple database nodes.
Active Query Builder History v.1.5.1.78
- Fixed wrong field names quotation in the drop-down list of "Expression" column. - The bug with relations in PostgreSQL syntax is fixed.
Active Query Builder History v.1.9.0.1
+ 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.
Active Query Builder History v.1.9.0.1
+ The new Universal Syntax Provider is added to the Free version (xsUniversal). 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 (xsAuto) 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.
Active Query Builder History v.1.5.0.77
+ The new QueryBuilder.MetadataTreeOptions.EnableEditing property is added to enable in-place editing of alternate names in the metadata objects tree. - Minor bug fixes are made.
Active Query Builder History v.1.8.5.11
+ The new LoadMetadata demo is added instead of the EventMP demo. + The new boolean TacQueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode property is added to hide the database node from metadata objects tree when there is only one database is loaded to the metadata container. + TacEventMetadataProvider: Two new events are added: OnGetSynonyms and OnGetSystemSynonyms. + Minor changes in the installer.
Active Query Builder History v.1.8.5.11
- The pregenerated LPK file and links to Microsoft site about licensing ActiveX controls are added to the HTMLDemo. + Minor changes in the installer.
Active Query Builder History v.1.4.9.76 BETA
= Memory and speed optimizations are made.
Active Query Builder History v.1.4.9.75 BETA
- Problem with ORDER BY and LIMIT in MySQL syntax is fixed. = Installation system is changed and improved.
Active Query Builder WinForms .NET Edition:
Active Query Builder WPF .NET Edition:
Active Query Builder ASP.NET Edition:
Active Query Builder Java Edition:
Active Query Builder ActiveX Edition:
Active Query Builder VCL Edition:
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!