Active Query Builder WinForms Edition History

February 21, 2008

Active Query Builder WinForms Edition v. BETA

= Memory and speed optimizations are made.

February 08, 2008

Active Query Builder WinForms Edition v. BETA

- Problem with ORDER BY and LIMIT in MySQL syntax is fixed.
= Installation system is changed and improved.

January 31, 2008

Active Query Builder WinForms Edition v. 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

January 30, 2008

Active Query Builder WinForms Edition v. Beta

+ Ability to define alternate names for database objects and their fields 
  is implemented.

See the full story for details

January 16, 2008

Active Query Builder WinForms Edition v.

+ 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.

December 12, 2007

Active Query Builder WinForms Edition v.

+ 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).

December 07, 2007

Active Query Builder WinForms Edition v.

- Missing DISTINCT option in the MS SQL query properties form is added.
- Missing Oracle query properties form is added.

December 06, 2007

Active Query Builder WinForms Edition v.

+ The OracleSynaxProvider now has support of Oracle specific types.
= It's now possible to modify query at the PlainTextSQLBuilder.SQLUpdated event
  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.

November 30, 2007

Active Query Builder WinForms Edition v.

+ 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
= 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.

November 15, 2007

Active Query Builder WinForms Edition v.

+ 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.

Product Summary

 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!

Social networks