Active Query Builder WinForms Edition v.1.4.9.76 BETA
= Memory and speed optimizations are made.
Active Query Builder WinForms Edition 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 Edition v.1.4.9.74 Beta
+ The Non-visual mode is added. + The new properties were added for the QueryBuilder.MetadataTreeOptions object: The DefaultExpandLevel property determines the level of initial metadata tree expansion. The default value (-1) directs to expand the tree completely. The SortingType property defines the criteria of metadata objects sorting.
See the full story for details
Active Query Builder WinForms Edition v.1.4.9.73 Beta
+ Ability to define alternate names for database objects and their fields is implemented.
See the full story for details
Active Query Builder WinForms Edition v.1.3.8.71
+ Polish translation is added. + The new TryToSelectLinksViaDriver property is added to MySQLSyntaxProvider. It's useful for suppressing exceptions if you use a metadata provider that unable to fetch metadata relations, like the UniversalMetadataProvider. You should set this property to False to suppress the exceptions. = Now Expression column cells of the Criteria List Control are more convenient for the keyboard editing. - Fixed metadata object loading query in DB2 syntax. - A couple of odd aggregate function definitions in Oracle syntax were removed. - Missing implementation of GetDatabaseList function in MySQLMetadataProvider is added.
Active Query Builder WinForms Edition v.1.3.8.69
+ Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made. - Minor bug in MySQLSyntaxProvider is fixed (affected the Visual sample project).
Active Query Builder WinForms Edition v.1.3.8.68
- Missing DISTINCT option in the MS SQL query properties form is added. - Missing Oracle query properties form is added.
Active Query Builder WinForms Edition v.1.3.8.67
+ The OracleSynaxProvider now has support of Oracle specific types. = It's now possible to modify query at the PlainTextSQLBuilder.SQLUpdated event handler. Please be careful not to fall into a recursion, because the event will be fired again after your changes. To avoid recursion, please use some flag or check changes that were made before.
Active Query Builder WinForms Edition v.1.3.7.66
+ The new UniversalMetadataProvider is added. This metadata provider may operate with any valid Connection object, no matter what ADO.NET data provider you use. Please note that this metadata provider is unable to retrieve metadata objects from the connection, because implementation of DbConnection.GetSchema() significantly differs for every ADO.NET data provider. Thus you need to use it together with specific syntax providers that are able to retrieve metadata objects via SQL queries. At the moment, UniversalMetadataProvider is operable with DB2, Firebird, Informix, MSSQL, Oracle and PostgreSQL syntax providers only. = DB2 syntax provider is improved for compatibility with AS/400 machines. + It's now possible to operate criteria list control rows with the keyboard: Alt-Up (move up), Alt-Down (move down), Alt-Delete (remove), Alt-Insert (insert empty row). = Row headers column is added to the criteria list control. - Orphaned union navbar buttons are eliminated. - Criteria list control rows do not properly updated their status when moved up or down. Fixed now.
Active Query Builder WinForms Edition v.1.3.6.65
+ The new Syntax provider for SQLite is implemented. + Two new Syntax providers are added for ANSI SQL/89 and SQL/2003 standards. + The new query properties dialog for Oracle is added. + The new QueryStatistics.QueryStructureXML property is added to retrieve the structure of SQL query in XML format. See the Non-visual sample project for examples. - QueryStatistics.OutputColumns: StatisticsOutputColumn.ColumnName property works correctly now.
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!