Active Query Builder History v.1.5.7.99
- DB2 syntax: bug in date manipulation expressions is fixed.
Active Query Builder History v.1.5.7.98
- Bug in metadata filters is fixed.
Active Query Builder History v.1.5.7.97
+ Sleep mode is implemented. This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing. + New properties are added to parenthesize conditions in WHERE clause. + DB2, MS SQL, SQL2003 syntaxes: Added support for field aliases for derived tables. - MSSQL syntax: WITH clause is fixed.
See the full story for details
Active Query Builder History v.1.9.0.10
+ Sleep mode is implemented. This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing. + New properties are added to parenthesize conditions in WHERE clause.
See the full story for details
Active Query Builder History v.1.5.6.96
- DB2 syntax: Bug with correlation clauses is fixed.
Active Query Builder History v.1.9.0.9
+ Sleep mode is implemented. This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing. + New properties are added to parenthesize conditions in WHERE clause. + DB2, MS SQL, SQL2003 dialects: Added support for field aliases for derived tables. + MySQL: Date/time and Extract functions are supported now.
See the full story for details
Active Query Builder History v.1.9.0.9
+ DB2, MS SQL, SQL2003 dialects: Added support for field aliases for derived tables. + MySQL: Date/time and Extract functions are supported now.
Active Query Builder History v.1.5.5.94
- MySQL syntax: Missing implementations of "YEAR", "MONTH", "DAY", "HOUR", "MINUTE", "SECOND" and "MICROSECOND" functions are added.
Active Query Builder History v.1.9.0.8
- Firebird: Fixed bug with incorrect prefix for stored procedure names. + TMS Unicode controls are supported now. + The new TacQueryBuilder.OnActiveSubQueryChanged is added.
Active Query Builder History v.1.9.0.8
- Firebird: Fixed bug with incorrect prefix for stored procedure names.
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!