Active Query Builder History 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 History 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 History v.1.8.0.11
- Minor fixes were made.
Active Query Builder History v.1.8.0.11
- Minor fixes were made.
Active Query Builder History 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 History v.1.8.0.10
+ Passing MetadataFilter object to the metadata loading wizard is implemented.
Active Query Builder History v.1.8.0.10
- Fixed the "DAX Error" access violation problem. + The HTML Demo with loading metadata from XML file is updated.
Active Query Builder History v.1.8.0.9
- Fixed bugs in DB2 syntax provider with the metadata fetching process. - Fixed AV on parsing some specific SQL queries. - Changing of the tree options (TacQueryBuilder.TreeOptions and TacQueryBuilder.TreeOptionsMetadata properties) led to reloading of all QueryBuilder options and revert all tables width to default. Fixed now.
Active Query Builder History v.1.8.0.9
- Fixed bugs in DB2 syntax provider with the metadata fetching process. - Fixed AV on parsing some specific SQL queries. - Changing of the tree options (IActiveQueryBuilderX.TreeOptions and IActiveQueryBuilderX.TreeOptionsMetadata) led to reloading of all QueryBuilder options and revert all tables width to default. Fixed now.
Active Query Builder History v.1.8.0.8
+ DB2 Syntax: Fixed problems with metadata retrieval for specific server versions. - Fixed AV when loading properties via the PropertiesXML property from wrong path.
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!