Active Query Builder History v.1.0.7.1007
+ New source code sample is added to demonstrate creation of Java applet to use in the web browser (AppletDemo). - Bug with loading tables from MySQL 4.1 is fixed.
Active Query Builder History v.1.9.3.174
+ Now the user can edit Join expression manually via the Link Properties dialog. + DB2: support of CONCAT operator is added. + PostgreSQL: Support of INTO clause is added. + PostgreSQL, DB2, SQL2003: support of NULLS FIRST and NULLS LAST is added. - PostgreSQL: bug in parsing of 'interval' type is fixed. - Query builder was not loading the scale of table columns. Fixed now.
Active Query Builder History v.1.0.6.1006
+ Now the user can edit Join expression manually via the Link Properties dialog. + DB2: support of CONCAT operator is added. + PostgreSQL: Support of INTO clause is added. + PostgreSQL, DB2, SQL2003: support of NULLS FIRST and NULLS LAST is added. - PostgreSQL: bug in parsing of 'interval' type is fixed. - Query builder was not loading the scale of table columns. Fixed now. - Fixed bug with duplicated items in datasource field list.
Active Query Builder History v.1.11.20.0
+ Now the user can edit Join expression maually via the Link Properties dialog. + DB2, PostgreSQL and ANSI SQL/92: "NULLS FIRST/LAST" support is added. + PostgreSQL: Support of INTO clause is added. + The internal visual controls destroying method is changed. Now all differences between SQL and SyncSQL properties are eliminated. + MS SQL: loading synonyms info for MS SQL 2005 is made. = The component produce an empty query string on empty query builder now. + The new menu item is added to the Union Sub-Query context menu to copy the current union sub query to a new one. + DB2: CONCAT operator is supported now. + Metadata XML schema is updated. = MS SQL Server: The '=true' and '=false' values are treated now as special comparisons for logical expressions only. + Now it is possible to change join type via context popup menu. = Right quotation of conditions in the grid is made. - MySQL: Missing "QUARTER" and "WEEK" functions are added. - MS Access: Quoted parameters parsing is fixed. - InterBase/Firebird: Empty brackets are suppressed now for stored procedures in the FROM clause. + Field descriptions are loaded into metadata container from OLE DB Provider. - Fixed bug with assertion failure when link condition contains sub query. + The User's Guide is updated. + More optimal grid filling is made when loading criteria and select list items. = The "Move forward" and "Move backward" Union Sub-Query context menu items are renamed to the "Move left" and "Move right" for better understanding.
Active Query Builder History v.1.11.20.0
+ Now the user can edit Join expression maually via the Link Properties dialog. + DB2, PostgreSQL and ANSI SQL/92: "NULLS FIRST/LAST" support is added. + PostgreSQL: Support of INTO clause is added. + The internal visual controls destroying method is changed. Now all differences between SQL and SyncSQL properties are eliminated. + MS SQL: loading synonyms info for MS SQL 2005 is made. = The component produce an empty query string on empty query builder now. + The new menu item is added to the Union Sub-Query context menu to copy the current union sub query to a new one. + DB2: CONCAT operator is supported now. + Metadata XML schema is updated. = MS SQL Server: The '=true' and '=false' values are treated now as special comparisons for logical expressions only. + Now it is possible to change join type via context popup menu. = Right quotation of conditions in the grid is made. - MySQL: Missing "QUARTER" and "WEEK" functions are added. - MS Access: Quoted parameters parsing is fixed. - InterBase/Firebird: Empty brackets are suppressed now for stored procedures in the FROM clause. + Field descriptions are loaded into metadata container from OLE DB Provider. - Fixed bug with assertion failure when link condition contains sub query. + The User's Guide is updated. + More optimal grid filling is made when loading criteria and select list items. = The "Move forward" and "Move backward" Union Sub-Query context menu items are renamed to the "Move left" and "Move right" for better understanding. + The "Safe for scripting" and "Safe for initialization" flags are set now. + The new properties are added to the IMetadataObject and IMetadataField interfaces: ShortDescription and LongDescription. + The new properties are added to get information about objects in the metadata container from the Query Statistics: IStatsFromObject.MetadataObject, IStatsUsedColumn.MetadataObject, IStatsUsedColumn.MetadataField, IStatsOutputColumn.MetadataObject, IStatsOutputColumn.MetadataField.
Active Query Builder History v.1.0.5.1005
+ The new source code sample is added to demonstrate usage of various QueryBuilder events (EventsDemo). + The new source code sample is added to demonstrate alternate methods of metadata loading (FillMetadataDemo). + The new source code sample is added to demonstrate ability to analyze SQL queries and modify them programmatically (QueryModificationDemo). - Various bugixes are made.
Active Query Builder History v.1.9.2.173
+ MS SQL Server: loading synonyms info for SQL Server 2005 is made.
Active Query Builder History v.1.9.1.172
- The SQLiteSyntaxProvider does not try to load metadata relations anymore. = The UniversalMetadataProvider does not throw needless exceptions anymore. - Invalid namespace in generated XML files is fixed.
Active Query Builder History v.1.9.0.171
+ Now it is possible to change join type via context popup menu. = MS Access: query parameters parsing is improved. - Localizer.LoadLanguageFromFile() was opening language files with read/write access that caused problems in Windows Vista when the customer application installed in "C:\Program Files". - Procedure properties dialog was placed in the top left corner of the desktop. Resizing behavior is fixed also. - Incorrect string quotation in some criteria is fixed. - Query builder has been added empty brackets to a parameterless stored procedure dropped on the diagram pane. Fixed now. - MySQL: Missing "QUARTER" and "WEEK" functions are added. - Parsing of 'True' and 'False' in conditions is fixed.
Active Query Builder History v.1.0.2.1003
+ New source code sample is added to demonstrate using of alternate names for database objects and their fields (AlternateNames). - Minor bugfixes and optimizations are 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!