Downloads

Active Query Builder History History

June 08, 2011

Active Query Builder History v.1.17.1

+ MS SQL Server: Table and query hints are supported; join hints are parsed
  fine now, but not preserved due to architecture limitations.
- SQLite: Parsing of sub-queries in condition cells is fixed.
- German translation: Wrong translation "Default"->"German" is reverted to
  "Default".
= MySQL: UNSIGNED is treated as a valid data type now.

June 08, 2011

Active Query Builder History v.1.4.1.1073

= Metadata loading is speeded up, memory usage is optimized.

May 26, 2011

Active Query Builder History v.1.15.0.305

= The LinkCreating and LinkCreated events will be also fired now for links 
  being automatically created from foreign keys.

May 23, 2011

Active Query Builder History v.1.4.0.1072

- MS SQL Server: Support of the DateAdd function is fixed.

May 20, 2011

Active Query Builder History v.1.4.0.1071

+ The new ActiveUnionSubQueryChanged event is added.
= MySQL Query Properties dialog is redesigned.
= The numbers entered into condition for string fields are treated as literals.
= Grouping is set automatically now on specifying the aggregate for a column.
= Automatic alias assignment is made when user adds two or more columns with 
  same name to the query. The warning message is shown when muptiple columns
  with same name appear in sub-queries in result of user actions as this may 
  lead to inconsistence in the calling sub-query.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.
- Diagram pane was not scrolling when dragging a table. Fixed now.
- MySQL: The SQL_NO_CACHE option in MySQL Query Properties dialog is fixed.

May 19, 2011

Active Query Builder History v.1.17.0

+ The new TacQueryBuilder.OnActiveUnionSubQueryChanged event is added.
+ SQL queries that look like "select orders.orderId from orders o" are fixed
  now to "select o.orderId from orders o".
= Grouping is set automatically now on specifying the aggregate for a column.
= The "=TRUE" condition is set automatically on adding a logical expression now.
= The numbers entered into condition for string fields are treated as literals.
= MySQL Query Properties form is redesigned.
+ MySQL: The [Default|DISTICTS|ALL] query options are added to the Query 
  Properties dialog.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.
- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.
- Minor bugs on reomving CTE from query are fixed.

May 19, 2011

Active Query Builder History v.1.17.0

+ The new properties are added to the LinkOptions group:
  CreateLinksByIdenticalFieldNames and CreateWhereJoinsByDefault.
  The first one is intended to instruct the component to add links between
  objects by identical field names (might be useful for legacy databases 
  without foreign keys). The second one instructs the component to create joins
  in WHERE clause, not using the JOIN keyword in FROM clause. Useful for Oracle
  databases when you want to use Oracle style joins (+=, =+).
+ SQL queries that look like "select orders.orderId from orders o" are fixed
  now to "select o.orderId from orders o".
= Grouping is set automatically now on specifying the aggregate for a column.
= The "=TRUE" condition is set automatically on adding a logical expression now.
= The numbers entered into condition for string fields are treated as literals.
= MySQL Query Properties form is redesigned.
+ MySQL: The [Default|DISTICTS|ALL] query options are added to the Query 
  Properties dialog.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.
- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.
- Minor bugs on reomving CTE from query are fixed.

May 18, 2011

Active Query Builder History v.1.15.0.304

+ The new ActiveUnionSubQueryChanged event is added.
= MySQL Query Properties form is redesigned.
= The Select checkbox is checked automatically now on adding a new expression.
= Grouping is set automatically now on specifying the aggregate for a column.
= The numbers entered into condition for string fields are treated as literals.
= The "=TRUE" condition is set automatically on adding a logical expression now.
- MS SQL Server: Fetching metadata object descriptions from database is made.
- Metadata refreshing for derived tables is fixed.

May 16, 2011

Active Query Builder History v.1.14.11.303

- Reworked the control's initialization for better handling of late-bound events.
- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.

May 16, 2011

Active Query Builder History v.1.3.4.1070

- Oracle: The TRANSLATE function and CAST-MULTISET-AS clause are fixed.

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:

News

Tweets

Testimonials

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