Active Query Builder History v.1.15.3.0
- MS Access: Built-in function names are removed from the list of correct
identifiers.
- Assertion failure error when you use alias same as object name is fixed now.
(select * from Orders Orders)
- A better fields list in WITH clause support is made.
+ List of existing Common table expression is added to the "Add CTE" submenu.
+ SQLite: Support of string concatenation operator is made ("qwe" || "asd")
= Informix: Better server autodetection is made.
Active Query Builder History v.1.2.6.1027
+ The new context menu item "Add Common Table Expression" is added to the query building area. - Oracle: Server cursor leaks are eliminated. - MS Access: NULL is removed from list of valid identifiers. - Fixed wrong naming for query objects like "table.*" if more than one "table" used in the query. - MySQL: CONVERT function support is improved. - PostgreSQL: Metadata filter is fixed. - MetadataContainer.saveToXMLFile() did not close the file. Fixed now.
Active Query Builder History v.1.12.3.218
- The bug in WITH clause field list is fixed. - MySQL: CONVERT function support is improved. - PostgreSQL: metadata filter is fixed.
Active Query Builder History v.0.0.6
+ Client-side error logging is made. Logs are stored in the WEB_PROJECT_ROOT\ClientError.log.txt file. - Columns were added to a query by checking a field a second time only in IE8. Fixed now. - Fixed binding problems on building of sample projects.
Active Query Builder History v.1.12.3.217
+ The new context menu item "Add Common Table Expression" is added to the query building area. - MS Access: NULL is removed from list of valid identifiers. - Fixed wrong naming for query objects like "table.*" if more than one "table" used in the query. - Query builder was crashing when user moved the splitter during the query update. Fixed now.
Active Query Builder History v.0.0.5
= Third-party libraries are updated to the lastest version for better client-side part compatibility with different browsers. = Third-party ADO.NET provider assemblies are add to the installation package. - Various UI problems in Internet Explorer and Mozilla Firefox are fixed. - The problem with adding object to the query building area from the object-tree is fixed now. - Other minor bug fixes are made.
Active Query Builder History v.1.2.5.1025
+ French translation is added. + The new source code example "LoadMetadataAsync" is added to demonstrate asynchronous loading of metadata. + MSSQLCESyntaxProvider is implemented to support Microsoft SQL Server Compact Edition. - MS Access: The bug with unsupported FULL OUTER JOIN is fixed.
Active Query Builder History v.1.12.2.216
+ The new source code example "LoadMetadataAsync" is added to demonstrate asynchronous loading of metadata. - Hotfix: DataSourceControl was not painted last item.
Active Query Builder History v.0.0.4
= Metadata provider assemblies are added to the installation package. + New sample projects are added: Simple Offline Demo and Simple OLE DB Demo. + New flexible HTML layout is made. - The bug with reading metadata of objects without fields is fixed. - Minor GUI bugs are fixed.
Active Query Builder History v.1.15.0.0
+ Now it's possible to add Common Table Expressions visually using the context menu item of the query building area. + Wheel scrolling in field lists is made. + The new demo is added to demonstrate Virtual Objects And Fields feature. + The new demo is added to learn about Drag'n'Drop functionality. = ParenthesizeSingleCriterion property is applied now to join conditions. - Bug fixed: Wrong names fixup for select items like "table.*" if more than one "table" objects were used in the query. - Firebird: Parameter names can use the '#' symbols now. - The WorkOffline property wasn't taken into account when loading fields for stored procedures. Fixed now. - MS Access: Bug with unsupported FULL OUTER JOIN is fixed. - PostgreSQL: The list of unifying operators is fixed. - MS Access: "NULL" is excluded from the list of valid identifiers. = Internal parser objects caching is turned off as it's not necessary for modern Delphi versions. + AnyDAC 2 metadata provider is made.
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!